https://tuchassou.projet-client.com/cgv

Query Metrics

12 Database Queries
8 Different statements
4.62 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "cgv"
]
2 0.56 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
3 0.40 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
4 0.17 ms
SELECT DATABASE()
Parameters:
[]
5 0.36 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 = 'tuchassou' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
6 0.17 ms
SELECT DATABASE()
Parameters:
[]
7 0.48 ms
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!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_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'tuchassou' /*!50116 AND c.CONSTRAINT_SCHEMA = 'tuchassou' */ORDER BY k.ORDINAL_POSITION
Parameters:
[]
8 0.17 ms
SELECT DATABASE()
Parameters:
[]
9 0.24 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 = 'tuchassou' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
10 0.41 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 0.20 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
12 0.22 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\User No errors.
App\Entity\Page No errors.
App\Entity\Territory No errors.
App\Entity\Booking No errors.
App\Entity\TerritoryImage No errors.
App\Entity\Offer
  • The association App\Entity\Offer#gibiers refers to the inverse side field App\Entity\Gibier#allOffers which does not exist.
App\Entity\BookingDates
  • If association App\Entity\BookingDates#Booking is one-to-one, then the inversed side App\Entity\Booking#bookingDates has to be one-to-one as well.
App\Entity\ResetPasswordRequest No errors.
App\Entity\HuntingMode No errors.
App\Entity\Weapon No errors.
App\Entity\OfferAdditionalService No errors.
App\Entity\Animal No errors.
App\Entity\OfferCancellationRequest No errors.
App\Entity\OfferImage No errors.
App\Entity\Gibier
  • The mappings App\Entity\Gibier#offers and App\Entity\Offer#gibiers are inconsistent with each other.