Query Metrics
15
Database Queries
9
Different statements
348.57 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 330.65 ms |
SELECT t0.id AS id_1, t0.kod AS kod_2, t0.nazwa AS nazwa_3, t0.dodatkowa_nazwa AS dodatkowa_nazwa_4, t0.cena_katalog_netto AS cena_katalog_netto_5, t0.cena_katalog_eur AS cena_katalog_eur_6, t0.ean AS ean_7, t0.kraj_pochodzenia AS kraj_pochodzenia_8, t0.slug AS slug_9, t0.main AS main_10, t0.moc_led_chip AS moc_led_chip_11, t0.moc_oprawy AS moc_oprawy_12, t0.lumen_led_chip AS lumen_led_chip_13, t0.lmw_zoprawy AS lmw_zoprawy_14, t0.klasa_efektywnosci AS klasa_efektywnosci_15, t0.l90b10 AS l90b10_16, t0.lumen_oprawa AS lumen_oprawa_17, t0.image_url AS image_url_18, t0.description AS description_19, t0.visibility AS visibility_20, t0.led AS led_21, t0.options AS options_22, t0.cover AS cover_23, t0.mcadam AS mcadam_24, t0.operating_voltage AS operating_voltage_25, t0.plik_fotometryczny AS plik_fotometryczny_26, t0.tech_image AS tech_image_27, t0.options_en AS options_en_28, t0.opis_pl AS opis_pl_29, t0.opis_en AS opis_en_30, t0.sterowanie_id AS sterowanie_id_31, t0.model_oprawy_id AS model_oprawy_id_32, t0.destiny_id AS destiny_id_33, t0.dioda_id AS dioda_id_34, t0.kolor_id AS kolor_id_35, t0.holder_id AS holder_id_36, t0.odblysnik_id AS odblysnik_id_37, t0.led_driver_id AS led_driver_id_38, t0.przeslona_id AS przeslona_id_39, t0.image_id AS image_id_40 FROM produkt t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"/N212-K0003-LC850-H7-P15-ZC01-500-S9"
]
|
2 | 0.52 ms |
SELECT DATABASE()
Parameters:
[] |
3 | 2.06 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"cra_coradev_sulu"
]
|
4 | 0.43 ms |
SELECT DATABASE()
Parameters:
[] |
5 | 1.40 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"cra_coradev_sulu"
]
|
6 | 0.35 ms |
SELECT DATABASE()
Parameters:
[] |
7 | 1.02 ms |
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:
[ "cra_coradev_sulu" "doctrine_migration_versions" ] |
8 | 0.74 ms |
SELECT DATABASE()
Parameters:
[] |
9 | 3.00 ms |
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 = 'cra_coradev_sulu' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "cra_coradev_sulu" "doctrine_migration_versions" ] |
10 | 3.58 ms |
SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'cra_coradev_sulu' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), '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 WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "cra_coradev_sulu" "cra_coradev_sulu" "doctrine_migration_versions" ] |
11 | 0.55 ms |
SELECT DATABASE()
Parameters:
[] |
12 | 0.89 ms |
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:
[ "cra_coradev_sulu" "doctrine_migration_versions" ] |
13 | 0.54 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
14 | 0.35 ms |
SELECT DATABASE()
Parameters:
[] |
15 | 2.50 ms |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC, w1_.id ASC
Parameters:
[ "www.cora.pl" "dev" "cora-www" ] |
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.