Symfony Profiler

Query Metrics

13 Database Queries

7 Different statements

14.83 ms Query time

0 Invalid entities

Queries

default connection


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 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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
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 = 'db' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       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
SELECT DATABASE()
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
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()

#▲	Time	Info
1	0.61 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	3.08 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"db"`] 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 = 'db' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
3	0.25 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
4	1.51 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"db"`] 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 = 'db' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
5	0.27 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
6	2.07 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: [`"db" "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.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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'db' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
7	0.21 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
8	3.22 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 = 'db' / ORDER BY k.ORDINAL_POSITION Parameters: [`"db" "doctrine_migration_versions"`] View formatted query View runnable query Explain query 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 = 'db' / ORDER BY k.ORDINAL_POSITION 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 = 'db' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'db' / ORDER BY k.ORDINAL_POSITION;
9	1.80 ms	SELECT c.COLUMN_NAME AS field, 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: [`"db" "db" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, 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 SELECT c.COLUMN_NAME AS field, 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 = 'db' AND t.TABLE_SCHEMA = 'db' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
10	0.29 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
11	0.97 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: [`"db" "doctrine_migration_versions"`] View formatted query View runnable query Explain query 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 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 = 'db' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
12	0.34 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;
13	0.22 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
farming	doctrine.dbal.farming_connection
market_mm	doctrine.dbal.market_mm_connection
market_statistic	doctrine.dbal.market_statistic_connection
market_user	doctrine.dbal.market_user_connection
market_paymaster	doctrine.dbal.market_paymaster_connection
market_dom	doctrine.dbal.market_dom_connection
market_content	doctrine.dbal.market_content_connection
market_archive	doctrine.dbal.market_archive_connection
market_chat	doctrine.dbal.market_chat_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
farming	doctrine.orm.farming_entity_manager
market_mm	doctrine.orm.market_mm_entity_manager
market_statistic	doctrine.orm.market_statistic_entity_manager
market_user	doctrine.orm.market_user_entity_manager
market_paymaster	doctrine.orm.market_paymaster_entity_manager
market_dom	doctrine.orm.market_dom_entity_manager
market_content	doctrine.orm.market_content_entity_manager
market_archive	doctrine.orm.market_archive_entity_manager
market_chat	doctrine.orm.market_chat_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

No loaded entities.

farming entity manager

No loaded entities.

market_mm entity manager

No loaded entities.

market_statistic entity manager

No loaded entities.

market_user entity manager

No loaded entities.

market_paymaster entity manager

No loaded entities.

market_dom entity manager

No loaded entities.

market_content entity manager

No loaded entities.

market_archive entity manager

No loaded entities.

market_chat entity manager

No loaded entities.

Symfony Profiler

GET http://admin.thedexcoin.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

farming entity manager

market_mm entity manager

market_statistic entity manager

market_user entity manager

market_paymaster entity manager

market_dom entity manager

market_content entity manager

market_archive entity manager

market_chat entity manager