Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.plural_name AS plural_name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.locale AS locale_6,
  t0.translatable_id AS translatable_id_7,
  t8.parentLevel AS parentLevel_9,
  t8.peopleToCarry AS peopleToCarry_10,
  t8.carbon_foot_print AS carbon_foot_print_11,
  t8.active AS active_12,
  t8.slug AS slug_13,
  t8.volume_in_m3 AS volume_in_m3_14,
  t8.format AS format_15,
  t8.id AS id_16,
  t8.created_at AS created_at_17,
  t8.updated_at AS updated_at_18,
  t8.parent AS parent_19
FROM
  stuff_type_translation t0
  LEFT JOIN stuff_type t8 ON t0.translatable_id = t8.id
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.plural_name AS plural_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.parentLevel AS parentLevel_9, t8.peopleToCarry AS peopleToCarry_10, t8.carbon_foot_print AS carbon_foot_print_11, t8.active AS active_12, t8.slug AS slug_13, t8.volume_in_m3 AS volume_in_m3_14, t8.format AS format_15, t8.id AS id_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.parent AS parent_19 FROM stuff_type_translation t0 LEFT JOIN stuff_type t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = 19;

SELECT
  t0.count AS count_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.subject_id AS subject_id_5,
  t0.subject_type
FROM
  favorite_anonymous t0
WHERE
  t0.subject_id = ?
  AND t0.subject_type IN ('stuff')
LIMIT
  1

SELECT t0.count AS count_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.subject_id AS subject_id_5, t0.subject_type FROM favorite_anonymous t0 WHERE t0.subject_id = 1641 AND t0.subject_type IN ('stuff') LIMIT 1;

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  favorite f0_
WHERE
  (f0_.subject_id = ?)
  AND f0_.subject_type IN ('stuff')

SELECT COUNT(f0_.id) AS sclr_0 FROM favorite f0_ WHERE (f0_.subject_id = 1641) AND f0_.subject_type IN ('stuff');

