Query Metrics
29
Database Queries
14
Different statements
30.63 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
17.14 ms (55.97%) |
1 |
SELECT c.COLUMN_NAME AS field, IF( x.CHECK_CLAUSE IS NOT NULL AND c.COLUMN_TYPE = 'longtext', 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME LEFT JOIN information_schema.CHECK_CONSTRAINTS x ON ( c.TABLE_SCHEMA = x.CONSTRAINT_SCHEMA AND c.TABLE_NAME = x.TABLE_NAME AND x.CHECK_CLAUSE = CONCAT('json_valid(`', c.COLUMN_NAME , '`)') ) WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "tressol-chabrier" "tressol-chabrier" "doctrine_migration_versions" ] |
2.35 ms (7.68%) |
8 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"totalConcession"
]
|
2.08 ms (6.80%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"tressol-chabrier"
]
|
2.07 ms (6.75%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.opening_hours_periods AS opening_hours_periods_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.ville AS ville_5, e0_.telephone AS telephone_6, e0_.email AS email_7, e0_.concession_email AS concession_email_8, e0_.concession_telephone AS concession_telephone_9, e0_.latitude AS latitude_10, e0_.longtitude AS longtitude_11, e0_.detail_stockage AS detail_stockage_12, c1_.name AS name_13 FROM etablissement e0_ LEFT JOIN etablissement_car_marque e2_ ON e0_.id = e2_.etablissement_id LEFT JOIN car_marque c1_ ON c1_.id = e2_.car_marque_id WHERE ((e0_.latitude IS NOT NULL AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1) OR e0_.id = ?) AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC
Parameters:
[
158
]
|
1.47 ms (4.79%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
"tressol_offre_detail"
]
|
1.27 ms (4.15%) |
6 |
SELECT DATABASE()
Parameters:
[] |
1.25 ms (4.07%) |
1 |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'tressol-chabrier' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "tressol-chabrier" "doctrine_migration_versions" ] |
0.59 ms (1.92%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.legales_text AS legales_text_5, t0.url AS url_6 FROM promo t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
0.54 ms (1.76%) |
1 |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "tressol-chabrier" "doctrine_migration_versions" ] |
0.54 ms (1.76%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type AS type_3, t0.ville AS ville_4, t0.postcode AS postcode_5, t0.experience AS experience_6, t0.content AS content_7, t0.position AS position_8, t0.profile AS profile_9, t0.image AS image_10, t0.ats AS ats_11, t0.ats_id AS ats_id_12, t0.email AS email_13, t0.url AS url_14, t0.state AS state_15, t0.work_time AS work_time_16, t0.education AS education_17, t0.driving_licence AS driving_licence_18, t0.employment_date AS employment_date_19, t0.salary_type AS salary_type_20, t0.salary AS salary_21, t0.benefits AS benefits_22, t0.rome AS rome_23, t0.region AS region_24, t0.latitude AS latitude_25, t0.longtitude AS longtitude_26, t0.date AS date_27, t0.category_id AS category_id_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30 FROM offre t0 WHERE t0.id = ?
Parameters:
[
"111"
]
|
0.49 ms (1.59%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_for_meeting AS name_for_meeting_3, t0.description AS description_4, t0.image_id AS image_id_5 FROM expert t0
Parameters:
[] |
0.37 ms (1.21%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.identifier AS identifier_4, t0.content AS content_5, t0.hektor_text_logged AS hektor_text_logged_6, t0.hektor_text_not_logged AS hektor_text_not_logged_7, t0.hektor_text_is_differnet AS hektor_text_is_differnet_8, t0.cms_page_id AS cms_page_id_9 FROM cms_bloc t0 WHERE t0.cms_page_id = ?
Parameters:
[
35
]
|
0.30 ms (0.98%) |
1 |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "tressol-chabrier" "doctrine_migration_versions" ] |
0.18 ms (0.58%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
internal | doctrine.dbal.internal_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
internal | doctrine.orm.internal_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Offre | No errors. |
App\Entity\Job | No errors. |
App\Entity\CmsPage | No errors. |
App\Entity\CmsBloc | No errors. |
App\Entity\DataCount | No errors. |
App\Entity\Promo | No errors. |
App\Entity\PromoSlider | No errors. |
App\Entity\Etablissement | No errors. |
App\Entity\CarMarque | No errors. |
App\Entity\Expert | No errors. |
App\Entity\Upload | No errors. |
App\Entity\ExpertContact | No errors. |
internal entity manager
No loaded entities.