Query Metrics
9
Database Queries
6
Different statements
5.92 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_active AS is_active_4, t0.name_hr AS name_hr_5 FROM country t0 WHERE t0.id = ?
Parameters:
[
"55"
]
|
| 2 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_active AS is_active_4, t0.name_hr AS name_hr_5 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 3 | 1.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.slug AS slug_5, t0.extract_home AS extract_home_6, t0.extract_menu AS extract_menu_7, t0.cat_order AS cat_order_8, t0.icon AS icon_9, t0.shop AS shop_10, t0.machine AS machine_11, t0.show_caliber AS show_caliber_12, t0.parent_id AS parent_id_13 FROM category t0 WHERE t0.is_active = ? AND t0.machine = ? AND t0.extract_menu = ? ORDER BY t0.cat_order ASC
Parameters:
[ 1 1 1 ] |
| 4 | 1.35 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.extract_home AS extract_home_15, t0.order_service AS order_service_16, t0.extract_menu AS extract_menu_17 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? AND t0.extract_menu = ? ORDER BY t0.order_service DESC
Parameters:
[ 1 "service" 1 ] |
| 5 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.slug AS slug_5, t0.extract_home AS extract_home_6, t0.extract_menu AS extract_menu_7, t0.cat_order AS cat_order_8, t0.icon AS icon_9, t0.shop AS shop_10, t0.machine AS machine_11, t0.show_caliber AS show_caliber_12, t0.parent_id AS parent_id_13 FROM category t0 WHERE t0.is_active = ? AND t0.shop = ? AND t0.extract_menu = ? ORDER BY t0.cat_order ASC
Parameters:
[ 1 1 1 ] |
| 6 | 0.42 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.extract_home AS extract_home_15, t0.order_service AS order_service_16, t0.extract_menu AS extract_menu_17 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? AND t0.slug = ? LIMIT 1
Parameters:
[ 1 "info" "footer" ] |
| 7 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.slug AS slug_5, t0.extract_home AS extract_home_6, t0.extract_menu AS extract_menu_7, t0.cat_order AS cat_order_8, t0.icon AS icon_9, t0.shop AS shop_10, t0.machine AS machine_11, t0.show_caliber AS show_caliber_12, t0.parent_id AS parent_id_13 FROM category t0 WHERE t0.is_active = ? AND t0.machine = ? AND t0.extract_menu = ? ORDER BY t0.cat_order ASC
Parameters:
[ 1 1 1 ] |
| 8 | 0.37 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.extract_home AS extract_home_15, t0.order_service AS order_service_16, t0.extract_menu AS extract_menu_17 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? AND t0.extract_menu = ? ORDER BY t0.order_service DESC
Parameters:
[ 1 "service" 1 ] |
| 9 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.slug AS slug_5, t0.extract_home AS extract_home_6, t0.extract_menu AS extract_menu_7, t0.cat_order AS cat_order_8, t0.icon AS icon_9, t0.shop AS shop_10, t0.machine AS machine_11, t0.show_caliber AS show_caliber_12, t0.parent_id AS parent_id_13 FROM category t0 WHERE t0.is_active = ? AND t0.shop = ? AND t0.extract_menu = ? ORDER BY t0.cat_order ASC
Parameters:
[ 1 1 1 ] |
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\Country | No errors. |
| App\Entity\Orders | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\CategoryTranslation | No errors. |
| App\Entity\ProductTranslation | No errors. |
| App\Entity\CategoryDiscount | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\Paragraph | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Colors | No errors. |
| App\Entity\Material | No errors. |
| App\Entity\Measure | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Partner | No errors. |
| App\Entity\AddToCart | No errors. |
| App\Entity\ProductCombination | No errors. |
| App\Entity\ImageTranslation | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PageTranslation | No errors. |
| App\Entity\Caliber | No errors. |