GET https://technichem.mywebcreation.be/nos-produits/dfi-systeme-ventilation

Query Metrics

32 Database Queries
7 Different statements
6.52 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 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.slug = ? LIMIT 1
Parameters:
[
  "dfi-systeme-ventilation"
]
2 0.40 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.category_id = ?
Parameters:
[
  12
]
3 0.31 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.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
]
5 0.11 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.09 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.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
]
8 0.24 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:
[]
9 0.20 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:
[]
10 0.22 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.category_id = ?
Parameters:
[
  2
]
11 0.23 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.category_id = ?
Parameters:
[
  3
]
12 0.31 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.category_id = ?
Parameters:
[
  4
]
13 0.21 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.category_id = ?
Parameters:
[
  5
]
14 0.19 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.category_id = ?
Parameters:
[
  6
]
15 0.19 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.category_id = ?
Parameters:
[
  7
]
16 0.18 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.category_id = ?
Parameters:
[
  8
]
17 0.18 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.category_id = ?
Parameters:
[
  9
]
18 0.17 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.category_id = ?
Parameters:
[
  10
]
19 0.16 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.category_id = ?
Parameters:
[
  11
]
20 0.08 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.category_id = ?
Parameters:
[
  12
]
21 0.19 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.category_id = ?
Parameters:
[
  13
]
22 0.21 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
Parameters:
[]
23 0.29 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:
[
  2
]
24 0.28 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:
[
  3
]
25 0.20 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
]
26 0.17 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:
[
  5
]
27 0.17 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:
[
  6
]
28 0.18 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:
[
  7
]
29 0.17 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:
[
  8
]
30 0.12 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:
[]
31 0.11 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
]
32 0.08 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\ProductCategory 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\Product No errors.
App\Entity\CompanyData No errors.
App\Entity\SocialNetwork 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.