SELECT
  s0_.reference AS reference_0,
  s0_.price AS price_1,
  s0_.buy_price AS buy_price_2,
  s0_.price_before_decrease AS price_before_decrease_3,
  s0_.age AS age_4,
  s0_.exact_age AS exact_age_5,
  s0_.state AS state_6,
  s0_.height_in_cm AS height_in_cm_7,
  s0_.width_in_cm AS width_in_cm_8,
  s0_.depth_in_cm AS depth_in_cm_9,
  s0_.description AS description_10,
  s0_.brand_legacy AS brand_legacy_11,
  s0_.model AS model_12,
  s0_.slug AS slug_13,
  s0_.partner_link AS partner_link_14,
  s0_.buy_date AS buy_date_15,
  s0_.soldByIzidore AS soldByIzidore_16,
  s0_.moderation_status AS moderation_status_17,
  s0_.last_moderation_date AS last_moderation_date_18,
  s0_.favorite AS favorite_19,
  s0_.custom_type AS custom_type_20,
  s0_.disabled AS disabled_21,
  s0_.disabled_reason AS disabled_reason_22,
  s0_.disabled_at AS disabled_at_23,
  s0_.completed_at AS completed_at_24,
  s0_.moderation_reason AS moderation_reason_25,
  s0_.creation_state AS creation_state_26,
  s0_.view AS view_27,
  s0_.updated_by_owner_at AS updated_by_owner_at_28,
  s0_.certified_at AS certified_at_29,
  s0_.certified AS certified_30,
  s0_.fixed_rate AS fixed_rate_31,
  s0_.title AS title_32,
  s0_.stuff_source AS stuff_source_33,
  s0_.colors AS colors_34,
  s0_.materials AS materials_35,
  s0_.quantity AS quantity_36,
  s0_.shop_reference AS shop_reference_37,
  s0_.depot_reference AS depot_reference_38,
  s0_.has_invoice AS has_invoice_39,
  s0_.warranty_end_date AS warranty_end_date_40,
  s0_.id AS id_41,
  s0_.uid AS uid_42,
  s0_.deleted_at AS deleted_at_43,
  s0_.created_at AS created_at_44,
  s0_.updated_at AS updated_at_45,
  a1_.reference AS reference_46,
  a1_.state AS state_47,
  a1_.rating AS rating_48,
  a1_.favorite AS favorite_49,
  a1_.lot AS lot_50,
  a1_.discount_percentage AS discount_percentage_51,
  a1_.cgv AS cgv_52,
  a1_.fee_checked AS fee_checked_53,
  a1_.end_date AS end_date_54,
  a1_.live_at AS live_at_55,
  a1_.scheduled_alert AS scheduled_alert_56,
  a1_.alert_order AS alert_order_57,
  a1_.rated_at AS rated_at_58,
  a1_.rated AS rated_59,
  a1_.phone AS phone_60,
  a1_.description AS description_61,
  a1_.has_online_payment AS has_online_payment_62,
  a1_.creation_reminder_email_sent AS creation_reminder_email_sent_63,
  a1_.decreasing_prices AS decreasing_prices_64,
  a1_.decreasing_prices_until AS decreasing_prices_until_65,
  a1_.global_decreasing_percentage AS global_decreasing_percentage_66,
  a1_.ground_floor_option AS ground_floor_option_67,
  a1_.cover_picture_name AS cover_picture_name_68,
  a1_.moderation_status AS moderation_status_69,
  a1_.last_moderation_date AS last_moderation_date_70,
  a1_.products_availability_update_date AS products_availability_update_date_71,
  a1_.first_completed_at AS first_completed_at_72,
  a1_.title AS title_73,
  a1_.is_manual_pickup AS is_manual_pickup_74,
  a1_.schedule AS schedule_75,
  a1_.contact_first_name AS contact_first_name_76,
  a1_.contact_last_name AS contact_last_name_77,
  a1_.contact_email AS contact_email_78,
  a1_.contact_phone_number AS contact_phone_number_79,
  a1_.localisation_type AS localisation_type_80,
  a1_.id AS id_81,
  a1_.uid AS uid_82,
  a1_.created_at AS created_at_83,
  a1_.updated_at AS updated_at_84,
  a2_.type AS type_85,
  a2_.address_full AS address_full_86,
  a2_.street_number AS street_number_87,
  a2_.route AS route_88,
  a2_.zip_code AS zip_code_89,
  a2_.city AS city_90,
  a2_.administrative_area_level1 AS administrative_area_level1_91,
  a2_.administrative_area_level2 AS administrative_area_level2_92,
  a2_.other AS other_93,
  a2_.lat AS lat_94,
  a2_.lng AS lng_95,
  a2_.country AS country_96,
  a2_.complement AS complement_97,
  a2_.floor AS floor_98,
  a2_.district AS district_99,
  a2_.elevator AS elevator_100,
  a2_.elevator_size AS elevator_size_101,
  a2_.id AS id_102,
  a2_.created_at AS created_at_103,
  a2_.updated_at AS updated_at_104,
  s3_.parentLevel AS parentLevel_105,
  s3_.peopleToCarry AS peopleToCarry_106,
  s3_.carbon_foot_print AS carbon_foot_print_107,
  s3_.active AS active_108,
  s3_.slug AS slug_109,
  s3_.volume_in_m3 AS volume_in_m3_110,
  s3_.format AS format_111,
  s3_.id AS id_112,
  s3_.created_at AS created_at_113,
  s3_.updated_at AS updated_at_114,
  s4_.id AS id_115,
  s4_.name AS name_116,
  s4_.plural_name AS plural_name_117,
  s4_.created_at AS created_at_118,
  s4_.updated_at AS updated_at_119,
  s4_.locale AS locale_120,
  b5_.name AS name_121,
  b5_.slug AS slug_122,
  b5_.is_main AS is_main_123,
  b5_.menu_rank AS menu_rank_124,
  b5_.default_partner_link AS default_partner_link_125,
  b5_.quality AS quality_126,
  b5_.id AS id_127,
  b5_.created_at AS created_at_128,
  b5_.updated_at AS updated_at_129,
  s6_.picture_name AS picture_name_130,
  s6_.number AS number_131,
  s6_.id AS id_132,
  s6_.created_at AS created_at_133,
  s6_.updated_at AS updated_at_134,
  s7_.id AS id_135,
  s7_.label AS label_136,
  s7_.name AS name_137,
  s7_.created_at AS created_at_138,
  s7_.updated_at AS updated_at_139,
  s8_.parentLevel AS parentLevel_140,
  s8_.peopleToCarry AS peopleToCarry_141,
  s8_.carbon_foot_print AS carbon_foot_print_142,
  s8_.active AS active_143,
  s8_.slug AS slug_144,
  s8_.volume_in_m3 AS volume_in_m3_145,
  s8_.format AS format_146,
  s8_.id AS id_147,
  s8_.created_at AS created_at_148,
  s8_.updated_at AS updated_at_149,
  s9_.parentLevel AS parentLevel_150,
  s9_.peopleToCarry AS peopleToCarry_151,
  s9_.carbon_foot_print AS carbon_foot_print_152,
  s9_.active AS active_153,
  s9_.slug AS slug_154,
  s9_.volume_in_m3 AS volume_in_m3_155,
  s9_.format AS format_156,
  s9_.id AS id_157,
  s9_.created_at AS created_at_158,
  s9_.updated_at AS updated_at_159,
  s0_.room_id AS room_id_160,
  s0_.announce_id AS announce_id_161,
  s0_.type_id AS type_id_162,
  s0_.brand_id AS brand_id_163,
  s0_.certified_by_id AS certified_by_id_164,
  s0_.pro_voucher_id AS pro_voucher_id_165,
  a1_.seller_id AS seller_id_166,
  a1_.address_id AS address_id_167,
  a1_.room_id AS room_id_168,
  a1_.sponsor_id AS sponsor_id_169,
  a1_.business_shop_id AS business_shop_id_170,
  a1_.created_by_id AS created_by_id_171,
  a1_.updated_by_id AS updated_by_id_172,
  a1_.deleted_by_id AS deleted_by_id_173,
  s3_.parent AS parent_174,
  s4_.translatable_id AS translatable_id_175,
  b5_.business_id AS business_id_176,
  b5_.pro_valuator_id AS pro_valuator_id_177,
  b5_.pro_voucher_id AS pro_voucher_id_178,
  s6_.stuff_id AS stuff_id_179,
  s6_.library_image_id AS library_image_id_180,
  s8_.parent AS parent_181,
  s9_.parent AS parent_182
