https://up-paris.com/ Return to referer URL

Query Metrics

12 Database Queries
8 Different statements
23.43 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.78 ms
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.img_url AS img_url_2, m0_.ordre AS ordre_3, m0_.img_url_file AS img_url_file_4, m0_.slug AS slug_5 FROM mobilier_categories m0_ ORDER BY m0_.ordre ASC
Parameters:
[]
2 4.60 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
3 2.26 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
4 0.49 ms
SELECT DATABASE()
Parameters:
[]
5 2.11 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'upparikmabasesql' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
6 0.50 ms
SELECT DATABASE()
Parameters:
[]
7 2.83 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 = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'upparikmabasesql' /*!50116 AND c.constraint_schema = 'upparikmabasesql' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL ORDER BY k.`ORDINAL_POSITION`
Parameters:
[]
8 0.44 ms
SELECT DATABASE()
Parameters:
[]
9 3.92 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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'upparikmabasesql' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
10 2.19 ms
SELECT 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 TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
11 1.89 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
12 0.42 ms
SELECT DATABASE()
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\MobilierImages No errors.
App\Entity\ProTexte No errors.
App\Entity\ProImages No errors.
App\Entity\AccContact No errors.
App\Entity\AccEspPro No errors.
App\Entity\Accmobilier No errors.
App\Entity\Apropos No errors.
App\Entity\Couv No errors.
App\Entity\MobilierTechniques No errors.
App\Entity\Contact No errors.
App\Entity\Mobilier No errors.
App\Entity\Stats No errors.
App\Entity\Upartistik No errors.
App\Entity\MobilierCategories No errors.