https://helensbakery.boldrdev.nl/blog

Query Metrics

11 Database Queries
10 Different statements
8.99 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.