FROM
  stuff s0_
  INNER JOIN announce a1_ ON s0_.announce_id = a1_.id
  INNER JOIN address a2_ ON a1_.address_id = a2_.id
  INNER JOIN stuff_type s3_ ON s0_.type_id = s3_.id
  LEFT JOIN stuff_type_translation s4_ ON s3_.id = s4_.translatable_id
  INNER JOIN brand b5_ ON s0_.brand_id = b5_.id
  LEFT JOIN stuff_picture s6_ ON s0_.id = s6_.stuff_id
  LEFT JOIN stuff__stuff_tag s10_ ON s0_.id = s10_.stuff_id
  LEFT JOIN stuff_tag s7_ ON s7_.id = s10_.tag_id
  LEFT JOIN stuff_type s8_ ON s3_.parent = s8_.id
  LEFT JOIN stuff_type s9_ ON s3_.id = s9_.parent
WHERE
  s0_.reference = ?

SELECT s0_.reference AS reference_0, s0_.price AS price_1, s0_.buy_price AS buy_price_2, s0_.price_before_decrease AS price_before_decrease_3, s0_.age AS age_4, s0_.exact_age AS exact_age_5, s0_.state AS state_6, s0_.height_in_cm AS height_in_cm_7, s0_.width_in_cm AS width_in_cm_8, s0_.depth_in_cm AS depth_in_cm_9, s0_.description AS description_10, s0_.brand_legacy AS brand_legacy_11, s0_.model AS model_12, s0_.slug AS slug_13, s0_.partner_link AS partner_link_14, s0_.buy_date AS buy_date_15, s0_.soldByIzidore AS soldByIzidore_16, s0_.moderation_status AS moderation_status_17, s0_.last_moderation_date AS last_moderation_date_18, s0_.favorite AS favorite_19, s0_.custom_type AS custom_type_20, s0_.disabled AS disabled_21, s0_.disabled_reason AS disabled_reason_22, s0_.disabled_at AS disabled_at_23, s0_.completed_at AS completed_at_24, s0_.moderation_reason AS moderation_reason_25, s0_.creation_state AS creation_state_26, s0_.view AS view_27, s0_.updated_by_owner_at AS updated_by_owner_at_28, s0_.certified_at AS certified_at_29, s0_.certified AS certified_30, s0_.fixed_rate AS fixed_rate_31, s0_.title AS title_32, s0_.stuff_source AS stuff_source_33, s0_.colors AS colors_34, s0_.materials AS materials_35, s0_.quantity AS quantity_36, s0_.shop_reference AS shop_reference_37, s0_.depot_reference AS depot_reference_38, s0_.has_invoice AS has_invoice_39, s0_.warranty_end_date AS warranty_end_date_40, s0_.id AS id_41, s0_.uid AS uid_42, s0_.deleted_at AS deleted_at_43, s0_.created_at AS created_at_44, s0_.updated_at AS updated_at_45, a1_.reference AS reference_46, a1_.state AS state_47, a1_.rating AS rating_48, a1_.favorite AS favorite_49, a1_.lot AS lot_50, a1_.discount_percentage AS discount_percentage_51, a1_.cgv AS cgv_52, a1_.fee_checked AS fee_checked_53, a1_.end_date AS end_date_54, a1_.live_at AS live_at_55, a1_.scheduled_alert AS scheduled_alert_56, a1_.alert_order AS alert_order_57, a1_.rated_at AS rated_at_58, a1_.rated AS rated_59, a1_.phone AS phone_60, a1_.description AS description_61, a1_.has_online_payment AS has_online_payment_62, a1_.creation_reminder_email_sent AS creation_reminder_email_sent_63, a1_.decreasing_prices AS decreasing_prices_64, a1_.decreasing_prices_until AS decreasing_prices_until_65, a1_.global_decreasing_percentage AS global_decreasing_percentage_66, a1_.ground_floor_option AS ground_floor_option_67, a1_.cover_picture_name AS cover_picture_name_68, a1_.moderation_status AS moderation_status_69, a1_.last_moderation_date AS last_moderation_date_70, a1_.products_availability_update_date AS products_availability_update_date_71, a1_.first_completed_at AS first_completed_at_72, a1_.title AS title_73, a1_.is_manual_pickup AS is_manual_pickup_74, a1_.schedule AS schedule_75, a1_.contact_first_name AS contact_first_name_76, a1_.contact_last_name AS contact_last_name_77, a1_.contact_email AS contact_email_78, a1_.contact_phone_number AS contact_phone_number_79, a1_.localisation_type AS localisation_type_80, a1_.id AS id_81, a1_.uid AS uid_82, a1_.created_at AS created_at_83, a1_.updated_at AS updated_at_84, a2_.type AS type_85, a2_.address_full AS address_full_86, a2_.street_number AS street_number_87, a2_.route AS route_88, a2_.zip_code AS zip_code_89, a2_.city AS city_90, a2_.administrative_area_level1 AS administrative_area_level1_91, a2_.administrative_area_level2 AS administrative_area_level2_92, a2_.other AS other_93, a2_.lat AS lat_94, a2_.lng AS lng_95, a2_.country AS country_96, a2_.complement AS complement_97, a2_.floor AS floor_98, a2_.district AS district_99, a2_.elevator AS elevator_100, a2_.elevator_size AS elevator_size_101, a2_.id AS id_102, a2_.created_at AS created_at_103, a2_.updated_at AS updated_at_104, s3_.parentLevel AS parentLevel_105, s3_.peopleToCarry AS peopleToCarry_106, s3_.carbon_foot_print AS carbon_foot_print_107, s3_.active AS active_108, s3_.slug AS slug_109, s3_.volume_in_m3 AS volume_in_m3_110, s3_.format AS format_111, s3_.id AS id_112, s3_.created_at AS created_at_113, s3_.updated_at AS updated_at_114, s4_.id AS id_115, s4_.name AS name_116, s4_.plural_name AS plural_name_117, s4_.created_at AS created_at_118, s4_.updated_at AS updated_at_119, s4_.locale AS locale_120, b5_.name AS name_121, b5_.slug AS slug_122, b5_.is_main AS is_main_123, b5_.menu_rank AS menu_rank_124, b5_.default_partner_link AS default_partner_link_125, b5_.quality AS quality_126, b5_.id AS id_127, b5_.created_at AS created_at_128, b5_.updated_at AS updated_at_129, s6_.picture_name AS picture_name_130, s6_.number AS number_131, s6_.id AS id_132, s6_.created_at AS created_at_133, s6_.updated_at AS updated_at_134, s7_.id AS id_135, s7_.label AS label_136, s7_.name AS name_137, s7_.created_at AS created_at_138, s7_.updated_at AS updated_at_139, s8_.parentLevel AS parentLevel_140, s8_.peopleToCarry AS peopleToCarry_141, s8_.carbon_foot_print AS carbon_foot_print_142, s8_.active AS active_143, s8_.slug AS slug_144, s8_.volume_in_m3 AS volume_in_m3_145, s8_.format AS format_146, s8_.id AS id_147, s8_.created_at AS created_at_148, s8_.updated_at AS updated_at_149, s9_.parentLevel AS parentLevel_150, s9_.peopleToCarry AS peopleToCarry_151, s9_.carbon_foot_print AS carbon_foot_print_152, s9_.active AS active_153, s9_.slug AS slug_154, s9_.volume_in_m3 AS volume_in_m3_155, s9_.format AS format_156, s9_.id AS id_157, s9_.created_at AS created_at_158, s9_.updated_at AS updated_at_159, s0_.room_id AS room_id_160, s0_.announce_id AS announce_id_161, s0_.type_id AS type_id_162, s0_.brand_id AS brand_id_163, s0_.certified_by_id AS certified_by_id_164, s0_.pro_voucher_id AS pro_voucher_id_165, a1_.seller_id AS seller_id_166, a1_.address_id AS address_id_167, a1_.room_id AS room_id_168, a1_.sponsor_id AS sponsor_id_169, a1_.business_shop_id AS business_shop_id_170, a1_.created_by_id AS created_by_id_171, a1_.updated_by_id AS updated_by_id_172, a1_.deleted_by_id AS deleted_by_id_173, s3_.parent AS parent_174, s4_.translatable_id AS translatable_id_175, b5_.business_id AS business_id_176, b5_.pro_valuator_id AS pro_valuator_id_177, b5_.pro_voucher_id AS pro_voucher_id_178, s6_.stuff_id AS stuff_id_179, s6_.library_image_id AS library_image_id_180, s8_.parent AS parent_181, s9_.parent AS parent_182 FROM stuff s0_ INNER JOIN announce a1_ ON s0_.announce_id = a1_.id INNER JOIN address a2_ ON a1_.address_id = a2_.id INNER JOIN stuff_type s3_ ON s0_.type_id = s3_.id LEFT JOIN stuff_type_translation s4_ ON s3_.id = s4_.translatable_id INNER JOIN brand b5_ ON s0_.brand_id = b5_.id LEFT JOIN stuff_picture s6_ ON s0_.id = s6_.stuff_id LEFT JOIN stuff__stuff_tag s10_ ON s0_.id = s10_.stuff_id LEFT JOIN stuff_tag s7_ ON s7_.id = s10_.tag_id LEFT JOIN stuff_type s8_ ON s3_.parent = s8_.id LEFT JOIN stuff_type s9_ ON s3_.id = s9_.parent WHERE s0_.reference = 'B28D0';

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.logo_id AS logo_id_4,
  t0.user_business_id AS user_business_id_5,
  t0.brand_id AS brand_id_6,
  t7.name AS name_8,
  t7.slug AS slug_9,
  t7.is_main AS is_main_10,
  t7.menu_rank AS menu_rank_11,
  t7.default_partner_link AS default_partner_link_12,
  t7.quality AS quality_13,
  t7.id AS id_14,
  t7.created_at AS created_at_15,
  t7.updated_at AS updated_at_16,
  t7.business_id AS business_id_17,
  t7.pro_valuator_id AS pro_valuator_id_18,
  t7.pro_voucher_id AS pro_voucher_id_19
