Query Metrics
11
Database Queries
10
Different statements
8.99 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.12 ms |
SELECT c0_.id AS id_0, c0_.layout AS layout_1, c0_.serialized_layout AS serialized_layout_2, c0_.time_last_updated AS time_last_updated_3, c0_.synchronize_translations AS synchronize_translations_4, c0_.type AS type_5, c0_.parent_id AS parent_id_6, c0_.primary_image_id AS primary_image_id_7 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.page_id WHERE c1_.locale = ? AND c1_.permalink = ? AND c0_.parent_id IS NULL LIMIT 1
Parameters:
[ "en" "blog" ] |
2 | 0.70 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.permalink AS permalink_4, t0.category_id AS category_id_5 FROM shop_category_translation t0 WHERE t0.permalink = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "blog" "en" ] |
3 | 0.55 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.permalink AS permalink_4, t0.description AS description_5, t0.product_id AS product_id_6 FROM shop_product_translation t0 WHERE t0.permalink = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "blog" "en" ] |
4 | 0.46 ms |
SELECT j0_.id AS id_0, j0_.min_hours AS min_hours_1, j0_.max_hours AS max_hours_2, j0_.sort_order AS sort_order_3, j0_.enabled AS enabled_4 FROM jobs_job_offer j0_ LEFT JOIN jobs_job_offer_translation j1_ ON j0_.id = j1_.job_offer_id WHERE j1_.locale = ? AND j1_.permalink = ? AND j0_.enabled = 1 LIMIT 1
Parameters:
[ "en" "blog" ] |
5 | 2.29 ms |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
6 | 1.59 ms |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
7 | 0.96 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 = 'boldrdev_hb' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[] |
8 | 0.43 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 = 'boldrdev_hb' /*!50116 AND c.constraint_schema = 'boldrdev_hb' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[] |
9 | 0.30 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 = 'boldrdev_hb' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[] |
10 | 0.36 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:
[] |
11 | 0.22 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 |
---|---|
Boldr\Cms\CmsBundle\Entity\Page | No errors. |
Boldr\Cms\CmsBundle\Entity\Translation | No errors. |
Boldr\Cms\CmsBundle\Entity\PageTranslation | No errors. |
Boldr\Cms\CmsBundle\Entity\Upload | No errors. |
Boldr\Shop\ShopBundle\Entity\CategoryTranslation | No errors. |
Boldr\Shop\ShopBundle\Entity\Category | No errors. |
Boldr\Shop\ShopBundle\Entity\ProductTranslation | No errors. |
Boldr\Shop\ShopBundle\Entity\Product | No errors. |
Boldr\Cms\JobsBundle\Entity\JobOffer | No errors. |
Boldr\Cms\JobsBundle\Entity\JobOfferTranslation | No errors. |
Boldr\Cms\CmsBundle\Entity\AttachmentUsage | No errors. |
Boldr\Cms\CmsBundle\Entity\PageAttachmentUsage | No errors. |
Boldr\Cms\CmsBundle\Entity\SearchData | No errors. |
Boldr\Cms\CmsBundle\Entity\PageTranslationSearchData | No errors. |
Boldr\Cms\CmsBundle\Entity\UploadTranslation | No errors. |
Boldr\Cms\CmsBundle\Entity\UploadFolder | No errors. |
Boldr\Cms\CmsBundle\Entity\UploadTrack | No errors. |
Boldr\Shop\ShopBundle\Entity\Option | No errors. |
Boldr\Shop\ShopBundle\Entity\ProductVariant | No errors. |
Boldr\Shop\ShopBundle\Entity\ProductAttribute | No errors. |
Boldr\Shop\ShopBundle\Entity\ProductImage | No errors. |