Query Metrics
11
Database Queries
8
Different statements
4.71 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.70 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.slug = ? LIMIT 1
Parameters:
[
"keramicki-prstenovi"
]
|
2 | 0.41 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.parent_id = ?
Parameters:
[
16
]
|
3 | 0.62 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.title_tag AS title_tag_2, p0_.meta_description AS meta_description_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.price AS price_6, p0_.created AS created_7, p0_.is_active AS is_active_8, p0_.extracted_home AS extracted_home_9, p0_.image AS image_10, p0_.price_eur AS price_eur_11, p0_.description_link AS description_link_12, p0_.pdf AS pdf_13, p0_.most_sold AS most_sold_14, p0_.new AS new_15, p0_.sku AS sku_16, p0_.short_name AS short_name_17, p0_.model_name AS model_name_18, p0_.width AS width_19, p0_.height AS height_20, p0_.lenght AS lenght_21, p0_.diameter AS diameter_22, p0_.weight AS weight_23, p0_.literage AS literage_24, p0_.slider AS slider_25, p0_.order_slider AS order_slider_26, p0_.slider_bg AS slider_bg_27, p0_.order_extracted AS order_extracted_28, p0_.short_text AS short_text_29, p0_.partner_sku AS partner_sku_30, p0_.partner_id AS partner_id_31, p0_.partner_product_number AS partner_product_number_32, p0_.image_external AS image_external_33, p0_.kamado_extracted AS kamado_extracted_34, p0_.remark AS remark_35, p0_.posalji_upit AS posalji_upit_36, p0_.price_eur_discount AS price_eur_discount_37, p0_.not_available AS not_available_38, p0_.video AS video_39, p0_.shop AS shop_40, p0_.machine AS machine_41, p0_.image_tech_specs AS image_tech_specs_42, p0_.order_cat AS order_cat_43, p0_.order_shop AS order_shop_44, p0_.gallery_id AS gallery_id_45, p0_.category_id AS category_id_46, p0_.color_id AS color_id_47, p0_.material_id AS material_id_48, p0_.measure_id AS measure_id_49, p0_.partner_id AS partner_id_50 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id IN (16) AND p0_.is_active = ? AND p0_.shop = ? ORDER BY p0_.order_cat DESC
Parameters:
[ 1 1 ] |
4 | 0.26 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 = ? ORDER BY t0.cat_order ASC
Parameters:
[ 1 1 ] |
5 | 0.49 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 ] |
6 | 0.46 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 ] |
7 | 0.37 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 ] |
8 | 0.33 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" ] |
9 | 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.machine = ? AND t0.extract_menu = ? ORDER BY t0.cat_order ASC
Parameters:
[ 1 1 1 ] |
10 | 0.40 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 ] |
11 | 0.29 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\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\Gallery | No errors. |
App\Entity\Colors | No errors. |
App\Entity\Material | No errors. |
App\Entity\Measure | No errors. |
App\Entity\Partner | No errors. |
App\Entity\Contact | No errors. |
App\Entity\OrderItem | No errors. |
App\Entity\Image | No errors. |
App\Entity\AddToCart | No errors. |
App\Entity\ProductCombination | No errors. |
App\Entity\ImageTranslation | No errors. |
App\Entity\Paragraph | No errors. |
App\Entity\Tag | No errors. |
App\Entity\Page | No errors. |
App\Entity\Orders | No errors. |
App\Entity\Caliber | No errors. |
App\Entity\PageTranslation | No errors. |
App\Entity\Country | No errors. |