FROM
  pro_certificator t0
  LEFT JOIN brand t7 ON t0.brand_id = t7.id
WHERE
  t0.brand_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo_id AS logo_id_4, t0.user_business_id AS user_business_id_5, t0.brand_id AS brand_id_6, t7.name AS name_8, t7.slug AS slug_9, t7.is_main AS is_main_10, t7.menu_rank AS menu_rank_11, t7.default_partner_link AS default_partner_link_12, t7.quality AS quality_13, t7.id AS id_14, t7.created_at AS created_at_15, t7.updated_at AS updated_at_16, t7.business_id AS business_id_17, t7.pro_valuator_id AS pro_valuator_id_18, t7.pro_voucher_id AS pro_voucher_id_19 FROM pro_certificator t0 LEFT JOIN brand t7 ON t0.brand_id = t7.id WHERE t0.brand_id = 157;

SELECT
  t0.picture_name AS picture_name_1,
  t0.number AS number_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.stuff_id AS stuff_id_6,
  t0.library_image_id AS library_image_id_7
FROM
  stuff_picture t0
WHERE
  t0.stuff_id IN (?)

SELECT t0.picture_name AS picture_name_1, t0.number AS number_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.stuff_id AS stuff_id_6, t0.library_image_id AS library_image_id_7 FROM stuff_picture t0 WHERE t0.stuff_id IN (1644);

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'test_izidore_2'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.paris_area AS paris_area_3,
  t0.provinces_area AS provinces_area_4,
  t0.fixed_price AS fixed_price_5,
  t0.has_reduce_price AS has_reduce_price_6,
  t0.has_reduce_price_cond AS has_reduce_price_cond_7,
  t0.min_price_for_reduce_price AS min_price_for_reduce_price_8,
  t0.reduce_price AS reduce_price_9,
  t0.mango_pay_id AS mango_pay_id_10,
  t0.mango_pay_wallet_id AS mango_pay_wallet_id_11,
  t0.free AS free_12,
  t0.require_stuff_type_acceptation AS require_stuff_type_acceptation_13,
  t0.disabled AS disabled_14,
  t0.after_order_buyer_sendinblue_template_id AS after_order_buyer_sendinblue_template_id_15,
  t0.after_order_confirmation_buyer_sendinblue_template_id AS after_order_confirmation_buyer_sendinblue_template_id_16,
  t0.after_order_seller_sendinblue_template_id AS after_order_seller_sendinblue_template_id_17,
  t0.after_order_confirmation_seller_sendinblue_template_id AS after_order_confirmation_seller_sendinblue_template_id_18,
  t0.description AS description_19,
  t0.label AS label_20,
  t0.id AS id_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.bank_account_id AS bank_account_id_24
