GET https://omegapharmalabs.com/

Query Metrics

26 Database Queries
7 Different statements
6.97 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.icon AS icon_4, t0.webslug AS webslug_5, t0.created_on AS created_on_6, t0.updated_on AS updated_on_7 FROM category t0 ORDER BY t0.name ASC
Parameters:
[]
2 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.route_name AS route_name_3, t0.route AS route_4, t0.body AS body_5, t0.type AS type_6, t0.template_file AS template_file_7, t0.created_on AS created_on_8, t0.updated_on AS updated_on_9 FROM page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "home"
]
3 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.icon AS icon_4, t0.webslug AS webslug_5, t0.created_on AS created_on_6, t0.updated_on AS updated_on_7 FROM category t0
Parameters:
[]
4 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.icon AS icon_4, t0.webslug AS webslug_5, t0.created_on AS created_on_6, t0.updated_on AS updated_on_7 FROM category t0
Parameters:
[]
5 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.image_name AS image_name_4, t0.link AS link_5, t0.sort_index AS sort_index_6, t0.link_title AS link_title_7, t0.created_on AS created_on_8, t0.updated_on AS updated_on_9 FROM slider t0 ORDER BY t0.sort_index ASC
Parameters:
[]
6 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.webslug AS webslug_3, t0.description AS description_4, t0.directions AS directions_5, t0.is_featured AS is_featured_6, t0.price AS price_7, t0.sort_index AS sort_index_8, t0.contains AS contains_9, t0.dosage AS dosage_10, t0.brochure_file_name AS brochure_file_name_11, t0.brochure_file_size AS brochure_file_size_12, t0.featured AS featured_13, t0.created_on AS created_on_14, t0.updated_on AS updated_on_15, t0.category_id AS category_id_16, t0.main_image_id AS main_image_id_17 FROM product t0 WHERE t0.category_id = ? ORDER BY t0.name ASC
Parameters:
[
  3
]
7 0.25 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = ?
Parameters:
[
  199
]
8 0.25 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  24
]
9 0.23 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  26
]
10 0.21 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  28
]
11 0.22 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  29
]
12 0.21 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  42
]
13 0.22 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  31
]
14 0.24 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  33
]
15 0.29 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  32
]
16 0.23 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  37
]
17 0.21 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  36
]
18 0.23 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  22
]
19 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.webslug AS webslug_3, t0.description AS description_4, t0.directions AS directions_5, t0.is_featured AS is_featured_6, t0.price AS price_7, t0.sort_index AS sort_index_8, t0.contains AS contains_9, t0.dosage AS dosage_10, t0.brochure_file_name AS brochure_file_name_11, t0.brochure_file_size AS brochure_file_size_12, t0.featured AS featured_13, t0.created_on AS created_on_14, t0.updated_on AS updated_on_15, t0.category_id AS category_id_16, t0.main_image_id AS main_image_id_17 FROM product t0 WHERE t0.category_id = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
20 0.25 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  39
]
21 0.20 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = ?
Parameters:
[
  178
]
22 0.21 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
23 0.18 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = ?
Parameters:
[
  193
]
24 0.19 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = ?
Parameters:
[
  189
]
25 0.19 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = ?
Parameters:
[
  177
]
26 0.21 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = ?
Parameters:
[
  190
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ProductImage 28
App\Entity\Product 19
App\Entity\Category 2
App\Entity\Page 1