https://ht-flooring.com/en/collection-overview/colourful-8

Query Metrics

73 Database Queries
9 Different statements
114.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
94.61 ms
(0.00%)
13
SELECT e0_.content AS content_0, e0_.field AS field_1, e0_.locale AS locale_2 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.object_class = ? ORDER BY e0_.locale ASC
Parameters:
[
  14
  "App\Entity\Section"
]
8.98 ms
(0.00%)
30
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "4"
  "en"
  "App\Entity\SeoPage"
]
5.05 ms
(0.00%)
13
SELECT t0.id AS id_1, t0.name AS name_2, t0.caption AS caption_3, t0.path AS path_4, t0.size AS size_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.to_show AS to_show_8, t0.collection_id AS collection_id_9, t0.product_id AS product_id_10, t0.project_id AS project_id_11, t0.section_id AS section_id_12 FROM attachment t0 WHERE t0.section_id = ?
Parameters:
[
  14
]
2.99 ms
(0.00%)
11
SELECT content FROM `ext_translations` WHERE `foreign_key` = :id AND `object_class` = :class AND `field` = :field AND `locale` = :locale
Parameters:
[
  "id" => 462
  "class" => "App\Entity\Attachment"
  "field" => "caption"
  "locale" => "en"
]
0.74 ms
(0.00%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.index_google AS index_google_2, s0_.follow_google AS follow_google_3, s0_.slug AS slug_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.meta_title AS meta_title_7, s0_.meta_description AS meta_description_8, s0_.route_name AS route_name_9, s1_.id AS id_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.content AS content_13, s1_.designation AS designation_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s1_.url_video AS url_video_17, s1_.seo_page_id AS seo_page_id_18 FROM seo_page s0_ LEFT JOIN section s1_ ON s0_.id = s1_.seo_page_id WHERE s0_.slug LIKE ?
Parameters:
[
  "%collection%"
]
0.69 ms
(0.00%)
2
SELECT t0.id AS id_1, t0.old_url AS old_url_2, t0.new_url AS new_url_3 FROM custom_redirection t0 WHERE t0.old_url = ? LIMIT 1
Parameters:
[
  "/en/collection-overview/colourful-8"
]
0.44 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.launch_year AS launch_year_4, t0.roll AS roll_5, t0.tile AS tile_6, t0.checkerboard AS checkerboard_7, t0.monolithic AS monolithic_8, t0.brick AS brick_9, t0.ashlar AS ashlar_10, t0.order_appearance AS order_appearance_11, t0.actif AS actif_12, t0.slug AS slug_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.new AS new_16, t17.id AS id_18, t17.name AS name_19, t17.caption AS caption_20, t17.path AS path_21, t17.size AS size_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.to_show AS to_show_25, t17.collection_id AS collection_id_26, t17.product_id AS product_id_27, t17.project_id AS project_id_28, t17.section_id AS section_id_29 FROM collection t0 LEFT JOIN attachment t17 ON t17.collection_id = t0.id WHERE t0.id = ?
Parameters:
[
  "8"
]
0.35 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.color_code AS color_code_4, t0.best_seller AS best_seller_5, t0.order_appearance AS order_appearance_6, t0.file_archi AS file_archi_7, t0.file_revit AS file_revit_8, t0.actif AS actif_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.new AS new_13, t0.moq AS moq_14, t0.stock AS stock_15, t16.id AS id_17, t16.name AS name_18, t16.caption AS caption_19, t16.path AS path_20, t16.size AS size_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.to_show AS to_show_24, t16.collection_id AS collection_id_25, t16.product_id AS product_id_26, t16.project_id AS project_id_27, t16.section_id AS section_id_28, t0.collection_id AS collection_id_29 FROM product t0 LEFT JOIN attachment t16 ON t16.product_id = t0.id WHERE t0.collection_id = ?
Parameters:
[
  8
]
0.31 ms
(0.00%)
1
SELECT p0_.id AS id_0, p0_.company_name AS company_name_1, p0_.website_company AS website_company_2, p0_.name AS name_3, p0_.description AS description_4, p0_.year AS year_5, p0_.city AS city_6, p0_.area_m AS area_m_7, p0_.architect AS architect_8, p0_.website_architect AS website_architect_9, p0_.photography AS photography_10, p0_.installation AS installation_11, p0_.actif AS actif_12, p0_.slug AS slug_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.kind_project_id AS kind_project_id_16, p0_.country_id AS country_id_17 FROM project p0_ LEFT JOIN product_project p2_ ON p0_.id = p2_.project_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE p0_.actif = 1 AND p1_.id IN (?)
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\CustomRedirection No errors.
App\Entity\SeoPage No errors.
App\Entity\Section No errors.
App\Entity\Attachment No errors.
App\Entity\Collection No errors.
App\Entity\Product No errors.
App\Entity\Project No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
App\Entity\KindProject No errors.
App\Entity\Country No errors.
App\Entity\Contact No errors.
App\Entity\Address No errors.
App\Entity\Newsletter No errors.
App\Entity\Color No errors.
App\Entity\Order No errors.
App\Entity\Shape No errors.
App\Entity\Region No errors.
App\Entity\Area No errors.
App\Entity\Agent No errors.