FROM
  delivery_provider t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.paris_area AS paris_area_3, t0.provinces_area AS provinces_area_4, t0.fixed_price AS fixed_price_5, t0.has_reduce_price AS has_reduce_price_6, t0.has_reduce_price_cond AS has_reduce_price_cond_7, t0.min_price_for_reduce_price AS min_price_for_reduce_price_8, t0.reduce_price AS reduce_price_9, t0.mango_pay_id AS mango_pay_id_10, t0.mango_pay_wallet_id AS mango_pay_wallet_id_11, t0.free AS free_12, t0.require_stuff_type_acceptation AS require_stuff_type_acceptation_13, t0.disabled AS disabled_14, t0.after_order_buyer_sendinblue_template_id AS after_order_buyer_sendinblue_template_id_15, t0.after_order_confirmation_buyer_sendinblue_template_id AS after_order_confirmation_buyer_sendinblue_template_id_16, t0.after_order_seller_sendinblue_template_id AS after_order_seller_sendinblue_template_id_17, t0.after_order_confirmation_seller_sendinblue_template_id AS after_order_confirmation_seller_sendinblue_template_id_18, t0.description AS description_19, t0.label AS label_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.bank_account_id AS bank_account_id_24 FROM delivery_provider t0 WHERE t0.id = 9;

