Query Metrics
11
Database Queries
11
Different statements
44.85 ms
Query time
18
Invalid entities
16
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.85 ms |
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
Parameters:
[
780
]
|
| 2 | 11.57 ms |
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
Parameters:
[
4719
]
|
| 3 | 4.38 ms |
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
Parameters:
[ 780 1 ] |
| 4 | 11.51 ms |
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
Parameters:
[ 780 1 ] |
| 5 | 6.23 ms |
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 ] |
| 6 | 6.66 ms |
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 "2025-12-13 19:28:49" ] |
| 7 | 0.49 ms |
SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.slug AS slug_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.country_id AS country_id_6 FROM cities t0 WHERE t0.id = ?
Parameters:
[
16643
]
|
| 8 | 0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
Parameters:
[
16643
]
|
| 9 | 0.46 ms |
SELECT t0.id AS id_1, t0.iso_code AS iso_code_2, t0.call_prefix AS call_prefix_3, t0.need_zip_code AS need_zip_code_4, t0.zip_code_format AS zip_code_format_5, t0.display_tax_label AS display_tax_label_6, t0.vat AS vat_7, t0.enabled AS enabled_8, t0.zone_id AS zone_id_9, t0.currency_id AS currency_id_10 FROM countries t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 10 | 0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.vat_information AS vat_information_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.id AS id_7, t6.iso_code AS iso_code_8, t6.call_prefix AS call_prefix_9, t6.need_zip_code AS need_zip_code_10, t6.zip_code_format AS zip_code_format_11, t6.display_tax_label AS display_tax_label_12, t6.vat AS vat_13, t6.enabled AS enabled_14, t6.zone_id AS zone_id_15, t6.currency_id AS currency_id_16 FROM countries_translation t0 LEFT JOIN countries t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
8
]
|
| 11 | 0.53 ms |
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 = ?
Parameters:
[
6
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Location\City | 2 |
| App\Entity\Ticketing\Event | 1 |
| App\Entity\Ticketing\EventCategory | 1 |
| App\Entity\Ticketing\Structure | 1 |
| App\Entity\Ticketing\Seance | 1 |
| App\Entity\Ticketing\Promoter | 1 |
| App\Entity\Project\Project | 1 |
| App\Entity\Project\ProjectType | 1 |
| App\Entity\Project\Category | 1 |
| App\Entity\Ticketing\SeancePrice | 1 |
| App\Entity\Location\Country | 1 |
| App\Entity\Location\CityTranslation | 1 |
| App\Entity\Location\Zone | 1 |
| App\Entity\Currency | 1 |
| App\Entity\Location\CountryTranslation | 1 |