Query Metrics
6
Database Queries
4
Different statements
3.15 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_domain AS site_domain_3, t0.is_ecommerce AS is_ecommerce_4, t0.nb_news_home_page AS nb_news_home_page_5, t0.logo_in_menu AS logo_in_menu_6, t0.right_menu_activated AS right_menu_activated_7, t0.breadcrumb_is_active AS breadcrumb_is_active_8, t0.site_copy_mail AS site_copy_mail_9, t0.site_header_mail AS site_header_mail_10, t0.site_sender_mail AS site_sender_mail_11, t0.site_sender_name_mail AS site_sender_name_mail_12, t0.project_directory AS project_directory_13, t0.odyssee_type AS odyssee_type_14, t0.odyssee_pdv_id AS odyssee_pdv_id_15, t0.clickup_script AS clickup_script_16 FROM site t0 WHERE t0.project_directory = ? LIMIT 1
Parameters:
[
"bain-rocher"
]
|
| 2 | 0.32 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_domain AS site_domain_3, t0.is_ecommerce AS is_ecommerce_4, t0.nb_news_home_page AS nb_news_home_page_5, t0.logo_in_menu AS logo_in_menu_6, t0.right_menu_activated AS right_menu_activated_7, t0.breadcrumb_is_active AS breadcrumb_is_active_8, t0.site_copy_mail AS site_copy_mail_9, t0.site_header_mail AS site_header_mail_10, t0.site_sender_mail AS site_sender_mail_11, t0.site_sender_name_mail AS site_sender_name_mail_12, t0.project_directory AS project_directory_13, t0.odyssee_type AS odyssee_type_14, t0.odyssee_pdv_id AS odyssee_pdv_id_15, t0.clickup_script AS clickup_script_16 FROM site t0 WHERE t0.project_directory = ? LIMIT 1
Parameters:
[
"bain-rocher"
]
|
| 3 | 0.30 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_domain AS site_domain_3, t0.is_ecommerce AS is_ecommerce_4, t0.nb_news_home_page AS nb_news_home_page_5, t0.logo_in_menu AS logo_in_menu_6, t0.right_menu_activated AS right_menu_activated_7, t0.breadcrumb_is_active AS breadcrumb_is_active_8, t0.site_copy_mail AS site_copy_mail_9, t0.site_header_mail AS site_header_mail_10, t0.site_sender_mail AS site_sender_mail_11, t0.site_sender_name_mail AS site_sender_name_mail_12, t0.project_directory AS project_directory_13, t0.odyssee_type AS odyssee_type_14, t0.odyssee_pdv_id AS odyssee_pdv_id_15, t0.clickup_script AS clickup_script_16 FROM site t0 WHERE t0.project_directory = ? LIMIT 1
Parameters:
[
"bain-rocher"
]
|
| 4 | 0.34 ms |
SELECT t0.id AS id_1, t0.cure_arrhes AS cure_arrhes_2, t0.ip_api_server AS ip_api_server_3, t0.port_api_server AS port_api_server_4, t0.cure_quota AS cure_quota_5, t0.nb_days_available_search AS nb_days_available_search_6, t0.current_year_start_date AS current_year_start_date_7, t0.current_year_end_date AS current_year_end_date_8, t0.next_year_start_date AS next_year_start_date_9, t0.next_year_end_date AS next_year_end_date_10, t0.site_id AS site_id_11 FROM api_settings t0 WHERE t0.site_id = ? LIMIT 1
Parameters:
[
2
]
|
| 5 | 0.49 ms |
SELECT t0.id AS id_1, t0.cure_arrhes AS cure_arrhes_2, t0.ip_api_server AS ip_api_server_3, t0.port_api_server AS port_api_server_4, t0.cure_quota AS cure_quota_5, t0.nb_days_available_search AS nb_days_available_search_6, t0.current_year_start_date AS current_year_start_date_7, t0.current_year_end_date AS current_year_end_date_8, t0.next_year_start_date AS next_year_start_date_9, t0.next_year_end_date AS next_year_end_date_10, t0.site_id AS site_id_11 FROM api_settings t0 LIMIT 1
Parameters:
[] |
| 6 | 1.04 ms |
SELECT * FROM site_lang JOIN language ON language.id = site_lang.site_lang WHERE site_lang.site_id = :site_id ORDER BY lang_entitled ASC
Parameters:
[ "site_id" => 1 ] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Acme\SudcmsBundle\Entity\Site | No errors. |
| Acme\SudcmsBundle\Entity\ApiSettings | No errors. |
| Acme\SudcmsBundle\Entity\SiteLang | No errors. |