Query Metrics

8 Database Queries
7 Different statements
6.40 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.86 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.photo_title AS photo_title_7, t0.schema_title AS schema_title_8, t0.intro AS intro_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM product_translation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "obfsm:Y29udGFjdEBkbWRpbm94LmNvbQ=="
]
2 1.26 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
3 0.88 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
4 0.77 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 = 'dmdinox_dev' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
5 1.07 ms
SELECT DISTINCT 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 = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'dmdinox_dev' /*!50116 AND c.constraint_schema = 'dmdinox_dev' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
6 0.66 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 = 'dmdinox_dev' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
7 0.61 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
8 0.27 ms
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\ProductTranslation No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\SubCategory No errors.
App\Entity\SubSubCategory No errors.
App\Entity\SubSubSubCategory No errors.
App\Entity\ApplicationProduct No errors.
App\Entity\ProductMedia No errors.
App\Entity\ProductDocument No errors.
App\Entity\ProductProductTable No errors.
App\Entity\RelatedProduct No errors.
App\Entity\ProductSpreadsheet No errors.
App\Entity\GalleryItem No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\SubCategoryTranslation No errors.
App\Entity\SubSubCategoryTranslation No errors.
App\Entity\SubSubSubCategoryTranslation No errors.
App\Entity\Application No errors.
App\Entity\ProductMediaTranslation No errors.
App\Entity\Document No errors.
App\Entity\ProductTable No errors.
App\Entity\ProductSpreadsheetLine No errors.
App\Entity\PostMediaTranslation No errors.
App\Entity\DocumentCategory No errors.
App\Entity\FabricationParagraph No errors.
App\Entity\PostCategoryTranslation No errors.
App\Entity\PresentationPage No errors.
App\Entity\MemberTranslation No errors.
App\Entity\History No errors.
App\Entity\JobOfferTranslation No errors.
App\Entity\PostMedia No errors.
App\Entity\Project No errors.
App\Entity\ProductTableRow No errors.
App\Entity\ApplicationParagraph No errors.
App\Entity\PostCategory No errors.
App\Entity\ApplicationParagraphTranslation No errors.
App\Entity\Newsletter No errors.
App\Entity\Page No errors.
App\Entity\TestimonialTranslation No errors.
App\Entity\Testimonial No errors.
App\Entity\ParagraphTranslation No errors.
App\Entity\PostTranslation No errors.
App\Entity\JobOffer No errors.
App\Entity\ApplicationTranslation No errors.
App\Entity\User No errors.
App\Entity\JobOfferParagraph No errors.
App\Entity\ProjectTranslation No errors.
App\Entity\LandingSlider No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\HistoryTranslation No errors.
App\Entity\ProductTableColumn No errors.
App\Entity\PresentationParagraphTranslation No errors.
App\Entity\CustomFile No errors.
App\Entity\DocumentCategoryTranslation No errors.
App\Entity\ActualitePage No errors.
App\Entity\PageTranslation No errors.
App\Entity\Post No errors.
App\Entity\DocumentPage No errors.
App\Entity\Partner No errors.
App\Entity\LandingSliderTranslation No errors.
App\Entity\PresentationParagraph No errors.
App\Entity\ProductTableTranslation No errors.
App\Entity\FabricationPage No errors.
App\Entity\Member No errors.
App\Entity\PartnerTranslation No errors.
App\Entity\FabricationParagraphTranslation No errors.
App\Entity\Paragraph No errors.
App\Entity\Contact No errors.
App\Entity\JobOfferParagraphTranslation No errors.
App\Entity\PostDocument
  • The association App\Entity\PostDocument#post refers to the inverse side field App\Entity\Post#postDocuments which does not exist.
App\Entity\DocumentTranslation No errors.
Vich\UploaderBundle\Entity\File No errors.