https://menusdeldia.com/shop/wp-login.php

Query Metrics

14 Database Queries
8 Different statements
4.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.89 ms
(21.25%)
6
SELECT DATABASE()
Parameters:
[]
0.79 ms
(18.70%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.locality AS locality_6, t0.postalCode AS postalCode_7, t0.telefono AS telefono_8, t0.tel_whatsapp AS tel_whatsapp_9, t0.email AS email_10, t0.placeDetails AS placeDetails_11, t0.googlePlaceId AS googlePlaceId_12, t0.rating AS rating_13, t0.created AS created_14, t0.updated AS updated_15, t0.id_user AS id_user_16 FROM restaurante t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "wp-login.php"
]
0.68 ms
(16.16%)
1
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_menusdeldia"
  "db_menusdeldia"
  "doctrine_migration_versions"
]
0.58 ms
(13.76%)
2
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "db_menusdeldia"
]
0.47 ms
(11.29%)
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:
[
  "db_menusdeldia"
  "doctrine_migration_versions"
]
0.32 ms
(7.56%)
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 = 'db_menusdeldia' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "db_menusdeldia"
  "doctrine_migration_versions"
]
0.24 ms
(5.68%)
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:
[
  "db_menusdeldia"
  "doctrine_migration_versions"
]
0.24 ms
(5.61%)
1
SELECT * FROM doctrine_migration_versions
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\User No errors.
App\Entity\Restaurante No errors.
App\Entity\Image No errors.
App\Entity\Menu No errors.
Vich\UploaderBundle\Entity\File No errors.