https://testavoatest.avopy.com/forum/closed/456546541546543

Query Metrics

14 Database Queries
8 Different statements
8.76 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.47 ms
(28.21%)
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:
[
  "u430011172_uh32zdv"
  "u430011172_uh32zdv"
  "doctrine_migration_versions"
]
1.58 ms
(18.02%)
2
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "u430011172_uh32zdv"
]
1.14 ms
(13.05%)
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 = 'u430011172_uh32zdv' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "u430011172_uh32zdv"
  "doctrine_migration_versions"
]
1.08 ms
(12.33%)
6
SELECT DATABASE()
Parameters:
[]
1.01 ms
(11.55%)
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:
[
  "u430011172_uh32zdv"
  "doctrine_migration_versions"
]
0.66 ms
(7.54%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.actived AS actived_5, t0.closed AS closed_6, t0.closed_at AS closed_at_7, t0.slug AS slug_8, t0.forum_user_id AS forum_user_id_9, t0.topic_id AS topic_id_10 FROM forum_post t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.41 ms
(4.71%)
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:
[
  "u430011172_uh32zdv"
  "doctrine_migration_versions"
]
0.40 ms
(4.58%)
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\ForumPost No errors.
App\Entity\ForumUser No errors.
App\Entity\ForumTopic No errors.
App\Entity\ForumComment No errors.
App\Entity\ForumNotificationSubscriber No errors.
App\Entity\Message No errors.
App\Entity\Room
  • The mappings App\Entity\Room#called and App\Entity\User#rooms are inconsistent with each other.
App\Entity\Offer No errors.
App\Entity\Notification No errors.
App\Entity\ForumReport No errors.
App\Entity\Society No errors.
App\Entity\Profile No errors.
App\Entity\OfferFavorite No errors.
App\Entity\AuthLog No errors.
App\Entity\OfferVisit No errors.
App\Entity\Report
  • The association App\Entity\Report#society refers to the inverse side field App\Entity\Society#reports which does not exist.
  • The association App\Entity\Report#profile refers to the inverse side field App\Entity\Profile#reports which does not exist.
App\Entity\OfferAlert No errors.
App\Entity\ProfileFavorite No errors.
App\Entity\ForumCommentReply No errors.
App\Entity\ForumCategory No errors.
App\Entity\Candidature No errors.