SELECT
  t0.stuffs_price_in_cent AS stuffs_price_in_cent_1,
  t0.buyer_fees_in_cent AS buyer_fees_in_cent_2,
  t0.buyer_price_in_cent AS buyer_price_in_cent_3,
  t0.buyer_price_with_voucher_in_cent AS buyer_price_with_voucher_in_cent_4,
  t0.seller_fees_in_cent AS seller_fees_in_cent_5,
  t0.buyer_fees_percentage AS buyer_fees_percentage_6,
  t0.buyer_fees_flat_amount_in_cents AS buyer_fees_flat_amount_in_cents_7,
  t0.seller_fees_percentage AS seller_fees_percentage_8,
  t0.seller_fees_flat_amount_in_cents AS seller_fees_flat_amount_in_cents_9,
  t0.seller_credited_amount_in_cent AS seller_credited_amount_in_cent_10,
  t0.state AS state_11,
  t0.confirmed_at AS confirmed_at_12,
  t0.confirmed_stuff_count AS confirmed_stuff_count_13,
  t0.canceled_at AS canceled_at_14,
  t0.auto_cancel_at AS auto_cancel_at_15,
  t0.delivered_at AS delivered_at_16,
  t0.auto_deliver_at AS auto_deliver_at_17,
  t0.archived_at AS archived_at_18,
  t0.refunded_at AS refunded_at_19,
  t0.reference AS reference_20,
  t0.delivery_type AS delivery_type_21,
  t0.seller_sms_at AS seller_sms_at_22,
  t0.voucher_value_in_cents AS voucher_value_in_cents_23,
  t0.voucher_requested_at AS voucher_requested_at_24,
  t0.voucher_sent_at AS voucher_sent_at_25,
  t0.voucher_refference AS voucher_refference_26,
  t0.id AS id_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.buyer_id AS buyer_id_30,
  t0.seller_id AS seller_id_31,
  t0.announce_id AS announce_id_32,
  t0.payment_authorization_id AS payment_authorization_id_33,
  t0.withdrawal_id AS withdrawal_id_34,
  t35.distance AS distance_36,
  t35.email AS email_37,
  t35.phone AS phone_38,
  t35.price AS price_39,
  t35.fees AS fees_40,
  t35.price_min AS price_min_41,
  t35.price_max AS price_max_42,
  t35.type AS type_43,
  t35.buyer_availability AS buyer_availability_44,
  t35.seller_availability AS seller_availability_45,
  t35.has_reduce_price AS has_reduce_price_46,
  t35.reduce_price AS reduce_price_47,
  t35.id AS id_48,
  t35.created_at AS created_at_49,
  t35.updated_at AS updated_at_50,
  t35.announce_id AS announce_id_51,
  t35.origin_address_id AS origin_address_id_52,
  t35.delivery_address_id AS delivery_address_id_53,
  t35.order_id AS order_id_54,
  t35.provider_id AS provider_id_55,
  t0.delivery_address_id AS delivery_address_id_56,
  t0.voucher_id AS voucher_id_57,
  t0.pro_voucher_id AS pro_voucher_id_58
