Symfony Profiler

SELECT
  t0.price AS price_1,
  t0.price_min AS price_min_2,
  t0.price_max AS price_max_3,
  t0.delivery_accepted AS delivery_accepted_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.stuff_type_id AS stuff_type_id_8,
  t0.provider_id AS provider_id_9
FROM
  delivery_provider_stuff_type_policy t0
WHERE
  t0.stuff_type_id = ?

SELECT t0.price AS price_1, t0.price_min AS price_min_2, t0.price_max AS price_max_3, t0.delivery_accepted AS delivery_accepted_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.stuff_type_id AS stuff_type_id_8, t0.provider_id AS provider_id_9 FROM delivery_provider_stuff_type_policy t0 WHERE t0.stuff_type_id = 66;

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
  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 = 'DF0DB';

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 = 11;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.enabled AS enabled_5,
  t0.type AS type_6,
  t0.disabled AS disabled_7,
  t0.source AS source_8,
  t0.civility AS civility_9,
  t0.firstname AS firstname_10,
  t0.lastname AS lastname_11,
  t0.optin_partenaires AS optin_partenaires_12,
  t0.cgv_validation AS cgv_validation_13,
  t0.birthdate AS birthdate_14,
  t0.phone AS phone_15,
  t0.validated_at AS validated_at_16,
  t0.email_validated_at AS email_validated_at_17,
  t0.phone_validated_at AS phone_validated_at_18,
  t0.city AS city_19,
  t0.picture_name AS picture_name_20,
  t0.mango_pay_id AS mango_pay_id_21,
  t0.mango_pay_wallet_id AS mango_pay_wallet_id_22,
  t0.kyc_level AS kyc_level_23,
  t0.nationality AS nationality_24,
  t0.country AS country_25,
  t0.delivery_preference AS delivery_preference_26,
  t0.allowed_unlimited_messages AS allowed_unlimited_messages_27,
  t0.last_login AS last_login_28,
  t0.sms_code AS sms_code_29,
  t0.sms_code_expired_at AS sms_code_expired_at_30,
  t0.sms_code_failed AS sms_code_failed_31,
  t0.granted_voucher_creation AS granted_voucher_creation_32,
  t0.uid AS uid_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35,
  t0.address_id AS address_id_36,
  t0.utm_campaign_id AS utm_campaign_id_37,
  t38.id AS id_39,
  t38.card_registration_id AS card_registration_id_40,
  t38.browser_info AS browser_info_41,
  t38.created_at AS created_at_42,
  t38.updated_at AS updated_at_43,
  t38.user_id AS user_id_44,
  t38.delivery_id AS delivery_id_45,
  t38.voucher_id AS voucher_id_46,
  t47.id AS id_48,
  t47.mandatory AS mandatory_49,
  t47.message AS message_50,
  t47.favorite AS favorite_51,
  t47.alert AS alert_52,
  t47.tips AS tips_53,
  t47.news AS news_54,
  t47.created_at AS created_at_55,
  t47.updated_at AS updated_at_56,
  t47.user_id AS user_id_57,
  t58.id AS id_59,
  t58.company_number AS company_number_60,
  t58.company_name AS company_name_61,
  t58.legal_representative_firstname AS legal_representative_firstname_62,
  t58.legal_representative_lastname AS legal_representative_lastname_63,
  t58.created_at AS created_at_64,
  t58.updated_at AS updated_at_65,
  t58.address_id AS address_id_66,
  t58.owner_id AS owner_id_67,
  t0.last_agreed_cgu_id AS last_agreed_cgu_id_68,
  t0.user_business_id AS user_business_id_69
FROM
  user t0
  LEFT JOIN cart t38 ON t38.user_id = t0.id
  LEFT JOIN notification_preferences t47 ON t47.user_id = t0.id
  LEFT JOIN business t58 ON t58.owner_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.type AS type_6, t0.disabled AS disabled_7, t0.source AS source_8, t0.civility AS civility_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.optin_partenaires AS optin_partenaires_12, t0.cgv_validation AS cgv_validation_13, t0.birthdate AS birthdate_14, t0.phone AS phone_15, t0.validated_at AS validated_at_16, t0.email_validated_at AS email_validated_at_17, t0.phone_validated_at AS phone_validated_at_18, t0.city AS city_19, t0.picture_name AS picture_name_20, t0.mango_pay_id AS mango_pay_id_21, t0.mango_pay_wallet_id AS mango_pay_wallet_id_22, t0.kyc_level AS kyc_level_23, t0.nationality AS nationality_24, t0.country AS country_25, t0.delivery_preference AS delivery_preference_26, t0.allowed_unlimited_messages AS allowed_unlimited_messages_27, t0.last_login AS last_login_28, t0.sms_code AS sms_code_29, t0.sms_code_expired_at AS sms_code_expired_at_30, t0.sms_code_failed AS sms_code_failed_31, t0.granted_voucher_creation AS granted_voucher_creation_32, t0.uid AS uid_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.address_id AS address_id_36, t0.utm_campaign_id AS utm_campaign_id_37, t38.id AS id_39, t38.card_registration_id AS card_registration_id_40, t38.browser_info AS browser_info_41, t38.created_at AS created_at_42, t38.updated_at AS updated_at_43, t38.user_id AS user_id_44, t38.delivery_id AS delivery_id_45, t38.voucher_id AS voucher_id_46, t47.id AS id_48, t47.mandatory AS mandatory_49, t47.message AS message_50, t47.favorite AS favorite_51, t47.alert AS alert_52, t47.tips AS tips_53, t47.news AS news_54, t47.created_at AS created_at_55, t47.updated_at AS updated_at_56, t47.user_id AS user_id_57, t58.id AS id_59, t58.company_number AS company_number_60, t58.company_name AS company_name_61, t58.legal_representative_firstname AS legal_representative_firstname_62, t58.legal_representative_lastname AS legal_representative_lastname_63, t58.created_at AS created_at_64, t58.updated_at AS updated_at_65, t58.address_id AS address_id_66, t58.owner_id AS owner_id_67, t0.last_agreed_cgu_id AS last_agreed_cgu_id_68, t0.user_business_id AS user_business_id_69 FROM user t0 LEFT JOIN cart t38 ON t38.user_id = t0.id LEFT JOIN notification_preferences t47 ON t47.user_id = t0.id LEFT JOIN business t58 ON t58.owner_id = t0.id WHERE t0.id = 94534;

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 (?)

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 (1863);