Query Metrics
5
Database Queries
4
Different statements
11.68 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created AS created_4, t0.active AS active_5, t0.type AS type_6, t0.access AS access_7, t0.description AS description_8, t0.limit_max_member AS limit_max_member_9, t0.limit_max_engineer AS limit_max_engineer_10, t0.limit_max_admin AS limit_max_admin_11, t0.limit_min_member AS limit_min_member_12, t0.limit_min_engineer AS limit_min_engineer_13, t0.limit_min_admin AS limit_min_admin_14, t0.cgu AS cgu_15, t0.data_access AS data_access_16, t0.rocket_room AS rocket_room_17, t0.community AS community_18, t0.color AS color_19, t0.default_route AS default_route_20, t0.subtitle AS subtitle_21, t0.iframe_url AS iframe_url_22, t0.iframe_name AS iframe_name_23, t0.parent_service_list AS parent_service_list_24, t0.siret AS siret_25, t0.address AS address_26, t0.phone_number AS phone_number_27, t0.mattermost_id AS mattermost_id_28, t0.custom_fields AS custom_fields_29, t0.base_template AS base_template_30, t0.custom_script AS custom_script_31, t0.wiuz_api_url AS wiuz_api_url_32, t0.wiuz_api_key AS wiuz_api_key_33, t0.geofo_link_connection AS geofo_link_connection_34, t0.domain AS domain_35, t0.smtp_conf AS smtp_conf_36, t0.country AS country_37, t0.logo_id AS logo_id_38, t39.id AS id_40, t39.updated_date AS updated_date_41, t39.path AS path_42, t0.creator_id AS creator_id_43, t44.id AS id_45, t44.title AS title_46, t44.description AS description_47, t44.start_date AS start_date_48, t44.end_date AS end_date_49, t44.active AS active_50, t44.slug AS slug_51, t44.identifier AS identifier_52, t44.type_id AS type_id_53, t44.company_id AS company_id_54 FROM company t0 LEFT JOIN company_logo t39 ON t0.logo_id = t39.id LEFT JOIN tips t44 ON t44.company_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters:
[ "" ] |
| 2 | 1.53 ms |
SELECT t0.iso AS iso_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM country t0 WHERE t0.iso IN (?, ?, ?, ?)
Parameters:
[ "FR" "DE" "ES" "IT" ] |
| 3 | 0.45 ms |
SELECT t0.iso AS iso_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM country t0 WHERE t0.iso = ? LIMIT 1
Parameters:
[
"FR"
]
|
| 4 | 0.94 ms |
SELECT c0_.iso AS iso_0, c0_.name_fr AS name_fr_1, c0_.name_en AS name_en_2 FROM country c0_
Parameters:
[] |
| 5 | 1.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created AS created_4, t0.active AS active_5, t0.type AS type_6, t0.access AS access_7, t0.description AS description_8, t0.limit_max_member AS limit_max_member_9, t0.limit_max_engineer AS limit_max_engineer_10, t0.limit_max_admin AS limit_max_admin_11, t0.limit_min_member AS limit_min_member_12, t0.limit_min_engineer AS limit_min_engineer_13, t0.limit_min_admin AS limit_min_admin_14, t0.cgu AS cgu_15, t0.data_access AS data_access_16, t0.rocket_room AS rocket_room_17, t0.community AS community_18, t0.color AS color_19, t0.default_route AS default_route_20, t0.subtitle AS subtitle_21, t0.iframe_url AS iframe_url_22, t0.iframe_name AS iframe_name_23, t0.parent_service_list AS parent_service_list_24, t0.siret AS siret_25, t0.address AS address_26, t0.phone_number AS phone_number_27, t0.mattermost_id AS mattermost_id_28, t0.custom_fields AS custom_fields_29, t0.base_template AS base_template_30, t0.custom_script AS custom_script_31, t0.wiuz_api_url AS wiuz_api_url_32, t0.wiuz_api_key AS wiuz_api_key_33, t0.geofo_link_connection AS geofo_link_connection_34, t0.domain AS domain_35, t0.smtp_conf AS smtp_conf_36, t0.country AS country_37, t0.logo_id AS logo_id_38, t39.id AS id_40, t39.updated_date AS updated_date_41, t39.path AS path_42, t0.creator_id AS creator_id_43, t44.id AS id_45, t44.title AS title_46, t44.description AS description_47, t44.start_date AS start_date_48, t44.end_date AS end_date_49, t44.active AS active_50, t44.slug AS slug_51, t44.identifier AS identifier_52, t44.type_id AS type_id_53, t44.company_id AS company_id_54 FROM company t0 LEFT JOIN company_logo t39 ON t0.logo_id = t39.id LEFT JOIN tips t44 ON t44.company_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters:
[ "" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| georef | doctrine.dbal.georef_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| georef | doctrine.orm.georef_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Company\Company | No errors. |
| App\Entity\App\Country | No errors. |
| App\Entity\Company\Logo | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\Tips\Tips | No errors. |
| App\Entity\Tips\TipsType | No errors. |
| App\Entity\Payment\Plan | No errors. |
georef entity manager
No loaded entities.