FROM
  announce_order t0
  LEFT JOIN delivery t35 ON t35.order_id = t0.id
WHERE
  t0.announce_id = ?

SELECT t0.stuffs_price_in_cent AS stuffs_price_in_cent_1, t0.buyer_fees_in_cent AS buyer_fees_in_cent_2, t0.buyer_price_in_cent AS buyer_price_in_cent_3, t0.buyer_price_with_voucher_in_cent AS buyer_price_with_voucher_in_cent_4, t0.seller_fees_in_cent AS seller_fees_in_cent_5, t0.buyer_fees_percentage AS buyer_fees_percentage_6, t0.buyer_fees_flat_amount_in_cents AS buyer_fees_flat_amount_in_cents_7, t0.seller_fees_percentage AS seller_fees_percentage_8, t0.seller_fees_flat_amount_in_cents AS seller_fees_flat_amount_in_cents_9, t0.seller_credited_amount_in_cent AS seller_credited_amount_in_cent_10, t0.state AS state_11, t0.confirmed_at AS confirmed_at_12, t0.confirmed_stuff_count AS confirmed_stuff_count_13, t0.canceled_at AS canceled_at_14, t0.auto_cancel_at AS auto_cancel_at_15, t0.delivered_at AS delivered_at_16, t0.auto_deliver_at AS auto_deliver_at_17, t0.archived_at AS archived_at_18, t0.refunded_at AS refunded_at_19, t0.reference AS reference_20, t0.delivery_type AS delivery_type_21, t0.seller_sms_at AS seller_sms_at_22, t0.voucher_value_in_cents AS voucher_value_in_cents_23, t0.voucher_requested_at AS voucher_requested_at_24, t0.voucher_sent_at AS voucher_sent_at_25, t0.voucher_refference AS voucher_refference_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.buyer_id AS buyer_id_30, t0.seller_id AS seller_id_31, t0.announce_id AS announce_id_32, t0.payment_authorization_id AS payment_authorization_id_33, t0.withdrawal_id AS withdrawal_id_34, t35.distance AS distance_36, t35.email AS email_37, t35.phone AS phone_38, t35.price AS price_39, t35.fees AS fees_40, t35.price_min AS price_min_41, t35.price_max AS price_max_42, t35.type AS type_43, t35.buyer_availability AS buyer_availability_44, t35.seller_availability AS seller_availability_45, t35.has_reduce_price AS has_reduce_price_46, t35.reduce_price AS reduce_price_47, t35.id AS id_48, t35.created_at AS created_at_49, t35.updated_at AS updated_at_50, t35.announce_id AS announce_id_51, t35.origin_address_id AS origin_address_id_52, t35.delivery_address_id AS delivery_address_id_53, t35.order_id AS order_id_54, t35.provider_id AS provider_id_55, t0.delivery_address_id AS delivery_address_id_56, t0.voucher_id AS voucher_id_57, t0.pro_voucher_id AS pro_voucher_id_58 FROM announce_order t0 LEFT JOIN delivery t35 ON t35.order_id = t0.id WHERE t0.announce_id = 1730;

