https://ht-flooring.com/en/woven-vinyl-floors

Query Metrics

1233 Database Queries
15 Different statements
797.04 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
384.74 ms
(0.00%)
52
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:
[
  25
  "App\Entity\Section"
]
278.96 ms
(0.00%)
833
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:
[
  "7"
  "en"
  "App\Entity\SeoPage"
]
53.80 ms
(0.00%)
118
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 INNER JOIN product_project ON t0.id = product_project.product_id WHERE product_project.project_id = ?
Parameters:
[
  1
]
40.22 ms
(0.00%)
119
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.actif AS actif_4 FROM shape t0 INNER JOIN shape_project ON t0.id = shape_project.shape_id WHERE shape_project.project_id = ?
Parameters:
[
  1
]
22.81 ms
(0.00%)
68
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.actif AS actif_4 FROM color t0 INNER JOIN color_product ON t0.id = color_product.color_id WHERE color_product.product_id = ?
Parameters:
[
  33
]
7.01 ms
(0.00%)
27
SELECT t0.id AS id_1, t0.name AS name_2, t0.cc AS cc_3, t0.bcc AS bcc_4, t0.alpha2 AS alpha2_5, t0.agent_id AS agent_id_6, t7.id AS id_8, t7.first_name AS first_name_9, t7.last_name AS last_name_10, t7.email_address AS email_address_11, t7.phone_number AS phone_number_12, t7.company_name AS company_name_13, t7.localisation AS localisation_14, t7.city AS city_15, t7.actif AS actif_16, t7.slug AS slug_17, t7.current_locale AS current_locale_18 FROM country t0 INNER JOIN agent t7 ON t0.agent_id = t7.id WHERE t0.id = ?
Parameters:
[
  69
]
3.24 ms
(0.00%)
8
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:
[
  25
]
2.59 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.website_company AS website_company_3, t0.name AS name_4, t0.description AS description_5, t0.year AS year_6, t0.city AS city_7, t0.area_m AS area_m_8, t0.architect AS architect_9, t0.website_architect AS website_architect_10, t0.photography AS photography_11, t0.installation AS installation_12, t0.actif AS actif_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.kind_project_id AS kind_project_id_17, t18.id AS id_19, t18.name AS name_20, t18.slug AS slug_21, t0.country_id AS country_id_22, t23.id AS id_24, t23.name AS name_25, t23.caption AS caption_26, t23.path AS path_27, t23.size AS size_28, t23.created_at AS created_at_29, t23.updated_at AS updated_at_30, t23.to_show AS to_show_31, t23.collection_id AS collection_id_32, t23.product_id AS product_id_33, t23.project_id AS project_id_34, t23.section_id AS section_id_35 FROM project t0 INNER JOIN kind_project t18 ON t0.kind_project_id = t18.id LEFT JOIN attachment t23 ON t23.project_id = t0.id
Parameters:
[]
1.72 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:
[
  "%product%"
]
0.42 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.designation AS designation_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.url_video AS url_video_8, t9.id AS id_10, t9.name AS name_11, t9.caption AS caption_12, t9.path AS path_13, t9.size AS size_14, t9.created_at AS created_at_15, t9.updated_at AS updated_at_16, t9.to_show AS to_show_17, t9.collection_id AS collection_id_18, t9.product_id AS product_id_19, t9.project_id AS project_id_20, t9.section_id AS section_id_21, t0.seo_page_id AS seo_page_id_22 FROM section t0 LEFT JOIN attachment t9 ON t9.section_id = t0.id WHERE t0.seo_page_id = ?
Parameters:
[
  25
]
0.41 ms
(0.00%)
1
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/woven-vinyl-floors"
]
0.29 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.index_google AS index_google_3, t0.follow_google AS follow_google_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.route_name AS route_name_10 FROM seo_page t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "About our floors"
]
0.28 ms
(0.00%)
1
SELECT c0_.id AS id_0 FROM color c0_ GROUP BY c0_.id ORDER BY c0_.name ASC
Parameters:
[]
0.27 ms
(0.00%)
1
SELECT s0_.id AS id_0 FROM shape s0_ GROUP BY s0_.id ORDER BY s0_.name ASC
Parameters:
[]
0.27 ms
(0.00%)
1
SELECT k0_.id AS id_0 FROM kind_project k0_ GROUP BY k0_.id ORDER BY k0_.name ASC
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\Shape No errors.
App\Entity\Color No errors.
App\Entity\Order No errors.
App\Entity\Agent No errors.
App\Entity\Region No errors.
App\Entity\Area No errors.
App\Entity\Address No errors.