1 |
0.80 ms |
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.value AS value_2, p0_.amount AS amount_3, p0_.type AS type_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.date_begin AS date_begin_7, p0_.date_end AS date_end_8, p0_.percentage AS percentage_9, p0_.description AS description_10, p0_.minimal_booking_days AS minimal_booking_days_11, p0_.date_purchase_start AS date_purchase_start_12, p0_.date_purchase_end AS date_purchase_end_13, a1_.id AS id_14, a1_.name AS name_15, a1_.type AS type_16, a1_.description AS description_17, a1_.picture AS picture_18, a1_.reference AS reference_19, a1_.phone AS phone_20, a1_.email AS email_21, a1_.is_visible AS is_visible_22, a1_.is_open AS is_open_23, a1_.updated_at AS updated_at_24, c2_.id AS id_25, c2_.name AS name_26, c2_.siren AS siren_27, c2_.siret AS siret_28, c2_.creation_date AS creation_date_29, c2_.tvaintra AS tvaintra_30, v3_.id AS id_31, v3_.country AS country_32, v3_.country_code AS country_code_33, v3_.standard_rate AS standard_rate_34, v3_.parking_rate AS parking_rate_35, v3_.reduced_rate1 AS reduced_rate1_36, v3_.reduced_rate2 AS reduced_rate2_37, v3_.super_reduced_rate AS super_reduced_rate_38, v3_.zero_rate AS zero_rate_39, p4_.id AS id_40, p4_.label AS label_41, p4_.type AS type_42, p4_.reference AS reference_43, p4_.updated_at AS updated_at_44, b5_.id AS id_45, b5_.price AS price_46, b5_.quantity AS quantity_47, b5_.vat_amount AS vat_amount_48, p6_.id AS id_49, p6_.type AS type_50, p6_.label AS label_51, p6_.updated_at AS updated_at_52, a7_.id AS id_53, a7_.label AS label_54, a7_.description AS description_55, a7_.price AS price_56, a7_.date_begin AS date_begin_57, a7_.date_end AS date_end_58, a7_.updated_at AS updated_at_59, a7_.is_activity_calculated_per_day AS is_activity_calculated_per_day_60, a7_.is_activity_calculated_per_booking AS is_activity_calculated_per_booking_61, i8_.id AS id_62, i8_.label AS label_63, i8_.description AS description_64, i8_.price AS price_65, i8_.updated_at AS updated_at_66, b9_.id AS id_67, b9_.reference AS reference_68, b9_.date_begin AS date_begin_69, b9_.date_end AS date_end_70, b9_.total_price AS total_price_71, b9_.total_days AS total_days_72, b9_.created_at AS created_at_73, b9_.status AS status_74, b9_.estimate_id AS estimate_id_75, b9_.updated_at AS updated_at_76, a10_.id AS id_77, a10_.name AS name_78, a10_.type AS type_79, a10_.description AS description_80, a10_.picture AS picture_81, a10_.reference AS reference_82, a10_.phone AS phone_83, a10_.email AS email_84, a10_.is_visible AS is_visible_85, a10_.is_open AS is_open_86, a10_.updated_at AS updated_at_87, c11_.id AS id_88, c11_.name AS name_89, c11_.siren AS siren_90, c11_.siret AS siret_91, c11_.creation_date AS creation_date_92, c11_.tvaintra AS tvaintra_93, v12_.id AS id_94, v12_.country AS country_95, v12_.country_code AS country_code_96, v12_.standard_rate AS standard_rate_97, v12_.parking_rate AS parking_rate_98, v12_.reduced_rate1 AS reduced_rate1_99, v12_.reduced_rate2 AS reduced_rate2_100, v12_.super_reduced_rate AS super_reduced_rate_101, v12_.zero_rate AS zero_rate_102, c13_.id AS id_103, c13_.first_name AS first_name_104, c13_.last_name AS last_name_105, c13_.is_activated AS is_activated_106, c13_.email AS email_107, c13_.phone AS phone_108, c13_.birth_date AS birth_date_109, c13_.language AS language_110, c13_.created_at AS created_at_111, c13_.updated_at AS updated_at_112, c13_.password AS password_113, c13_.rattache_company AS rattache_company_114, a1_.company_id AS company_id_115, a1_.vat_id AS vat_id_116, a1_.currency_id AS currency_id_117, b5_.product_id AS product_id_118, b5_.activity_id AS activity_id_119, b5_.insurance_id AS insurance_id_120, b5_.booking_id AS booking_id_121, b5_.estimate_id AS estimate_id_122, b5_.promotion_code_id AS promotion_code_id_123, p6_.model_id AS model_id_124, p6_.product_category_id AS product_category_id_125, p6_.vehicle_document_id AS vehicle_document_id_126, p6_.agency_id AS agency_id_127, b9_.user_id AS user_id_128, b9_.booking_agency_source_id AS booking_agency_source_id_129, b9_.booking_agency_target_id AS booking_agency_target_id_130, b9_.customer_id AS customer_id_131, a10_.company_id AS company_id_132, a10_.vat_id AS vat_id_133, a10_.currency_id AS currency_id_134 FROM promotion_code p0_ LEFT JOIN promotion_code_agency p14_ ON p0_.id = p14_.promotion_code_id LEFT JOIN agency a1_ ON a1_.id = p14_.agency_id LEFT JOIN company c2_ ON a1_.company_id = c2_.id LEFT JOIN vat v3_ ON a1_.vat_id = v3_.id LEFT JOIN promotion_code_product_category p15_ ON p0_.id = p15_.promotion_code_id LEFT JOIN product_category p4_ ON p4_.id = p15_.product_category_id LEFT JOIN booking_item b5_ ON p0_.id = b5_.promotion_code_id LEFT JOIN product p6_ ON b5_.product_id = p6_.id LEFT JOIN activity a7_ ON b5_.activity_id = a7_.id LEFT JOIN insurance i8_ ON b5_.insurance_id = i8_.id LEFT JOIN booking b9_ ON b5_.booking_id = b9_.id LEFT JOIN agency a10_ ON b9_.booking_agency_source_id = a10_.id LEFT JOIN company c11_ ON a10_.company_id = c11_.id LEFT JOIN vat v12_ ON a10_.vat_id = v12_.id LEFT JOIN customer c13_ ON b9_.customer_id = c13_.id WHERE p0_.id = ?
SELECT
p0_.id AS id_0,
p0_.label AS label_1,
p0_.value AS value_2,
p0_.amount AS amount_3,
p0_.type AS type_4,
p0_.created_at AS created_at_5,
p0_.updated_at AS updated_at_6,
p0_.date_begin AS date_begin_7,
p0_.date_end AS date_end_8,
p0_.percentage AS percentage_9,
p0_.description AS description_10,
p0_.minimal_booking_days AS minimal_booking_days_11,
p0_.date_purchase_start AS date_purchase_start_12,
p0_.date_purchase_end AS date_purchase_end_13,
a1_.id AS id_14,
a1_.name AS name_15,
a1_.type AS type_16,
a1_.description AS description_17,
a1_.picture AS picture_18,
a1_.reference AS reference_19,
a1_.phone AS phone_20,
a1_.email AS email_21,
a1_.is_visible AS is_visible_22,
a1_.is_open AS is_open_23,
a1_.updated_at AS updated_at_24,
c2_.id AS id_25,
c2_.name AS name_26,
c2_.siren AS siren_27,
c2_.siret AS siret_28,
c2_.creation_date AS creation_date_29,
c2_.tvaintra AS tvaintra_30,
v3_.id AS id_31,
v3_.country AS country_32,
v3_.country_code AS country_code_33,
v3_.standard_rate AS standard_rate_34,
v3_.parking_rate AS parking_rate_35,
v3_.reduced_rate1 AS reduced_rate1_36,
v3_.reduced_rate2 AS reduced_rate2_37,
v3_.super_reduced_rate AS super_reduced_rate_38,
v3_.zero_rate AS zero_rate_39,
p4_.id AS id_40,
p4_.label AS label_41,
p4_.type AS type_42,
p4_.reference AS reference_43,
p4_.updated_at AS updated_at_44,
b5_.id AS id_45,
b5_.price AS price_46,
b5_.quantity AS quantity_47,
b5_.vat_amount AS vat_amount_48,
p6_.id AS id_49,
p6_.type AS type_50,
p6_.label AS label_51,
p6_.updated_at AS updated_at_52,
a7_.id AS id_53,
a7_.label AS label_54,
a7_.description AS description_55,
a7_.price AS price_56,
a7_.date_begin AS date_begin_57,
a7_.date_end AS date_end_58,
a7_.updated_at AS updated_at_59,
a7_.is_activity_calculated_per_day AS is_activity_calculated_per_day_60,
a7_.is_activity_calculated_per_booking AS is_activity_calculated_per_booking_61,
i8_.id AS id_62,
i8_.label AS label_63,
i8_.description AS description_64,
i8_.price AS price_65,
i8_.updated_at AS updated_at_66,
b9_.id AS id_67,
b9_.reference AS reference_68,
b9_.date_begin AS date_begin_69,
b9_.date_end AS date_end_70,
b9_.total_price AS total_price_71,
b9_.total_days AS total_days_72,
b9_.created_at AS created_at_73,
b9_.status AS status_74,
b9_.estimate_id AS estimate_id_75,
b9_.updated_at AS updated_at_76,
a10_.id AS id_77,
a10_.name AS name_78,
a10_.type AS type_79,
a10_.description AS description_80,
a10_.picture AS picture_81,
a10_.reference AS reference_82,
a10_.phone AS phone_83,
a10_.email AS email_84,
a10_.is_visible AS is_visible_85,
a10_.is_open AS is_open_86,
a10_.updated_at AS updated_at_87,
c11_.id AS id_88,
c11_.name AS name_89,
c11_.siren AS siren_90,
c11_.siret AS siret_91,
c11_.creation_date AS creation_date_92,
c11_.tvaintra AS tvaintra_93,
v12_.id AS id_94,
v12_.country AS country_95,
v12_.country_code AS country_code_96,
v12_.standard_rate AS standard_rate_97,
v12_.parking_rate AS parking_rate_98,
v12_.reduced_rate1 AS reduced_rate1_99,
v12_.reduced_rate2 AS reduced_rate2_100,
v12_.super_reduced_rate AS super_reduced_rate_101,
v12_.zero_rate AS zero_rate_102,
c13_.id AS id_103,
c13_.first_name AS first_name_104,
c13_.last_name AS last_name_105,
c13_.is_activated AS is_activated_106,
c13_.email AS email_107,
c13_.phone AS phone_108,
c13_.birth_date AS birth_date_109,
c13_.language AS language_110,
c13_.created_at AS created_at_111,
c13_.updated_at AS updated_at_112,
c13_.password AS password_113,
c13_.rattache_company AS rattache_company_114,
a1_.company_id AS company_id_115,
a1_.vat_id AS vat_id_116,
a1_.currency_id AS currency_id_117,
b5_.product_id AS product_id_118,
b5_.activity_id AS activity_id_119,
b5_.insurance_id AS insurance_id_120,
b5_.booking_id AS booking_id_121,
b5_.estimate_id AS estimate_id_122,
b5_.promotion_code_id AS promotion_code_id_123,
p6_.model_id AS model_id_124,
p6_.product_category_id AS product_category_id_125,
p6_.vehicle_document_id AS vehicle_document_id_126,
p6_.agency_id AS agency_id_127,
b9_.user_id AS user_id_128,
b9_.booking_agency_source_id AS booking_agency_source_id_129,
b9_.booking_agency_target_id AS booking_agency_target_id_130,
b9_.customer_id AS customer_id_131,
a10_.company_id AS company_id_132,
a10_.vat_id AS vat_id_133,
a10_.currency_id AS currency_id_134
FROM
promotion_code p0_
LEFT JOIN promotion_code_agency p14_ ON p0_.id = p14_.promotion_code_id
LEFT JOIN agency a1_ ON a1_.id = p14_.agency_id
LEFT JOIN company c2_ ON a1_.company_id = c2_.id
LEFT JOIN vat v3_ ON a1_.vat_id = v3_.id
LEFT JOIN promotion_code_product_category p15_ ON p0_.id = p15_.promotion_code_id
LEFT JOIN product_category p4_ ON p4_.id = p15_.product_category_id
LEFT JOIN booking_item b5_ ON p0_.id = b5_.promotion_code_id
LEFT JOIN product p6_ ON b5_.product_id = p6_.id
LEFT JOIN activity a7_ ON b5_.activity_id = a7_.id
LEFT JOIN insurance i8_ ON b5_.insurance_id = i8_.id
LEFT JOIN booking b9_ ON b5_.booking_id = b9_.id
LEFT JOIN agency a10_ ON b9_.booking_agency_source_id = a10_.id
LEFT JOIN company c11_ ON a10_.company_id = c11_.id
LEFT JOIN vat v12_ ON a10_.vat_id = v12_.id
LEFT JOIN customer c13_ ON b9_.customer_id = c13_.id
WHERE
p0_.id = ?
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.value AS value_2, p0_.amount AS amount_3, p0_.type AS type_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.date_begin AS date_begin_7, p0_.date_end AS date_end_8, p0_.percentage AS percentage_9, p0_.description AS description_10, p0_.minimal_booking_days AS minimal_booking_days_11, p0_.date_purchase_start AS date_purchase_start_12, p0_.date_purchase_end AS date_purchase_end_13, a1_.id AS id_14, a1_.name AS name_15, a1_.type AS type_16, a1_.description AS description_17, a1_.picture AS picture_18, a1_.reference AS reference_19, a1_.phone AS phone_20, a1_.email AS email_21, a1_.is_visible AS is_visible_22, a1_.is_open AS is_open_23, a1_.updated_at AS updated_at_24, c2_.id AS id_25, c2_.name AS name_26, c2_.siren AS siren_27, c2_.siret AS siret_28, c2_.creation_date AS creation_date_29, c2_.tvaintra AS tvaintra_30, v3_.id AS id_31, v3_.country AS country_32, v3_.country_code AS country_code_33, v3_.standard_rate AS standard_rate_34, v3_.parking_rate AS parking_rate_35, v3_.reduced_rate1 AS reduced_rate1_36, v3_.reduced_rate2 AS reduced_rate2_37, v3_.super_reduced_rate AS super_reduced_rate_38, v3_.zero_rate AS zero_rate_39, p4_.id AS id_40, p4_.label AS label_41, p4_.type AS type_42, p4_.reference AS reference_43, p4_.updated_at AS updated_at_44, b5_.id AS id_45, b5_.price AS price_46, b5_.quantity AS quantity_47, b5_.vat_amount AS vat_amount_48, p6_.id AS id_49, p6_.type AS type_50, p6_.label AS label_51, p6_.updated_at AS updated_at_52, a7_.id AS id_53, a7_.label AS label_54, a7_.description AS description_55, a7_.price AS price_56, a7_.date_begin AS date_begin_57, a7_.date_end AS date_end_58, a7_.updated_at AS updated_at_59, a7_.is_activity_calculated_per_day AS is_activity_calculated_per_day_60, a7_.is_activity_calculated_per_booking AS is_activity_calculated_per_booking_61, i8_.id AS id_62, i8_.label AS label_63, i8_.description AS description_64, i8_.price AS price_65, i8_.updated_at AS updated_at_66, b9_.id AS id_67, b9_.reference AS reference_68, b9_.date_begin AS date_begin_69, b9_.date_end AS date_end_70, b9_.total_price AS total_price_71, b9_.total_days AS total_days_72, b9_.created_at AS created_at_73, b9_.status AS status_74, b9_.estimate_id AS estimate_id_75, b9_.updated_at AS updated_at_76, a10_.id AS id_77, a10_.name AS name_78, a10_.type AS type_79, a10_.description AS description_80, a10_.picture AS picture_81, a10_.reference AS reference_82, a10_.phone AS phone_83, a10_.email AS email_84, a10_.is_visible AS is_visible_85, a10_.is_open AS is_open_86, a10_.updated_at AS updated_at_87, c11_.id AS id_88, c11_.name AS name_89, c11_.siren AS siren_90, c11_.siret AS siret_91, c11_.creation_date AS creation_date_92, c11_.tvaintra AS tvaintra_93, v12_.id AS id_94, v12_.country AS country_95, v12_.country_code AS country_code_96, v12_.standard_rate AS standard_rate_97, v12_.parking_rate AS parking_rate_98, v12_.reduced_rate1 AS reduced_rate1_99, v12_.reduced_rate2 AS reduced_rate2_100, v12_.super_reduced_rate AS super_reduced_rate_101, v12_.zero_rate AS zero_rate_102, c13_.id AS id_103, c13_.first_name AS first_name_104, c13_.last_name AS last_name_105, c13_.is_activated AS is_activated_106, c13_.email AS email_107, c13_.phone AS phone_108, c13_.birth_date AS birth_date_109, c13_.language AS language_110, c13_.created_at AS created_at_111, c13_.updated_at AS updated_at_112, c13_.password AS password_113, c13_.rattache_company AS rattache_company_114, a1_.company_id AS company_id_115, a1_.vat_id AS vat_id_116, a1_.currency_id AS currency_id_117, b5_.product_id AS product_id_118, b5_.activity_id AS activity_id_119, b5_.insurance_id AS insurance_id_120, b5_.booking_id AS booking_id_121, b5_.estimate_id AS estimate_id_122, b5_.promotion_code_id AS promotion_code_id_123, p6_.model_id AS model_id_124, p6_.product_category_id AS product_category_id_125, p6_.vehicle_document_id AS vehicle_document_id_126, p6_.agency_id AS agency_id_127, b9_.user_id AS user_id_128, b9_.booking_agency_source_id AS booking_agency_source_id_129, b9_.booking_agency_target_id AS booking_agency_target_id_130, b9_.customer_id AS customer_id_131, a10_.company_id AS company_id_132, a10_.vat_id AS vat_id_133, a10_.currency_id AS currency_id_134 FROM promotion_code p0_ LEFT JOIN promotion_code_agency p14_ ON p0_.id = p14_.promotion_code_id LEFT JOIN agency a1_ ON a1_.id = p14_.agency_id LEFT JOIN company c2_ ON a1_.company_id = c2_.id LEFT JOIN vat v3_ ON a1_.vat_id = v3_.id LEFT JOIN promotion_code_product_category p15_ ON p0_.id = p15_.promotion_code_id LEFT JOIN product_category p4_ ON p4_.id = p15_.product_category_id LEFT JOIN booking_item b5_ ON p0_.id = b5_.promotion_code_id LEFT JOIN product p6_ ON b5_.product_id = p6_.id LEFT JOIN activity a7_ ON b5_.activity_id = a7_.id LEFT JOIN insurance i8_ ON b5_.insurance_id = i8_.id LEFT JOIN booking b9_ ON b5_.booking_id = b9_.id LEFT JOIN agency a10_ ON b9_.booking_agency_source_id = a10_.id LEFT JOIN company c11_ ON a10_.company_id = c11_.id LEFT JOIN vat v12_ ON a10_.vat_id = v12_.id LEFT JOIN customer c13_ ON b9_.customer_id = c13_.id WHERE p0_.id = 0;
|