SELECT
  t0.reference AS reference_1,
  t0.price AS price_2,
  t0.buy_price AS buy_price_3,
  t0.price_before_decrease AS price_before_decrease_4,
  t0.age AS age_5,
  t0.exact_age AS exact_age_6,
  t0.state AS state_7,
  t0.height_in_cm AS height_in_cm_8,
  t0.width_in_cm AS width_in_cm_9,
  t0.depth_in_cm AS depth_in_cm_10,
  t0.description AS description_11,
  t0.brand_legacy AS brand_legacy_12,
  t0.model AS model_13,
  t0.slug AS slug_14,
  t0.partner_link AS partner_link_15,
  t0.buy_date AS buy_date_16,
  t0.soldByIzidore AS soldByIzidore_17,
  t0.moderation_status AS moderation_status_18,
  t0.last_moderation_date AS last_moderation_date_19,
  t0.favorite AS favorite_20,
  t0.custom_type AS custom_type_21,
  t0.disabled AS disabled_22,
  t0.disabled_reason AS disabled_reason_23,
  t0.disabled_at AS disabled_at_24,
  t0.completed_at AS completed_at_25,
  t0.moderation_reason AS moderation_reason_26,
  t0.creation_state AS creation_state_27,
  t0.view AS view_28,
  t0.updated_by_owner_at AS updated_by_owner_at_29,
  t0.certified_at AS certified_at_30,
  t0.certified AS certified_31,
  t0.fixed_rate AS fixed_rate_32,
  t0.title AS title_33,
  t0.stuff_source AS stuff_source_34,
  t0.colors AS colors_35,
  t0.materials AS materials_36,
  t0.quantity AS quantity_37,
  t0.shop_reference AS shop_reference_38,
  t0.depot_reference AS depot_reference_39,
  t0.has_invoice AS has_invoice_40,
  t0.warranty_end_date AS warranty_end_date_41,
  t0.id AS id_42,
  t0.uid AS uid_43,
  t0.deleted_at AS deleted_at_44,
  t0.created_at AS created_at_45,
  t0.updated_at AS updated_at_46,
  t0.room_id AS room_id_47,
  t0.announce_id AS announce_id_48,
  t0.type_id AS type_id_49,
  t50.parentLevel AS parentLevel_51,
  t50.peopleToCarry AS peopleToCarry_52,
  t50.carbon_foot_print AS carbon_foot_print_53,
  t50.active AS active_54,
  t50.slug AS slug_55,
  t50.volume_in_m3 AS volume_in_m3_56,
  t50.format AS format_57,
  t50.id AS id_58,
  t50.created_at AS created_at_59,
  t50.updated_at AS updated_at_60,
  t50.parent AS parent_61,
  t0.brand_id AS brand_id_62,
  t63.name AS name_64,
  t63.slug AS slug_65,
  t63.is_main AS is_main_66,
  t63.menu_rank AS menu_rank_67,
  t63.default_partner_link AS default_partner_link_68,
  t63.quality AS quality_69,
  t63.id AS id_70,
  t63.created_at AS created_at_71,
  t63.updated_at AS updated_at_72,
  t63.business_id AS business_id_73,
  t63.pro_valuator_id AS pro_valuator_id_74,
  t63.pro_voucher_id AS pro_voucher_id_75,
  t0.certified_by_id AS certified_by_id_76,
  t0.pro_voucher_id AS pro_voucher_id_77
FROM
  stuff t0
  LEFT JOIN stuff_type t50 ON t0.type_id = t50.id
  LEFT JOIN brand t63 ON t0.brand_id = t63.id
WHERE
  t0.announce_id IN (?)