13.51 ms
1
SELECT t0_ . id AS id_0 , t0_ . expired_at AS expired_at_1 , t0_ . created_at AS created_at_2 , t0_ . updated_at AS updated_at_3 , t0_ . user_id AS user_id_4 , t0_ . event_id AS event_id_5 FROM tk_cart t0_ WHERE t0_ . event_id = ? AND t0_ . expired_at > ? ORDER BY t0_ . created_at DESC
Parameters :
[
780
"2026-02-08 00:54:24 "
]
SELECT t0_ . id AS id_0 , t0_ . expired_at AS expired_at_1 , t0_ . created_at AS created_at_2 , t0_ . updated_at AS updated_at_3 , t0_ . user_id AS user_id_4 , t0_ . event_id AS event_id_5 FROM tk_cart t0_ WHERE t0_ . event_id = 780 AND t0_ . expired_at > '2026-02-08 00:54:24' ORDER BY t0_ . created_at DESC ; Copy
8.74 ms
1
SELECT t0_ . id AS id_0 , t0_ . price_ht AS price_ht_1 , t0_ . price_ttc AS price_ttc_2 , t0_ . state AS state_3 , t0_ . payment_method AS payment_method_4 , t0_ . user_firstname AS user_firstname_5 , t0_ . user_lastname AS user_lastname_6 , t0_ . user_address AS user_address_7 , t0_ . user_postcode AS user_postcode_8 , t0_ . user_city AS user_city_9 , t0_ . user_country AS user_country_10 , t0_ . user_email AS user_email_11 , t0_ . user_phone AS user_phone_12 , t0_ . paid_at AS paid_at_13 , t0_ . cancelled_at AS cancelled_at_14 , t0_ . alerted_at AS alerted_at_15 , t0_ . alert_message AS alert_message_16 , t0_ . payment_info AS payment_info_17 , t0_ . cancel_info AS cancel_info_18 , t0_ . on_counter AS on_counter_19 , t0_ . created_at AS created_at_20 , t0_ . updated_at AS updated_at_21 , t1_ . id AS id_22 , t1_ . name AS name_23 , t1_ . reference AS reference_24 , t1_ . slug AS slug_25 , t1_ . intro AS intro_26 , t1_ . description AS description_27 , t1_ . start_date AS start_date_28 , t1_ . end_date AS end_date_29 , t1_ . published_at AS published_at_30 , t1_ . closed_at AS closed_at_31 , t1_ . cancelled_at AS cancelled_at_32 , t1_ . status AS status_33 , t1_ . permanent AS permanent_34 , t1_ . partners AS partners_35 , t1_ . created_at AS created_at_36 , t1_ . updated_at AS updated_at_37 , t0_ . user_id AS user_id_38 , t0_ . project_id AS project_id_39 , t0_ . event_id AS event_id_40 , t0_ . outflow_id AS outflow_id_41 , t1_ . project_id AS project_id_42 , t1_ . promoter_id AS promoter_id_43 , t1_ . category_id AS category_id_44 , t1_ . thumbnail_id AS thumbnail_id_45 , t1_ . structure_id AS structure_id_46 FROM tk_orders t0_ INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id WHERE (t0_ . project_id = ? AND t0_ . event_id = ? ) AND (t0_ . state < > ? AND t0_ . state < > ? ) ORDER BY t0_ . created_at DESC
Parameters :
[
4719
780
3
-1
]
SELECT
t0_ . id AS id_0 ,
t0_ . price_ht AS price_ht_1 ,
t0_ . price_ttc AS price_ttc_2 ,
t0_ . state AS state_3 ,
t0_ . payment_method AS payment_method_4 ,
t0_ . user_firstname AS user_firstname_5 ,
t0_ . user_lastname AS user_lastname_6 ,
t0_ . user_address AS user_address_7 ,
t0_ . user_postcode AS user_postcode_8 ,
t0_ . user_city AS user_city_9 ,
t0_ . user_country AS user_country_10 ,
t0_ . user_email AS user_email_11 ,
t0_ . user_phone AS user_phone_12 ,
t0_ . paid_at AS paid_at_13 ,
t0_ . cancelled_at AS cancelled_at_14 ,
t0_ . alerted_at AS alerted_at_15 ,
t0_ . alert_message AS alert_message_16 ,
t0_ . payment_info AS payment_info_17 ,
t0_ . cancel_info AS cancel_info_18 ,
t0_ . on_counter AS on_counter_19 ,
t0_ . created_at AS created_at_20 ,
t0_ . updated_at AS updated_at_21 ,
t1_ . id AS id_22 ,
t1_ . name AS name_23 ,
t1_ . reference AS reference_24 ,
t1_ . slug AS slug_25 ,
t1_ . intro AS intro_26 ,
t1_ . description AS description_27 ,
t1_ . start_date AS start_date_28 ,
t1_ . end_date AS end_date_29 ,
t1_ . published_at AS published_at_30 ,
t1_ . closed_at AS closed_at_31 ,
t1_ . cancelled_at AS cancelled_at_32 ,
t1_ . status AS status_33 ,
t1_ . permanent AS permanent_34 ,
t1_ . partners AS partners_35 ,
t1_ . created_at AS created_at_36 ,
t1_ . updated_at AS updated_at_37 ,
t0_ . user_id AS user_id_38 ,
t0_ . project_id AS project_id_39 ,
t0_ . event_id AS event_id_40 ,
t0_ . outflow_id AS outflow_id_41 ,
t1_ . project_id AS project_id_42 ,
t1_ . promoter_id AS promoter_id_43 ,
t1_ . category_id AS category_id_44 ,
t1_ . thumbnail_id AS thumbnail_id_45 ,
t1_ . structure_id AS structure_id_46
FROM
tk_orders t0_
INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id
WHERE
(
t0_ . project_id = ?
AND t0_ . event_id = ?
)
AND (
t0_ . state < > ?
AND t0_ . state < > ?
)
ORDER BY
t0_ . created_at DESC Copy
SELECT t0_ . id AS id_0 , t0_ . price_ht AS price_ht_1 , t0_ . price_ttc AS price_ttc_2 , t0_ . state AS state_3 , t0_ . payment_method AS payment_method_4 , t0_ . user_firstname AS user_firstname_5 , t0_ . user_lastname AS user_lastname_6 , t0_ . user_address AS user_address_7 , t0_ . user_postcode AS user_postcode_8 , t0_ . user_city AS user_city_9 , t0_ . user_country AS user_country_10 , t0_ . user_email AS user_email_11 , t0_ . user_phone AS user_phone_12 , t0_ . paid_at AS paid_at_13 , t0_ . cancelled_at AS cancelled_at_14 , t0_ . alerted_at AS alerted_at_15 , t0_ . alert_message AS alert_message_16 , t0_ . payment_info AS payment_info_17 , t0_ . cancel_info AS cancel_info_18 , t0_ . on_counter AS on_counter_19 , t0_ . created_at AS created_at_20 , t0_ . updated_at AS updated_at_21 , t1_ . id AS id_22 , t1_ . name AS name_23 , t1_ . reference AS reference_24 , t1_ . slug AS slug_25 , t1_ . intro AS intro_26 , t1_ . description AS description_27 , t1_ . start_date AS start_date_28 , t1_ . end_date AS end_date_29 , t1_ . published_at AS published_at_30 , t1_ . closed_at AS closed_at_31 , t1_ . cancelled_at AS cancelled_at_32 , t1_ . status AS status_33 , t1_ . permanent AS permanent_34 , t1_ . partners AS partners_35 , t1_ . created_at AS created_at_36 , t1_ . updated_at AS updated_at_37 , t0_ . user_id AS user_id_38 , t0_ . project_id AS project_id_39 , t0_ . event_id AS event_id_40 , t0_ . outflow_id AS outflow_id_41 , t1_ . project_id AS project_id_42 , t1_ . promoter_id AS promoter_id_43 , t1_ . category_id AS category_id_44 , t1_ . thumbnail_id AS thumbnail_id_45 , t1_ . structure_id AS structure_id_46 FROM tk_orders t0_ INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id WHERE (t0_ . project_id = 4719 AND t0_ . event_id = 780 ) AND (t0_ . state < > 3 AND t0_ . state < > - 1 ) ORDER BY t0_ . created_at DESC ; Copy
1.05 ms
1
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . reference AS reference_2 , t0_ . slug AS slug_3 , t0_ . intro AS intro_4 , t0_ . description AS description_5 , t0_ . start_date AS start_date_6 , t0_ . end_date AS end_date_7 , t0_ . published_at AS published_at_8 , t0_ . closed_at AS closed_at_9 , t0_ . cancelled_at AS cancelled_at_10 , t0_ . status AS status_11 , t0_ . permanent AS permanent_12 , t0_ . partners AS partners_13 , t0_ . created_at AS created_at_14 , t0_ . updated_at AS updated_at_15 , t1_ . id AS id_16 , t1_ . name AS name_17 , t1_ . reference AS reference_18 , t1_ . description AS description_19 , t1_ . vat AS vat_20 , t1_ . date AS date_21 , t1_ . start_time AS start_time_22 , t1_ . end_time AS end_time_23 , t1_ . address AS address_24 , t1_ . type AS type_25 , t1_ . ticket_information AS ticket_information_26 , t1_ . ticket_instruction AS ticket_instruction_27 , t1_ . capacity AS capacity_28 , t1_ . status AS status_29 , t1_ . published_at AS published_at_30 , t1_ . closed_at AS closed_at_31 , t1_ . cancelled_at AS cancelled_at_32 , t1_ . recurrence_week_days AS recurrence_week_days_33 , t1_ . start_date AS start_date_34 , t1_ . end_date AS end_date_35 , t1_ . created_at AS created_at_36 , t1_ . updated_at AS updated_at_37 , t1_ . lat AS lat_38 , t1_ . lng AS lng_39 , t2_ . id AS id_40 , t2_ . name AS name_41 , t2_ . email AS email_42 , t2_ . phone AS phone_43 , t2_ . phone_two AS phone_two_44 , t2_ . phone_three AS phone_three_45 , t2_ . manager AS manager_46 , t2_ . license_number AS license_number_47 , t2_ . website AS website_48 , t2_ . facebook AS facebook_49 , t2_ . twitter AS twitter_50 , t2_ . instagram AS instagram_51 , t2_ . youtube AS youtube_52 , p3_ . id AS id_53 , p3_ . name AS name_54 , p3_ . description AS description_55 , p3_ . address AS address_56 , p3_ . additional_address AS additional_address_57 , p3_ . postcode AS postcode_58 , p3_ . identify_number AS identify_number_59 , p3_ . website AS website_60 , p3_ . prepaid_amount AS prepaid_amount_61 , p3_ . sponsor_code AS sponsor_code_62 , p3_ . sponsor_points AS sponsor_points_63 , p3_ . reference AS reference_64 , p3_ . sepa_name AS sepa_name_65 , p3_ . population AS population_66 , p3_ . typology AS typology_67 , p3_ . is_rdc AS is_rdc_68 , p3_ . is_contract_historic AS is_contract_historic_69 , p3_ . collectivity_service_code AS collectivity_service_code_70 , p3_ . is_number_ej AS is_number_ej_71 , p3_ . demo AS demo_72 , p3_ . vat AS vat_73 , p3_ . logo AS logo_74 , p3_ . is_data_different_invoice AS is_data_different_invoice_75 , p3_ . other_name AS other_name_76 , p3_ . other_address AS other_address_77 , p3_ . other_identify_number AS other_identify_number_78 , p3_ . manual_renewal AS manual_renewal_79 , p3_ . testimony_answered AS testimony_answered_80 , p3_ . is_cmd AS is_cmd_81 , p3_ . notes AS notes_82 , p3_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_83 , p3_ . date_ceo_interview AS date_ceo_interview_84 , p3_ . top_ranking AS top_ranking_85 , p3_ . rdc_feeling AS rdc_feeling_86 , p3_ . created_at AS created_at_87 , p3_ . updated_at AS updated_at_88 , p3_ . deleted_at AS deleted_at_89 , p3_ . lat AS lat_90 , p3_ . lng AS lng_91 , t0_ . project_id AS project_id_92 , t0_ . promoter_id AS promoter_id_93 , t0_ . category_id AS category_id_94 , t0_ . thumbnail_id AS thumbnail_id_95 , t0_ . structure_id AS structure_id_96 , t1_ . city_id AS city_id_97 , t1_ . plan_id AS plan_id_98 , t1_ . thumbnail_id AS thumbnail_id_99 , t1_ . event_id AS event_id_100 , t2_ . logo_id AS logo_id_101 , t2_ . project_id AS project_id_102 , p3_ . type_id AS type_id_103 , p3_ . category_id AS category_id_104 , p3_ . city_id AS city_id_105 , p3_ . user_id AS user_id_106 , p3_ . othet_city_id AS othet_city_id_107 , p3_ . intercommunality_id AS intercommunality_id_108 , p3_ . attachments AS attachments_109 FROM tk_events t0_ LEFT JOIN tk_seances t1_ ON t0_ . id = t1_ . event_id LEFT JOIN tk_promoters t2_ ON t0_ . promoter_id = t2_ . id INNER JOIN projects p3_ ON t0_ . project_id = p3_ . id WHERE t0_ . id = ? ORDER BY t1_ . date ASC , t1_ . start_time ASC , t1_ . end_time ASC
SELECT
t0_ . id AS id_0 ,
t0_ . name AS name_1 ,
t0_ . reference AS reference_2 ,
t0_ . slug AS slug_3 ,
t0_ . intro AS intro_4 ,
t0_ . description AS description_5 ,
t0_ . start_date AS start_date_6 ,
t0_ . end_date AS end_date_7 ,
t0_ . published_at AS published_at_8 ,
t0_ . closed_at AS closed_at_9 ,
t0_ . cancelled_at AS cancelled_at_10 ,
t0_ . status AS status_11 ,
t0_ . permanent AS permanent_12 ,
t0_ . partners AS partners_13 ,
t0_ . created_at AS created_at_14 ,
t0_ . updated_at AS updated_at_15 ,
t1_ . id AS id_16 ,
t1_ . name AS name_17 ,
t1_ . reference AS reference_18 ,
t1_ . description AS description_19 ,
t1_ . vat AS vat_20 ,
t1_ . date AS date_21 ,
t1_ . start_time AS start_time_22 ,
t1_ . end_time AS end_time_23 ,
t1_ . address AS address_24 ,
t1_ . type AS type_25 ,
t1_ . ticket_information AS ticket_information_26 ,
t1_ . ticket_instruction AS ticket_instruction_27 ,
t1_ . capacity AS capacity_28 ,
t1_ . status AS status_29 ,
t1_ . published_at AS published_at_30 ,
t1_ . closed_at AS closed_at_31 ,
t1_ . cancelled_at AS cancelled_at_32 ,
t1_ . recurrence_week_days AS recurrence_week_days_33 ,
t1_ . start_date AS start_date_34 ,
t1_ . end_date AS end_date_35 ,
t1_ . created_at AS created_at_36 ,
t1_ . updated_at AS updated_at_37 ,
t1_ . lat AS lat_38 ,
t1_ . lng AS lng_39 ,
t2_ . id AS id_40 ,
t2_ . name AS name_41 ,
t2_ . email AS email_42 ,
t2_ . phone AS phone_43 ,
t2_ . phone_two AS phone_two_44 ,
t2_ . phone_three AS phone_three_45 ,
t2_ . manager AS manager_46 ,
t2_ . license_number AS license_number_47 ,
t2_ . website AS website_48 ,
t2_ . facebook AS facebook_49 ,
t2_ . twitter AS twitter_50 ,
t2_ . instagram AS instagram_51 ,
t2_ . youtube AS youtube_52 ,
p3_ . id AS id_53 ,
p3_ . name AS name_54 ,
p3_ . description AS description_55 ,
p3_ . address AS address_56 ,
p3_ . additional_address AS additional_address_57 ,
p3_ . postcode AS postcode_58 ,
p3_ . identify_number AS identify_number_59 ,
p3_ . website AS website_60 ,
p3_ . prepaid_amount AS prepaid_amount_61 ,
p3_ . sponsor_code AS sponsor_code_62 ,
p3_ . sponsor_points AS sponsor_points_63 ,
p3_ . reference AS reference_64 ,
p3_ . sepa_name AS sepa_name_65 ,
p3_ . population AS population_66 ,
p3_ . typology AS typology_67 ,
p3_ . is_rdc AS is_rdc_68 ,
p3_ . is_contract_historic AS is_contract_historic_69 ,
p3_ . collectivity_service_code AS collectivity_service_code_70 ,
p3_ . is_number_ej AS is_number_ej_71 ,
p3_ . demo AS demo_72 ,
p3_ . vat AS vat_73 ,
p3_ . logo AS logo_74 ,
p3_ . is_data_different_invoice AS is_data_different_invoice_75 ,
p3_ . other_name AS other_name_76 ,
p3_ . other_address AS other_address_77 ,
p3_ . other_identify_number AS other_identify_number_78 ,
p3_ . manual_renewal AS manual_renewal_79 ,
p3_ . testimony_answered AS testimony_answered_80 ,
p3_ . is_cmd AS is_cmd_81 ,
p3_ . notes AS notes_82 ,
p3_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_83 ,
p3_ . date_ceo_interview AS date_ceo_interview_84 ,
p3_ . top_ranking AS top_ranking_85 ,
p3_ . rdc_feeling AS rdc_feeling_86 ,
p3_ . created_at AS created_at_87 ,
p3_ . updated_at AS updated_at_88 ,
p3_ . deleted_at AS deleted_at_89 ,
p3_ . lat AS lat_90 ,
p3_ . lng AS lng_91 ,
t0_ . project_id AS project_id_92 ,
t0_ . promoter_id AS promoter_id_93 ,
t0_ . category_id AS category_id_94 ,
t0_ . thumbnail_id AS thumbnail_id_95 ,
t0_ . structure_id AS structure_id_96 ,
t1_ . city_id AS city_id_97 ,
t1_ . plan_id AS plan_id_98 ,
t1_ . thumbnail_id AS thumbnail_id_99 ,
t1_ . event_id AS event_id_100 ,
t2_ . logo_id AS logo_id_101 ,
t2_ . project_id AS project_id_102 ,
p3_ . type_id AS type_id_103 ,
p3_ . category_id AS category_id_104 ,
p3_ . city_id AS city_id_105 ,
p3_ . user_id AS user_id_106 ,
p3_ . othet_city_id AS othet_city_id_107 ,
p3_ . intercommunality_id AS intercommunality_id_108 ,
p3_ . attachments AS attachments_109
FROM
tk_events t0_
LEFT JOIN tk_seances t1_ ON t0_ . id = t1_ . event_id
LEFT JOIN tk_promoters t2_ ON t0_ . promoter_id = t2_ . id
INNER JOIN projects p3_ ON t0_ . project_id = p3_ . id
WHERE
t0_ . id = ?
ORDER BY
t1_ . date ASC ,
t1_ . start_time ASC ,
t1_ . end_time ASC Copy
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . reference AS reference_2 , t0_ . slug AS slug_3 , t0_ . intro AS intro_4 , t0_ . description AS description_5 , t0_ . start_date AS start_date_6 , t0_ . end_date AS end_date_7 , t0_ . published_at AS published_at_8 , t0_ . closed_at AS closed_at_9 , t0_ . cancelled_at AS cancelled_at_10 , t0_ . status AS status_11 , t0_ . permanent AS permanent_12 , t0_ . partners AS partners_13 , t0_ . created_at AS created_at_14 , t0_ . updated_at AS updated_at_15 , t1_ . id AS id_16 , t1_ . name AS name_17 , t1_ . reference AS reference_18 , t1_ . description AS description_19 , t1_ . vat AS vat_20 , t1_ . date AS date_21 , t1_ . start_time AS start_time_22 , t1_ . end_time AS end_time_23 , t1_ . address AS address_24 , t1_ . type AS type_25 , t1_ . ticket_information AS ticket_information_26 , t1_ . ticket_instruction AS ticket_instruction_27 , t1_ . capacity AS capacity_28 , t1_ . status AS status_29 , t1_ . published_at AS published_at_30 , t1_ . closed_at AS closed_at_31 , t1_ . cancelled_at AS cancelled_at_32 , t1_ . recurrence_week_days AS recurrence_week_days_33 , t1_ . start_date AS start_date_34 , t1_ . end_date AS end_date_35 , t1_ . created_at AS created_at_36 , t1_ . updated_at AS updated_at_37 , t1_ . lat AS lat_38 , t1_ . lng AS lng_39 , t2_ . id AS id_40 , t2_ . name AS name_41 , t2_ . email AS email_42 , t2_ . phone AS phone_43 , t2_ . phone_two AS phone_two_44 , t2_ . phone_three AS phone_three_45 , t2_ . manager AS manager_46 , t2_ . license_number AS license_number_47 , t2_ . website AS website_48 , t2_ . facebook AS facebook_49 , t2_ . twitter AS twitter_50 , t2_ . instagram AS instagram_51 , t2_ . youtube AS youtube_52 , p3_ . id AS id_53 , p3_ . name AS name_54 , p3_ . description AS description_55 , p3_ . address AS address_56 , p3_ . additional_address AS additional_address_57 , p3_ . postcode AS postcode_58 , p3_ . identify_number AS identify_number_59 , p3_ . website AS website_60 , p3_ . prepaid_amount AS prepaid_amount_61 , p3_ . sponsor_code AS sponsor_code_62 , p3_ . sponsor_points AS sponsor_points_63 , p3_ . reference AS reference_64 , p3_ . sepa_name AS sepa_name_65 , p3_ . population AS population_66 , p3_ . typology AS typology_67 , p3_ . is_rdc AS is_rdc_68 , p3_ . is_contract_historic AS is_contract_historic_69 , p3_ . collectivity_service_code AS collectivity_service_code_70 , p3_ . is_number_ej AS is_number_ej_71 , p3_ . demo AS demo_72 , p3_ . vat AS vat_73 , p3_ . logo AS logo_74 , p3_ . is_data_different_invoice AS is_data_different_invoice_75 , p3_ . other_name AS other_name_76 , p3_ . other_address AS other_address_77 , p3_ . other_identify_number AS other_identify_number_78 , p3_ . manual_renewal AS manual_renewal_79 , p3_ . testimony_answered AS testimony_answered_80 , p3_ . is_cmd AS is_cmd_81 , p3_ . notes AS notes_82 , p3_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_83 , p3_ . date_ceo_interview AS date_ceo_interview_84 , p3_ . top_ranking AS top_ranking_85 , p3_ . rdc_feeling AS rdc_feeling_86 , p3_ . created_at AS created_at_87 , p3_ . updated_at AS updated_at_88 , p3_ . deleted_at AS deleted_at_89 , p3_ . lat AS lat_90 , p3_ . lng AS lng_91 , t0_ . project_id AS project_id_92 , t0_ . promoter_id AS promoter_id_93 , t0_ . category_id AS category_id_94 , t0_ . thumbnail_id AS thumbnail_id_95 , t0_ . structure_id AS structure_id_96 , t1_ . city_id AS city_id_97 , t1_ . plan_id AS plan_id_98 , t1_ . thumbnail_id AS thumbnail_id_99 , t1_ . event_id AS event_id_100 , t2_ . logo_id AS logo_id_101 , t2_ . project_id AS project_id_102 , p3_ . type_id AS type_id_103 , p3_ . category_id AS category_id_104 , p3_ . city_id AS city_id_105 , p3_ . user_id AS user_id_106 , p3_ . othet_city_id AS othet_city_id_107 , p3_ . intercommunality_id AS intercommunality_id_108 , p3_ . attachments AS attachments_109 FROM tk_events t0_ LEFT JOIN tk_seances t1_ ON t0_ . id = t1_ . event_id LEFT JOIN tk_promoters t2_ ON t0_ . promoter_id = t2_ . id INNER JOIN projects p3_ ON t0_ . project_id = p3_ . id WHERE t0_ . id = 780 ORDER BY t1_ . date ASC , t1_ . start_time ASC , t1_ . end_time ASC ; Copy
0.78 ms
1
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . description AS description_2 , t0_ . vat AS vat_3 , t0_ . status AS status_4 , t0_ . published_at AS published_at_5 , t0_ . start_date AS start_date_6 , t0_ . end_date AS end_date_7 , t0_ . closed_at AS closed_at_8 , t0_ . cancelled_at AS cancelled_at_9 , t0_ . capacity AS capacity_10 , t0_ . capacity_by_order AS capacity_by_order_11 , t0_ . created_at AS created_at_12 , t0_ . updated_at AS updated_at_13 , t1_ . id AS id_14 , t1_ . name AS name_15 , t1_ . reference AS reference_16 , t1_ . slug AS slug_17 , t1_ . intro AS intro_18 , t1_ . description AS description_19 , t1_ . start_date AS start_date_20 , t1_ . end_date AS end_date_21 , t1_ . published_at AS published_at_22 , t1_ . closed_at AS closed_at_23 , t1_ . cancelled_at AS cancelled_at_24 , t1_ . status AS status_25 , t1_ . permanent AS permanent_26 , t1_ . partners AS partners_27 , t1_ . created_at AS created_at_28 , t1_ . updated_at AS updated_at_29 , p2_ . id AS id_30 , p2_ . name AS name_31 , p2_ . description AS description_32 , p2_ . address AS address_33 , p2_ . additional_address AS additional_address_34 , p2_ . postcode AS postcode_35 , p2_ . identify_number AS identify_number_36 , p2_ . website AS website_37 , p2_ . prepaid_amount AS prepaid_amount_38 , p2_ . sponsor_code AS sponsor_code_39 , p2_ . sponsor_points AS sponsor_points_40 , p2_ . reference AS reference_41 , p2_ . sepa_name AS sepa_name_42 , p2_ . population AS population_43 , p2_ . typology AS typology_44 , p2_ . is_rdc AS is_rdc_45 , p2_ . is_contract_historic AS is_contract_historic_46 , p2_ . collectivity_service_code AS collectivity_service_code_47 , p2_ . is_number_ej AS is_number_ej_48 , p2_ . demo AS demo_49 , p2_ . vat AS vat_50 , p2_ . logo AS logo_51 , p2_ . is_data_different_invoice AS is_data_different_invoice_52 , p2_ . other_name AS other_name_53 , p2_ . other_address AS other_address_54 , p2_ . other_identify_number AS other_identify_number_55 , p2_ . manual_renewal AS manual_renewal_56 , p2_ . testimony_answered AS testimony_answered_57 , p2_ . is_cmd AS is_cmd_58 , p2_ . notes AS notes_59 , p2_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_60 , p2_ . date_ceo_interview AS date_ceo_interview_61 , p2_ . top_ranking AS top_ranking_62 , p2_ . rdc_feeling AS rdc_feeling_63 , p2_ . created_at AS created_at_64 , p2_ . updated_at AS updated_at_65 , p2_ . deleted_at AS deleted_at_66 , p2_ . lat AS lat_67 , p2_ . lng AS lng_68 , t3_ . id AS id_69 , t3_ . name AS name_70 , t3_ . reference AS reference_71 , t3_ . description AS description_72 , t3_ . vat AS vat_73 , t3_ . date AS date_74 , t3_ . start_time AS start_time_75 , t3_ . end_time AS end_time_76 , t3_ . address AS address_77 , t3_ . type AS type_78 , t3_ . ticket_information AS ticket_information_79 , t3_ . ticket_instruction AS ticket_instruction_80 , t3_ . capacity AS capacity_81 , t3_ . status AS status_82 , t3_ . published_at AS published_at_83 , t3_ . closed_at AS closed_at_84 , t3_ . cancelled_at AS cancelled_at_85 , t3_ . recurrence_week_days AS recurrence_week_days_86 , t3_ . start_date AS start_date_87 , t3_ . end_date AS end_date_88 , t3_ . created_at AS created_at_89 , t3_ . updated_at AS updated_at_90 , t3_ . lat AS lat_91 , t3_ . lng AS lng_92 , t4_ . id AS id_93 , t4_ . name AS name_94 , t4_ . price AS price_95 , t4_ . quantity AS quantity_96 , t4_ . nominative AS nominative_97 , t4_ . sale_type AS sale_type_98 , t4_ . on_counter AS on_counter_99 , t4_ . online AS online_100 , t0_ . event_id AS event_id_101 , t1_ . project_id AS project_id_102 , t1_ . promoter_id AS promoter_id_103 , t1_ . category_id AS category_id_104 , t1_ . thumbnail_id AS thumbnail_id_105 , t1_ . structure_id AS structure_id_106 , p2_ . type_id AS type_id_107 , p2_ . category_id AS category_id_108 , p2_ . city_id AS city_id_109 , p2_ . user_id AS user_id_110 , p2_ . othet_city_id AS othet_city_id_111 , p2_ . intercommunality_id AS intercommunality_id_112 , p2_ . attachments AS attachments_113 , t3_ . city_id AS city_id_114 , t3_ . plan_id AS plan_id_115 , t3_ . thumbnail_id AS thumbnail_id_116 , t3_ . event_id AS event_id_117 , t4_ . pack_id AS pack_id_118 , t4_ . project_id AS project_id_119 FROM tk_packs t0_ INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id INNER JOIN projects p2_ ON t1_ . project_id = p2_ . id INNER JOIN tk_packs_seances t5_ ON t0_ . id = t5_ . pack_id INNER JOIN tk_seances t3_ ON t3_ . id = t5_ . seance_id LEFT JOIN tk_packs_prices t4_ ON t0_ . id = t4_ . pack_id WHERE t0_ . event_id = ? AND t0_ . status = ? ORDER BY t0_ . name ASC
SELECT
t0_ . id AS id_0 ,
t0_ . name AS name_1 ,
t0_ . description AS description_2 ,
t0_ . vat AS vat_3 ,
t0_ . status AS status_4 ,
t0_ . published_at AS published_at_5 ,
t0_ . start_date AS start_date_6 ,
t0_ . end_date AS end_date_7 ,
t0_ . closed_at AS closed_at_8 ,
t0_ . cancelled_at AS cancelled_at_9 ,
t0_ . capacity AS capacity_10 ,
t0_ . capacity_by_order AS capacity_by_order_11 ,
t0_ . created_at AS created_at_12 ,
t0_ . updated_at AS updated_at_13 ,
t1_ . id AS id_14 ,
t1_ . name AS name_15 ,
t1_ . reference AS reference_16 ,
t1_ . slug AS slug_17 ,
t1_ . intro AS intro_18 ,
t1_ . description AS description_19 ,
t1_ . start_date AS start_date_20 ,
t1_ . end_date AS end_date_21 ,
t1_ . published_at AS published_at_22 ,
t1_ . closed_at AS closed_at_23 ,
t1_ . cancelled_at AS cancelled_at_24 ,
t1_ . status AS status_25 ,
t1_ . permanent AS permanent_26 ,
t1_ . partners AS partners_27 ,
t1_ . created_at AS created_at_28 ,
t1_ . updated_at AS updated_at_29 ,
p2_ . id AS id_30 ,
p2_ . name AS name_31 ,
p2_ . description AS description_32 ,
p2_ . address AS address_33 ,
p2_ . additional_address AS additional_address_34 ,
p2_ . postcode AS postcode_35 ,
p2_ . identify_number AS identify_number_36 ,
p2_ . website AS website_37 ,
p2_ . prepaid_amount AS prepaid_amount_38 ,
p2_ . sponsor_code AS sponsor_code_39 ,
p2_ . sponsor_points AS sponsor_points_40 ,
p2_ . reference AS reference_41 ,
p2_ . sepa_name AS sepa_name_42 ,
p2_ . population AS population_43 ,
p2_ . typology AS typology_44 ,
p2_ . is_rdc AS is_rdc_45 ,
p2_ . is_contract_historic AS is_contract_historic_46 ,
p2_ . collectivity_service_code AS collectivity_service_code_47 ,
p2_ . is_number_ej AS is_number_ej_48 ,
p2_ . demo AS demo_49 ,
p2_ . vat AS vat_50 ,
p2_ . logo AS logo_51 ,
p2_ . is_data_different_invoice AS is_data_different_invoice_52 ,
p2_ . other_name AS other_name_53 ,
p2_ . other_address AS other_address_54 ,
p2_ . other_identify_number AS other_identify_number_55 ,
p2_ . manual_renewal AS manual_renewal_56 ,
p2_ . testimony_answered AS testimony_answered_57 ,
p2_ . is_cmd AS is_cmd_58 ,
p2_ . notes AS notes_59 ,
p2_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_60 ,
p2_ . date_ceo_interview AS date_ceo_interview_61 ,
p2_ . top_ranking AS top_ranking_62 ,
p2_ . rdc_feeling AS rdc_feeling_63 ,
p2_ . created_at AS created_at_64 ,
p2_ . updated_at AS updated_at_65 ,
p2_ . deleted_at AS deleted_at_66 ,
p2_ . lat AS lat_67 ,
p2_ . lng AS lng_68 ,
t3_ . id AS id_69 ,
t3_ . name AS name_70 ,
t3_ . reference AS reference_71 ,
t3_ . description AS description_72 ,
t3_ . vat AS vat_73 ,
t3_ . date AS date_74 ,
t3_ . start_time AS start_time_75 ,
t3_ . end_time AS end_time_76 ,
t3_ . address AS address_77 ,
t3_ . type AS type_78 ,
t3_ . ticket_information AS ticket_information_79 ,
t3_ . ticket_instruction AS ticket_instruction_80 ,
t3_ . capacity AS capacity_81 ,
t3_ . status AS status_82 ,
t3_ . published_at AS published_at_83 ,
t3_ . closed_at AS closed_at_84 ,
t3_ . cancelled_at AS cancelled_at_85 ,
t3_ . recurrence_week_days AS recurrence_week_days_86 ,
t3_ . start_date AS start_date_87 ,
t3_ . end_date AS end_date_88 ,
t3_ . created_at AS created_at_89 ,
t3_ . updated_at AS updated_at_90 ,
t3_ . lat AS lat_91 ,
t3_ . lng AS lng_92 ,
t4_ . id AS id_93 ,
t4_ . name AS name_94 ,
t4_ . price AS price_95 ,
t4_ . quantity AS quantity_96 ,
t4_ . nominative AS nominative_97 ,
t4_ . sale_type AS sale_type_98 ,
t4_ . on_counter AS on_counter_99 ,
t4_ . online AS online_100 ,
t0_ . event_id AS event_id_101 ,
t1_ . project_id AS project_id_102 ,
t1_ . promoter_id AS promoter_id_103 ,
t1_ . category_id AS category_id_104 ,
t1_ . thumbnail_id AS thumbnail_id_105 ,
t1_ . structure_id AS structure_id_106 ,
p2_ . type_id AS type_id_107 ,
p2_ . category_id AS category_id_108 ,
p2_ . city_id AS city_id_109 ,
p2_ . user_id AS user_id_110 ,
p2_ . othet_city_id AS othet_city_id_111 ,
p2_ . intercommunality_id AS intercommunality_id_112 ,
p2_ . attachments AS attachments_113 ,
t3_ . city_id AS city_id_114 ,
t3_ . plan_id AS plan_id_115 ,
t3_ . thumbnail_id AS thumbnail_id_116 ,
t3_ . event_id AS event_id_117 ,
t4_ . pack_id AS pack_id_118 ,
t4_ . project_id AS project_id_119
FROM
tk_packs t0_
INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id
INNER JOIN projects p2_ ON t1_ . project_id = p2_ . id
INNER JOIN tk_packs_seances t5_ ON t0_ . id = t5_ . pack_id
INNER JOIN tk_seances t3_ ON t3_ . id = t5_ . seance_id
LEFT JOIN tk_packs_prices t4_ ON t0_ . id = t4_ . pack_id
WHERE
t0_ . event_id = ?
AND t0_ . status = ?
ORDER BY
t0_ . name ASC Copy
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . description AS description_2 , t0_ . vat AS vat_3 , t0_ . status AS status_4 , t0_ . published_at AS published_at_5 , t0_ . start_date AS start_date_6 , t0_ . end_date AS end_date_7 , t0_ . closed_at AS closed_at_8 , t0_ . cancelled_at AS cancelled_at_9 , t0_ . capacity AS capacity_10 , t0_ . capacity_by_order AS capacity_by_order_11 , t0_ . created_at AS created_at_12 , t0_ . updated_at AS updated_at_13 , t1_ . id AS id_14 , t1_ . name AS name_15 , t1_ . reference AS reference_16 , t1_ . slug AS slug_17 , t1_ . intro AS intro_18 , t1_ . description AS description_19 , t1_ . start_date AS start_date_20 , t1_ . end_date AS end_date_21 , t1_ . published_at AS published_at_22 , t1_ . closed_at AS closed_at_23 , t1_ . cancelled_at AS cancelled_at_24 , t1_ . status AS status_25 , t1_ . permanent AS permanent_26 , t1_ . partners AS partners_27 , t1_ . created_at AS created_at_28 , t1_ . updated_at AS updated_at_29 , p2_ . id AS id_30 , p2_ . name AS name_31 , p2_ . description AS description_32 , p2_ . address AS address_33 , p2_ . additional_address AS additional_address_34 , p2_ . postcode AS postcode_35 , p2_ . identify_number AS identify_number_36 , p2_ . website AS website_37 , p2_ . prepaid_amount AS prepaid_amount_38 , p2_ . sponsor_code AS sponsor_code_39 , p2_ . sponsor_points AS sponsor_points_40 , p2_ . reference AS reference_41 , p2_ . sepa_name AS sepa_name_42 , p2_ . population AS population_43 , p2_ . typology AS typology_44 , p2_ . is_rdc AS is_rdc_45 , p2_ . is_contract_historic AS is_contract_historic_46 , p2_ . collectivity_service_code AS collectivity_service_code_47 , p2_ . is_number_ej AS is_number_ej_48 , p2_ . demo AS demo_49 , p2_ . vat AS vat_50 , p2_ . logo AS logo_51 , p2_ . is_data_different_invoice AS is_data_different_invoice_52 , p2_ . other_name AS other_name_53 , p2_ . other_address AS other_address_54 , p2_ . other_identify_number AS other_identify_number_55 , p2_ . manual_renewal AS manual_renewal_56 , p2_ . testimony_answered AS testimony_answered_57 , p2_ . is_cmd AS is_cmd_58 , p2_ . notes AS notes_59 , p2_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_60 , p2_ . date_ceo_interview AS date_ceo_interview_61 , p2_ . top_ranking AS top_ranking_62 , p2_ . rdc_feeling AS rdc_feeling_63 , p2_ . created_at AS created_at_64 , p2_ . updated_at AS updated_at_65 , p2_ . deleted_at AS deleted_at_66 , p2_ . lat AS lat_67 , p2_ . lng AS lng_68 , t3_ . id AS id_69 , t3_ . name AS name_70 , t3_ . reference AS reference_71 , t3_ . description AS description_72 , t3_ . vat AS vat_73 , t3_ . date AS date_74 , t3_ . start_time AS start_time_75 , t3_ . end_time AS end_time_76 , t3_ . address AS address_77 , t3_ . type AS type_78 , t3_ . ticket_information AS ticket_information_79 , t3_ . ticket_instruction AS ticket_instruction_80 , t3_ . capacity AS capacity_81 , t3_ . status AS status_82 , t3_ . published_at AS published_at_83 , t3_ . closed_at AS closed_at_84 , t3_ . cancelled_at AS cancelled_at_85 , t3_ . recurrence_week_days AS recurrence_week_days_86 , t3_ . start_date AS start_date_87 , t3_ . end_date AS end_date_88 , t3_ . created_at AS created_at_89 , t3_ . updated_at AS updated_at_90 , t3_ . lat AS lat_91 , t3_ . lng AS lng_92 , t4_ . id AS id_93 , t4_ . name AS name_94 , t4_ . price AS price_95 , t4_ . quantity AS quantity_96 , t4_ . nominative AS nominative_97 , t4_ . sale_type AS sale_type_98 , t4_ . on_counter AS on_counter_99 , t4_ . online AS online_100 , t0_ . event_id AS event_id_101 , t1_ . project_id AS project_id_102 , t1_ . promoter_id AS promoter_id_103 , t1_ . category_id AS category_id_104 , t1_ . thumbnail_id AS thumbnail_id_105 , t1_ . structure_id AS structure_id_106 , p2_ . type_id AS type_id_107 , p2_ . category_id AS category_id_108 , p2_ . city_id AS city_id_109 , p2_ . user_id AS user_id_110 , p2_ . othet_city_id AS othet_city_id_111 , p2_ . intercommunality_id AS intercommunality_id_112 , p2_ . attachments AS attachments_113 , t3_ . city_id AS city_id_114 , t3_ . plan_id AS plan_id_115 , t3_ . thumbnail_id AS thumbnail_id_116 , t3_ . event_id AS event_id_117 , t4_ . pack_id AS pack_id_118 , t4_ . project_id AS project_id_119 FROM tk_packs t0_ INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id INNER JOIN projects p2_ ON t1_ . project_id = p2_ . id INNER JOIN tk_packs_seances t5_ ON t0_ . id = t5_ . pack_id INNER JOIN tk_seances t3_ ON t3_ . id = t5_ . seance_id LEFT JOIN tk_packs_prices t4_ ON t0_ . id = t4_ . pack_id WHERE t0_ . event_id = 780 AND t0_ . status = 1 ORDER BY t0_ . name ASC ; Copy
0.78 ms
1
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . description AS description_2 , t0_ . slug AS slug_3 , t0_ . phone AS phone_4 , t0_ . phone_two AS phone_two_5 , t0_ . phone_three AS phone_three_6 , t0_ . representative_name AS representative_name_7 , t0_ . identify_number AS identify_number_8 , t0_ . bank_iban AS bank_iban_9 , t0_ . bank_bic AS bank_bic_10 , t0_ . bank_holder AS bank_holder_11 , t0_ . available_vat AS available_vat_12 , t0_ . address AS address_13 , t0_ . contact_email AS contact_email_14 , t0_ . website AS website_15 , t0_ . facebook AS facebook_16 , t0_ . twitter AS twitter_17 , t0_ . instagram AS instagram_18 , t0_ . youtube AS youtube_19 , t0_ . status AS status_20 , t0_ . sales_terms AS sales_terms_21 , t0_ . is_public AS is_public_22 , t0_ . opened_at AS opened_at_23 , t0_ . closing_text AS closing_text_24 , t0_ . google_analytics AS google_analytics_25 , p1_ . id AS id_26 , p1_ . name AS name_27 , p1_ . description AS description_28 , p1_ . address AS address_29 , p1_ . additional_address AS additional_address_30 , p1_ . postcode AS postcode_31 , p1_ . identify_number AS identify_number_32 , p1_ . website AS website_33 , p1_ . prepaid_amount AS prepaid_amount_34 , p1_ . sponsor_code AS sponsor_code_35 , p1_ . sponsor_points AS sponsor_points_36 , p1_ . reference AS reference_37 , p1_ . sepa_name AS sepa_name_38 , p1_ . population AS population_39 , p1_ . typology AS typology_40 , p1_ . is_rdc AS is_rdc_41 , p1_ . is_contract_historic AS is_contract_historic_42 , p1_ . collectivity_service_code AS collectivity_service_code_43 , p1_ . is_number_ej AS is_number_ej_44 , p1_ . demo AS demo_45 , p1_ . vat AS vat_46 , p1_ . logo AS logo_47 , p1_ . is_data_different_invoice AS is_data_different_invoice_48 , p1_ . other_name AS other_name_49 , p1_ . other_address AS other_address_50 , p1_ . other_identify_number AS other_identify_number_51 , p1_ . manual_renewal AS manual_renewal_52 , p1_ . testimony_answered AS testimony_answered_53 , p1_ . is_cmd AS is_cmd_54 , p1_ . notes AS notes_55 , p1_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_56 , p1_ . date_ceo_interview AS date_ceo_interview_57 , p1_ . top_ranking AS top_ranking_58 , p1_ . rdc_feeling AS rdc_feeling_59 , p1_ . created_at AS created_at_60 , p1_ . updated_at AS updated_at_61 , p1_ . deleted_at AS deleted_at_62 , p1_ . lat AS lat_63 , p1_ . lng AS lng_64 , t0_ . logo_id AS logo_id_65 , t0_ . city_id AS city_id_66 , t0_ . project_id AS project_id_67 , p1_ . type_id AS type_id_68 , p1_ . category_id AS category_id_69 , p1_ . city_id AS city_id_70 , p1_ . user_id AS user_id_71 , p1_ . othet_city_id AS othet_city_id_72 , p1_ . intercommunality_id AS intercommunality_id_73 , p1_ . attachments AS attachments_74 FROM tk_structures t0_ INNER JOIN projects p1_ ON t0_ . project_id = p1_ . id WHERE t0_ . project_id = ? ORDER BY t0_ . name ASC
SELECT
t0_ . id AS id_0 ,
t0_ . name AS name_1 ,
t0_ . description AS description_2 ,
t0_ . slug AS slug_3 ,
t0_ . phone AS phone_4 ,
t0_ . phone_two AS phone_two_5 ,
t0_ . phone_three AS phone_three_6 ,
t0_ . representative_name AS representative_name_7 ,
t0_ . identify_number AS identify_number_8 ,
t0_ . bank_iban AS bank_iban_9 ,
t0_ . bank_bic AS bank_bic_10 ,
t0_ . bank_holder AS bank_holder_11 ,
t0_ . available_vat AS available_vat_12 ,
t0_ . address AS address_13 ,
t0_ . contact_email AS contact_email_14 ,
t0_ . website AS website_15 ,
t0_ . facebook AS facebook_16 ,
t0_ . twitter AS twitter_17 ,
t0_ . instagram AS instagram_18 ,
t0_ . youtube AS youtube_19 ,
t0_ . status AS status_20 ,
t0_ . sales_terms AS sales_terms_21 ,
t0_ . is_public AS is_public_22 ,
t0_ . opened_at AS opened_at_23 ,
t0_ . closing_text AS closing_text_24 ,
t0_ . google_analytics AS google_analytics_25 ,
p1_ . id AS id_26 ,
p1_ . name AS name_27 ,
p1_ . description AS description_28 ,
p1_ . address AS address_29 ,
p1_ . additional_address AS additional_address_30 ,
p1_ . postcode AS postcode_31 ,
p1_ . identify_number AS identify_number_32 ,
p1_ . website AS website_33 ,
p1_ . prepaid_amount AS prepaid_amount_34 ,
p1_ . sponsor_code AS sponsor_code_35 ,
p1_ . sponsor_points AS sponsor_points_36 ,
p1_ . reference AS reference_37 ,
p1_ . sepa_name AS sepa_name_38 ,
p1_ . population AS population_39 ,
p1_ . typology AS typology_40 ,
p1_ . is_rdc AS is_rdc_41 ,
p1_ . is_contract_historic AS is_contract_historic_42 ,
p1_ . collectivity_service_code AS collectivity_service_code_43 ,
p1_ . is_number_ej AS is_number_ej_44 ,
p1_ . demo AS demo_45 ,
p1_ . vat AS vat_46 ,
p1_ . logo AS logo_47 ,
p1_ . is_data_different_invoice AS is_data_different_invoice_48 ,
p1_ . other_name AS other_name_49 ,
p1_ . other_address AS other_address_50 ,
p1_ . other_identify_number AS other_identify_number_51 ,
p1_ . manual_renewal AS manual_renewal_52 ,
p1_ . testimony_answered AS testimony_answered_53 ,
p1_ . is_cmd AS is_cmd_54 ,
p1_ . notes AS notes_55 ,
p1_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_56 ,
p1_ . date_ceo_interview AS date_ceo_interview_57 ,
p1_ . top_ranking AS top_ranking_58 ,
p1_ . rdc_feeling AS rdc_feeling_59 ,
p1_ . created_at AS created_at_60 ,
p1_ . updated_at AS updated_at_61 ,
p1_ . deleted_at AS deleted_at_62 ,
p1_ . lat AS lat_63 ,
p1_ . lng AS lng_64 ,
t0_ . logo_id AS logo_id_65 ,
t0_ . city_id AS city_id_66 ,
t0_ . project_id AS project_id_67 ,
p1_ . type_id AS type_id_68 ,
p1_ . category_id AS category_id_69 ,
p1_ . city_id AS city_id_70 ,
p1_ . user_id AS user_id_71 ,
p1_ . othet_city_id AS othet_city_id_72 ,
p1_ . intercommunality_id AS intercommunality_id_73 ,
p1_ . attachments AS attachments_74
FROM
tk_structures t0_
INNER JOIN projects p1_ ON t0_ . project_id = p1_ . id
WHERE
t0_ . project_id = ?
ORDER BY
t0_ . name ASC Copy
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . description AS description_2 , t0_ . slug AS slug_3 , t0_ . phone AS phone_4 , t0_ . phone_two AS phone_two_5 , t0_ . phone_three AS phone_three_6 , t0_ . representative_name AS representative_name_7 , t0_ . identify_number AS identify_number_8 , t0_ . bank_iban AS bank_iban_9 , t0_ . bank_bic AS bank_bic_10 , t0_ . bank_holder AS bank_holder_11 , t0_ . available_vat AS available_vat_12 , t0_ . address AS address_13 , t0_ . contact_email AS contact_email_14 , t0_ . website AS website_15 , t0_ . facebook AS facebook_16 , t0_ . twitter AS twitter_17 , t0_ . instagram AS instagram_18 , t0_ . youtube AS youtube_19 , t0_ . status AS status_20 , t0_ . sales_terms AS sales_terms_21 , t0_ . is_public AS is_public_22 , t0_ . opened_at AS opened_at_23 , t0_ . closing_text AS closing_text_24 , t0_ . google_analytics AS google_analytics_25 , p1_ . id AS id_26 , p1_ . name AS name_27 , p1_ . description AS description_28 , p1_ . address AS address_29 , p1_ . additional_address AS additional_address_30 , p1_ . postcode AS postcode_31 , p1_ . identify_number AS identify_number_32 , p1_ . website AS website_33 , p1_ . prepaid_amount AS prepaid_amount_34 , p1_ . sponsor_code AS sponsor_code_35 , p1_ . sponsor_points AS sponsor_points_36 , p1_ . reference AS reference_37 , p1_ . sepa_name AS sepa_name_38 , p1_ . population AS population_39 , p1_ . typology AS typology_40 , p1_ . is_rdc AS is_rdc_41 , p1_ . is_contract_historic AS is_contract_historic_42 , p1_ . collectivity_service_code AS collectivity_service_code_43 , p1_ . is_number_ej AS is_number_ej_44 , p1_ . demo AS demo_45 , p1_ . vat AS vat_46 , p1_ . logo AS logo_47 , p1_ . is_data_different_invoice AS is_data_different_invoice_48 , p1_ . other_name AS other_name_49 , p1_ . other_address AS other_address_50 , p1_ . other_identify_number AS other_identify_number_51 , p1_ . manual_renewal AS manual_renewal_52 , p1_ . testimony_answered AS testimony_answered_53 , p1_ . is_cmd AS is_cmd_54 , p1_ . notes AS notes_55 , p1_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_56 , p1_ . date_ceo_interview AS date_ceo_interview_57 , p1_ . top_ranking AS top_ranking_58 , p1_ . rdc_feeling AS rdc_feeling_59 , p1_ . created_at AS created_at_60 , p1_ . updated_at AS updated_at_61 , p1_ . deleted_at AS deleted_at_62 , p1_ . lat AS lat_63 , p1_ . lng AS lng_64 , t0_ . logo_id AS logo_id_65 , t0_ . city_id AS city_id_66 , t0_ . project_id AS project_id_67 , p1_ . type_id AS type_id_68 , p1_ . category_id AS category_id_69 , p1_ . city_id AS city_id_70 , p1_ . user_id AS user_id_71 , p1_ . othet_city_id AS othet_city_id_72 , p1_ . intercommunality_id AS intercommunality_id_73 , p1_ . attachments AS attachments_74 FROM tk_structures t0_ INNER JOIN projects p1_ ON t0_ . project_id = p1_ . id WHERE t0_ . project_id = 4719 ORDER BY t0_ . name ASC ; Copy
0.75 ms
1
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . reference AS reference_2 , t0_ . description AS description_3 , t0_ . vat AS vat_4 , t0_ . date AS date_5 , t0_ . start_time AS start_time_6 , t0_ . end_time AS end_time_7 , t0_ . address AS address_8 , t0_ . type AS type_9 , t0_ . ticket_information AS ticket_information_10 , t0_ . ticket_instruction AS ticket_instruction_11 , t0_ . capacity AS capacity_12 , t0_ . status AS status_13 , t0_ . published_at AS published_at_14 , t0_ . closed_at AS closed_at_15 , t0_ . cancelled_at AS cancelled_at_16 , t0_ . recurrence_week_days AS recurrence_week_days_17 , t0_ . start_date AS start_date_18 , t0_ . end_date AS end_date_19 , t0_ . created_at AS created_at_20 , t0_ . updated_at AS updated_at_21 , t0_ . lat AS lat_22 , t0_ . lng AS lng_23 , t1_ . id AS id_24 , t1_ . name AS name_25 , t1_ . reference AS reference_26 , t1_ . slug AS slug_27 , t1_ . intro AS intro_28 , t1_ . description AS description_29 , t1_ . start_date AS start_date_30 , t1_ . end_date AS end_date_31 , t1_ . published_at AS published_at_32 , t1_ . closed_at AS closed_at_33 , t1_ . cancelled_at AS cancelled_at_34 , t1_ . status AS status_35 , t1_ . permanent AS permanent_36 , t1_ . partners AS partners_37 , t1_ . created_at AS created_at_38 , t1_ . updated_at AS updated_at_39 , p2_ . id AS id_40 , p2_ . name AS name_41 , p2_ . description AS description_42 , p2_ . address AS address_43 , p2_ . additional_address AS additional_address_44 , p2_ . postcode AS postcode_45 , p2_ . identify_number AS identify_number_46 , p2_ . website AS website_47 , p2_ . prepaid_amount AS prepaid_amount_48 , p2_ . sponsor_code AS sponsor_code_49 , p2_ . sponsor_points AS sponsor_points_50 , p2_ . reference AS reference_51 , p2_ . sepa_name AS sepa_name_52 , p2_ . population AS population_53 , p2_ . typology AS typology_54 , p2_ . is_rdc AS is_rdc_55 , p2_ . is_contract_historic AS is_contract_historic_56 , p2_ . collectivity_service_code AS collectivity_service_code_57 , p2_ . is_number_ej AS is_number_ej_58 , p2_ . demo AS demo_59 , p2_ . vat AS vat_60 , p2_ . logo AS logo_61 , p2_ . is_data_different_invoice AS is_data_different_invoice_62 , p2_ . other_name AS other_name_63 , p2_ . other_address AS other_address_64 , p2_ . other_identify_number AS other_identify_number_65 , p2_ . manual_renewal AS manual_renewal_66 , p2_ . testimony_answered AS testimony_answered_67 , p2_ . is_cmd AS is_cmd_68 , p2_ . notes AS notes_69 , p2_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_70 , p2_ . date_ceo_interview AS date_ceo_interview_71 , p2_ . top_ranking AS top_ranking_72 , p2_ . rdc_feeling AS rdc_feeling_73 , p2_ . created_at AS created_at_74 , p2_ . updated_at AS updated_at_75 , p2_ . deleted_at AS deleted_at_76 , p2_ . lat AS lat_77 , p2_ . lng AS lng_78 , t3_ . id AS id_79 , t3_ . name AS name_80 , t3_ . price AS price_81 , t3_ . quantity AS quantity_82 , t3_ . nominative AS nominative_83 , t3_ . sale_type AS sale_type_84 , t3_ . on_counter AS on_counter_85 , t3_ . online AS online_86 , t0_ . city_id AS city_id_87 , t0_ . plan_id AS plan_id_88 , t0_ . thumbnail_id AS thumbnail_id_89 , t0_ . event_id AS event_id_90 , t1_ . project_id AS project_id_91 , t1_ . promoter_id AS promoter_id_92 , t1_ . category_id AS category_id_93 , t1_ . thumbnail_id AS thumbnail_id_94 , t1_ . structure_id AS structure_id_95 , p2_ . type_id AS type_id_96 , p2_ . category_id AS category_id_97 , p2_ . city_id AS city_id_98 , p2_ . user_id AS user_id_99 , p2_ . othet_city_id AS othet_city_id_100 , p2_ . intercommunality_id AS intercommunality_id_101 , p2_ . attachments AS attachments_102 , t3_ . seance_id AS seance_id_103 , t3_ . zone_id AS zone_id_104 , t3_ . project_id AS project_id_105 FROM tk_seances t0_ INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id INNER JOIN projects p2_ ON t1_ . project_id = p2_ . id LEFT JOIN tk_seances_prices t3_ ON t0_ . id = t3_ . seance_id WHERE t0_ . event_id = ? AND t0_ . status = ? ORDER BY t0_ . date ASC , t0_ . start_time ASC , t0_ . end_time ASC
SELECT
t0_ . id AS id_0 ,
t0_ . name AS name_1 ,
t0_ . reference AS reference_2 ,
t0_ . description AS description_3 ,
t0_ . vat AS vat_4 ,
t0_ . date AS date_5 ,
t0_ . start_time AS start_time_6 ,
t0_ . end_time AS end_time_7 ,
t0_ . address AS address_8 ,
t0_ . type AS type_9 ,
t0_ . ticket_information AS ticket_information_10 ,
t0_ . ticket_instruction AS ticket_instruction_11 ,
t0_ . capacity AS capacity_12 ,
t0_ . status AS status_13 ,
t0_ . published_at AS published_at_14 ,
t0_ . closed_at AS closed_at_15 ,
t0_ . cancelled_at AS cancelled_at_16 ,
t0_ . recurrence_week_days AS recurrence_week_days_17 ,
t0_ . start_date AS start_date_18 ,
t0_ . end_date AS end_date_19 ,
t0_ . created_at AS created_at_20 ,
t0_ . updated_at AS updated_at_21 ,
t0_ . lat AS lat_22 ,
t0_ . lng AS lng_23 ,
t1_ . id AS id_24 ,
t1_ . name AS name_25 ,
t1_ . reference AS reference_26 ,
t1_ . slug AS slug_27 ,
t1_ . intro AS intro_28 ,
t1_ . description AS description_29 ,
t1_ . start_date AS start_date_30 ,
t1_ . end_date AS end_date_31 ,
t1_ . published_at AS published_at_32 ,
t1_ . closed_at AS closed_at_33 ,
t1_ . cancelled_at AS cancelled_at_34 ,
t1_ . status AS status_35 ,
t1_ . permanent AS permanent_36 ,
t1_ . partners AS partners_37 ,
t1_ . created_at AS created_at_38 ,
t1_ . updated_at AS updated_at_39 ,
p2_ . id AS id_40 ,
p2_ . name AS name_41 ,
p2_ . description AS description_42 ,
p2_ . address AS address_43 ,
p2_ . additional_address AS additional_address_44 ,
p2_ . postcode AS postcode_45 ,
p2_ . identify_number AS identify_number_46 ,
p2_ . website AS website_47 ,
p2_ . prepaid_amount AS prepaid_amount_48 ,
p2_ . sponsor_code AS sponsor_code_49 ,
p2_ . sponsor_points AS sponsor_points_50 ,
p2_ . reference AS reference_51 ,
p2_ . sepa_name AS sepa_name_52 ,
p2_ . population AS population_53 ,
p2_ . typology AS typology_54 ,
p2_ . is_rdc AS is_rdc_55 ,
p2_ . is_contract_historic AS is_contract_historic_56 ,
p2_ . collectivity_service_code AS collectivity_service_code_57 ,
p2_ . is_number_ej AS is_number_ej_58 ,
p2_ . demo AS demo_59 ,
p2_ . vat AS vat_60 ,
p2_ . logo AS logo_61 ,
p2_ . is_data_different_invoice AS is_data_different_invoice_62 ,
p2_ . other_name AS other_name_63 ,
p2_ . other_address AS other_address_64 ,
p2_ . other_identify_number AS other_identify_number_65 ,
p2_ . manual_renewal AS manual_renewal_66 ,
p2_ . testimony_answered AS testimony_answered_67 ,
p2_ . is_cmd AS is_cmd_68 ,
p2_ . notes AS notes_69 ,
p2_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_70 ,
p2_ . date_ceo_interview AS date_ceo_interview_71 ,
p2_ . top_ranking AS top_ranking_72 ,
p2_ . rdc_feeling AS rdc_feeling_73 ,
p2_ . created_at AS created_at_74 ,
p2_ . updated_at AS updated_at_75 ,
p2_ . deleted_at AS deleted_at_76 ,
p2_ . lat AS lat_77 ,
p2_ . lng AS lng_78 ,
t3_ . id AS id_79 ,
t3_ . name AS name_80 ,
t3_ . price AS price_81 ,
t3_ . quantity AS quantity_82 ,
t3_ . nominative AS nominative_83 ,
t3_ . sale_type AS sale_type_84 ,
t3_ . on_counter AS on_counter_85 ,
t3_ . online AS online_86 ,
t0_ . city_id AS city_id_87 ,
t0_ . plan_id AS plan_id_88 ,
t0_ . thumbnail_id AS thumbnail_id_89 ,
t0_ . event_id AS event_id_90 ,
t1_ . project_id AS project_id_91 ,
t1_ . promoter_id AS promoter_id_92 ,
t1_ . category_id AS category_id_93 ,
t1_ . thumbnail_id AS thumbnail_id_94 ,
t1_ . structure_id AS structure_id_95 ,
p2_ . type_id AS type_id_96 ,
p2_ . category_id AS category_id_97 ,
p2_ . city_id AS city_id_98 ,
p2_ . user_id AS user_id_99 ,
p2_ . othet_city_id AS othet_city_id_100 ,
p2_ . intercommunality_id AS intercommunality_id_101 ,
p2_ . attachments AS attachments_102 ,
t3_ . seance_id AS seance_id_103 ,
t3_ . zone_id AS zone_id_104 ,
t3_ . project_id AS project_id_105
FROM
tk_seances t0_
INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id
INNER JOIN projects p2_ ON t1_ . project_id = p2_ . id
LEFT JOIN tk_seances_prices t3_ ON t0_ . id = t3_ . seance_id
WHERE
t0_ . event_id = ?
AND t0_ . status = ?
ORDER BY
t0_ . date ASC ,
t0_ . start_time ASC ,
t0_ . end_time ASC Copy
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 , t0_ . reference AS reference_2 , t0_ . description AS description_3 , t0_ . vat AS vat_4 , t0_ . date AS date_5 , t0_ . start_time AS start_time_6 , t0_ . end_time AS end_time_7 , t0_ . address AS address_8 , t0_ . type AS type_9 , t0_ . ticket_information AS ticket_information_10 , t0_ . ticket_instruction AS ticket_instruction_11 , t0_ . capacity AS capacity_12 , t0_ . status AS status_13 , t0_ . published_at AS published_at_14 , t0_ . closed_at AS closed_at_15 , t0_ . cancelled_at AS cancelled_at_16 , t0_ . recurrence_week_days AS recurrence_week_days_17 , t0_ . start_date AS start_date_18 , t0_ . end_date AS end_date_19 , t0_ . created_at AS created_at_20 , t0_ . updated_at AS updated_at_21 , t0_ . lat AS lat_22 , t0_ . lng AS lng_23 , t1_ . id AS id_24 , t1_ . name AS name_25 , t1_ . reference AS reference_26 , t1_ . slug AS slug_27 , t1_ . intro AS intro_28 , t1_ . description AS description_29 , t1_ . start_date AS start_date_30 , t1_ . end_date AS end_date_31 , t1_ . published_at AS published_at_32 , t1_ . closed_at AS closed_at_33 , t1_ . cancelled_at AS cancelled_at_34 , t1_ . status AS status_35 , t1_ . permanent AS permanent_36 , t1_ . partners AS partners_37 , t1_ . created_at AS created_at_38 , t1_ . updated_at AS updated_at_39 , p2_ . id AS id_40 , p2_ . name AS name_41 , p2_ . description AS description_42 , p2_ . address AS address_43 , p2_ . additional_address AS additional_address_44 , p2_ . postcode AS postcode_45 , p2_ . identify_number AS identify_number_46 , p2_ . website AS website_47 , p2_ . prepaid_amount AS prepaid_amount_48 , p2_ . sponsor_code AS sponsor_code_49 , p2_ . sponsor_points AS sponsor_points_50 , p2_ . reference AS reference_51 , p2_ . sepa_name AS sepa_name_52 , p2_ . population AS population_53 , p2_ . typology AS typology_54 , p2_ . is_rdc AS is_rdc_55 , p2_ . is_contract_historic AS is_contract_historic_56 , p2_ . collectivity_service_code AS collectivity_service_code_57 , p2_ . is_number_ej AS is_number_ej_58 , p2_ . demo AS demo_59 , p2_ . vat AS vat_60 , p2_ . logo AS logo_61 , p2_ . is_data_different_invoice AS is_data_different_invoice_62 , p2_ . other_name AS other_name_63 , p2_ . other_address AS other_address_64 , p2_ . other_identify_number AS other_identify_number_65 , p2_ . manual_renewal AS manual_renewal_66 , p2_ . testimony_answered AS testimony_answered_67 , p2_ . is_cmd AS is_cmd_68 , p2_ . notes AS notes_69 , p2_ . date_invitation_ceo_interview AS date_invitation_ceo_interview_70 , p2_ . date_ceo_interview AS date_ceo_interview_71 , p2_ . top_ranking AS top_ranking_72 , p2_ . rdc_feeling AS rdc_feeling_73 , p2_ . created_at AS created_at_74 , p2_ . updated_at AS updated_at_75 , p2_ . deleted_at AS deleted_at_76 , p2_ . lat AS lat_77 , p2_ . lng AS lng_78 , t3_ . id AS id_79 , t3_ . name AS name_80 , t3_ . price AS price_81 , t3_ . quantity AS quantity_82 , t3_ . nominative AS nominative_83 , t3_ . sale_type AS sale_type_84 , t3_ . on_counter AS on_counter_85 , t3_ . online AS online_86 , t0_ . city_id AS city_id_87 , t0_ . plan_id AS plan_id_88 , t0_ . thumbnail_id AS thumbnail_id_89 , t0_ . event_id AS event_id_90 , t1_ . project_id AS project_id_91 , t1_ . promoter_id AS promoter_id_92 , t1_ . category_id AS category_id_93 , t1_ . thumbnail_id AS thumbnail_id_94 , t1_ . structure_id AS structure_id_95 , p2_ . type_id AS type_id_96 , p2_ . category_id AS category_id_97 , p2_ . city_id AS city_id_98 , p2_ . user_id AS user_id_99 , p2_ . othet_city_id AS othet_city_id_100 , p2_ . intercommunality_id AS intercommunality_id_101 , p2_ . attachments AS attachments_102 , t3_ . seance_id AS seance_id_103 , t3_ . zone_id AS zone_id_104 , t3_ . project_id AS project_id_105 FROM tk_seances t0_ INNER JOIN tk_events t1_ ON t0_ . event_id = t1_ . id INNER JOIN projects p2_ ON t1_ . project_id = p2_ . id LEFT JOIN tk_seances_prices t3_ ON t0_ . id = t3_ . seance_id WHERE t0_ . event_id = 780 AND t0_ . status = 1 ORDER BY t0_ . date ASC , t0_ . start_time ASC , t0_ . end_time ASC ; Copy
0.57 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . status AS status_4 FROM tk_events_categories t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . status AS status_4 FROM tk_events_categories t0 WHERE t0 . id = 6 ; Copy