GET https://technichem.mywebcreation.be/nos-produits/hydrofuges-incolores/technilane

Query Metrics

17 Database Queries
11 Different statements
21.44 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 3.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.description AS description_7, t0.teasing AS teasing_8, t0.datasheet AS datasheet_9, t0.folder_file AS folder_file_10, t0.last_modified_by_id AS last_modified_by_id_11, t0.category_id AS category_id_12 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "technilane"
]
2 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.email AS email_8 FROM company_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
3 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.email AS email_8 FROM company_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
4 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.email AS email_8 FROM company_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
5 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.email AS email_8 FROM company_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
6 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.email AS email_8 FROM company_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
7 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5 FROM social_network t0
Parameters:
[]
8 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.image AS image_6, t0.last_modified_by_id AS last_modified_by_id_7 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 2.63 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
10 3.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.updated_at AS updated_at_4, t0.last_modified_by_id AS last_modified_by_id_5 FROM support t0 INNER JOIN product_support ON t0.id = product_support.support_id WHERE product_support.product_id = ?
Parameters:
[
  4
]
11 3.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.updated_at AS updated_at_4, t0.last_modified_by_id AS last_modified_by_id_5 FROM packaging t0 INNER JOIN product_packaging ON t0.id = product_packaging.packaging_id WHERE product_packaging.product_id = ?
Parameters:
[
  4
]
12 2.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.last_modified_by_id AS last_modified_by_id_7 FROM label t0 INNER JOIN product_label ON t0.id = product_label.label_id WHERE product_label.product_id = ?
Parameters:
[
  4
]
13 1.99 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.city AS city_4, t0.country AS country_5, t0.video_link AS video_link_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.last_modified_by_id AS last_modified_by_id_9 FROM working_site t0 INNER JOIN working_site_product ON t0.id = working_site_product.working_site_id WHERE working_site_product.product_id = ?
Parameters:
[
  4
]
14 2.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.description AS description_7, t0.teasing AS teasing_8, t0.datasheet AS datasheet_9, t0.folder_file AS folder_file_10, t0.last_modified_by_id AS last_modified_by_id_11, t0.category_id AS category_id_12 FROM product t0 INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = ?
Parameters:
[
  4
]
15 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.image AS image_6, t0.last_modified_by_id AS last_modified_by_id_7 FROM product_category t0
Parameters:
[]
16 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.email AS email_8 FROM company_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
17 0.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5 FROM social_network t0
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\Product No errors.
App\Entity\User
  • The association App\Entity\User#labels refers to the owning side field App\Entity\Label#last_modifed_by which does not exist.
App\Entity\ProductCategory No errors.
App\Entity\ProductImage No errors.
App\Entity\Support No errors.
App\Entity\Packaging No errors.
App\Entity\Label
  • The mappings App\Entity\Label#last_modified_by and App\Entity\User#labels are inconsistent with each other.
App\Entity\WorkingSite No errors.
App\Entity\CompanyData No errors.
App\Entity\SocialNetwork No errors.