Symfony Profiler

Query Metrics

18 Database Queries

10 Different statements

6.80 ms Query time

0 Invalid entities

1 Managed entities

Queries


SELECT t0.id AS id_1, t0.sku AS sku_2, t0.icecat_id AS icecat_id_3, t0.icecat_product_id AS icecat_product_id_4, t0.icecat_datasheet_url AS icecat_datasheet_url_5, t0.icecat_last_updated AS icecat_last_updated_6, t0.icecat_status AS icecat_status_7, t0.icecat_search_terms AS icecat_search_terms_8 FROM icecat_data t0 WHERE t0.id = ?
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT @@character_set_database, @@collation_database
SELECT DATABASE()
SELECT c.TABLE_NAME,
       c.COLUMN_NAME,
           IF(
        c.DATA_TYPE = 'longtext'
        AND EXISTS(
            SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'content'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.DATA_TYPE
    ),
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE,
       c.COLUMN_DEFAULT,
       c.EXTRA,
       c.COLUMN_COMMENT,
       c.CHARACTER_SET_NAME,
       c.COLLATION_NAME
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_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION
SELECT DATABASE()
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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT tc.TABLE_NAME,
       tc.CONSTRAINT_NAME,
       kcu.COLUMN_NAME
FROM information_schema.TABLE_CONSTRAINTS tc
         INNER JOIN information_schema.KEY_COLUMN_USAGE kcu
                    ON kcu.TABLE_NAME = tc.TABLE_NAME
                        AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ?
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY TABLE_NAME,
    kcu.ORDINAL_POSITION
SELECT DATABASE()
SELECT TABLE_NAME,
       INDEX_NAME,
       INDEX_TYPE,
       NON_UNIQUE,
       COLUMN_NAME,
       SUB_PART
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?
  AND INDEX_NAME != 'PRIMARY'
ORDER BY TABLE_NAME,
    SEQ_IN_INDEX
SELECT DATABASE()
SELECT k.TABLE_NAME,
       k.CONSTRAINT_NAME,
       k.REFERENCED_TABLE_NAME,
       c.UPDATE_RULE,
       c.DELETE_RULE,
       k.COLUMN_NAME,
       k.REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE k
         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 c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()

#▲	Time	Info
1	0.36 ms	SELECT t0.id AS id_1, t0.sku AS sku_2, t0.icecat_id AS icecat_id_3, t0.icecat_product_id AS icecat_product_id_4, t0.icecat_datasheet_url AS icecat_datasheet_url_5, t0.icecat_last_updated AS icecat_last_updated_6, t0.icecat_status AS icecat_status_7, t0.icecat_search_terms AS icecat_search_terms_8 FROM icecat_data t0 WHERE t0.id = ? Parameters: [`"32808"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sku AS sku_2, t0.icecat_id AS icecat_id_3, t0.icecat_product_id AS icecat_product_id_4, t0.icecat_datasheet_url AS icecat_datasheet_url_5, t0.icecat_last_updated AS icecat_last_updated_6, t0.icecat_status AS icecat_status_7, t0.icecat_search_terms AS icecat_search_terms_8 FROM icecat_data t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.sku AS sku_2, t0.icecat_id AS icecat_id_3, t0.icecat_product_id AS icecat_product_id_4, t0.icecat_datasheet_url AS icecat_datasheet_url_5, t0.icecat_last_updated AS icecat_last_updated_6, t0.icecat_status AS icecat_status_7, t0.icecat_search_terms AS icecat_search_terms_8 FROM icecat_data t0 WHERE t0.id = '32808';
2	0.35 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3	0.86 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"content"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'content' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
4	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
5	0.47 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"content"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'content' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
6	0.18 ms	SELECT @@character_set_database, @@collation_database Parameters: [] View formatted query View runnable query Explain query SELECT @@character_set_database, @@collation_database SELECT @@character_set_database, @@collation_database;
7	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
8	1.48 ms	SELECT c.TABLE_NAME, c.COLUMN_NAME, IF( c.DATA_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'content' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.DATA_TYPE ), c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME 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_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION Parameters: [`"content" "content" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.TABLE_NAME, c.COLUMN_NAME, IF( c.DATA_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'content' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.DATA_TYPE ), c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME 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_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION SELECT c.TABLE_NAME, c.COLUMN_NAME, IF( c.DATA_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'content' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.DATA_TYPE ), c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'content' AND t.TABLE_SCHEMA = 'content' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION;
9	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
10	0.67 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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"content" "doctrine_migration_versions"`] View formatted query View runnable query Explain query 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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' 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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'content' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
11	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
12	0.53 ms	SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ? AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION Parameters: [`"content" "content" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ? AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = 'content' AND kcu.TABLE_SCHEMA = 'content' AND tc.TABLE_NAME = 'doctrine_migration_versions' AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION;
13	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
14	0.23 ms	SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX Parameters: [`"content" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'content' AND TABLE_NAME = 'doctrine_migration_versions' AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX;
15	0.12 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
16	0.44 ms	SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k 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 c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION Parameters: [`"content" "content" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k 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 c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k 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 = 'content' AND c.CONSTRAINT_SCHEMA = 'content' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION;
17	0.20 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
18	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

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\IcecatData	1

Entities Mapping

Class	Mapping errors
App\Entity\IcecatData	No errors.

Symfony Profiler

GET https://content.gamingdesktop.com.au/admin/icecat-data/32808/edit?page=33

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping