Query Metrics
15
Database Queries
14
Different statements
9.94 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.99 ms (20.05%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title_tag AS title_tag_3, t0.meta_description AS meta_description_4, t0.slug AS slug_5, t0.description AS description_6, t0.price AS price_7, t0.created AS created_8, t0.is_active AS is_active_9, t0.extracted_home AS extracted_home_10, t0.image AS image_11, t0.price_eur AS price_eur_12, t0.description_link AS description_link_13, t0.pdf AS pdf_14, t0.most_sold AS most_sold_15, t0.new AS new_16, t0.sku AS sku_17, t0.short_name AS short_name_18, t0.model_name AS model_name_19, t0.width AS width_20, t0.height AS height_21, t0.lenght AS lenght_22, t0.diameter AS diameter_23, t0.weight AS weight_24, t0.literage AS literage_25, t0.slider AS slider_26, t0.order_slider AS order_slider_27, t0.slider_bg AS slider_bg_28, t0.order_extracted AS order_extracted_29, t0.short_text AS short_text_30, t0.partner_sku AS partner_sku_31, t0.partner_id AS partner_id_32, t0.partner_product_number AS partner_product_number_33, t0.image_external AS image_external_34, t0.kamado_extracted AS kamado_extracted_35, t0.remark AS remark_36, t0.posalji_upit AS posalji_upit_37, t0.price_eur_discount AS price_eur_discount_38, t0.not_available AS not_available_39, t0.video AS video_40, t0.shop AS shop_41, t0.machine AS machine_42, t0.image_tech_specs AS image_tech_specs_43, t0.order_cat AS order_cat_44, t0.order_shop AS order_shop_45, t0.gallery_id AS gallery_id_46, t0.category_id AS category_id_47, t0.color_id AS color_id_48, t0.material_id AS material_id_49, t0.measure_id AS measure_id_50, t0.partner_id AS partner_id_51 FROM product t0 WHERE t0.slug = ? AND t0.id = ? LIMIT 1
Parameters:
[ "keramicki-prsten-d41-h48-5-m11" "82" ] |
1.16 ms (11.64%) |
1 |
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 ] |
1.13 ms (11.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.caliber AS caliber_4, t0.laser_head AS laser_head_5, t0.price15 AS price15_6, t0.price30 AS price30_7, t0.price30over AS price30over_8, t0.active AS active_9, t0.image AS image_10, t0.price AS price_11, t0.locale AS locale_12, t0.price_din AS price_din_13, t0.product_id AS product_id_14 FROM product_combination t0 WHERE t0.active = ? AND t0.product_id = ? AND t0.locale = ? ORDER BY t0.id ASC
Parameters:
[ 1 82 "hr" ] |
1.09 ms (10.96%) |
1 |
SELECT t0.id AS id_1, t0.caliber AS caliber_2, t0.active AS active_3, t0.name AS name_4, t0.locale AS locale_5, t0.product_combination_id AS product_combination_id_6 FROM caliber t0 WHERE t0.active = ? ORDER BY t0.caliber ASC
Parameters:
[
1
]
|
0.84 ms (8.42%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.price_from AS price_from_3, t0.price_to AS price_to_4, t0.percentage AS percentage_5, t0.is_active AS is_active_6, t0.category_id AS category_id_7 FROM category_discount t0 WHERE t0.category_id = ? AND t0.is_active = ? ORDER BY t0.id ASC
Parameters:
[ 16 1 ] |
0.73 ms (7.35%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.external AS external_3, t0.type AS type_4, t0.name AS name_5, t0.size AS size_6, t0.short_description AS short_description_7, t0.image_order AS image_order_8, t0.is_active AS is_active_9, t0.active_image AS active_image_10, t0.gallery_id AS gallery_id_11, t0.product_id AS product_id_12, t0.page_id AS page_id_13 FROM image t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
82
]
|
0.66 ms (6.63%) |
1 |
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.id = ?
Parameters:
[
16
]
|
0.50 ms (5.05%) |
2 |
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 ] |
0.42 ms (4.19%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title_tag AS title_tag_3, t0.meta_description AS meta_description_4, t0.slug AS slug_5, t0.description AS description_6, t0.price AS price_7, t0.created AS created_8, t0.is_active AS is_active_9, t0.extracted_home AS extracted_home_10, t0.image AS image_11, t0.price_eur AS price_eur_12, t0.description_link AS description_link_13, t0.pdf AS pdf_14, t0.most_sold AS most_sold_15, t0.new AS new_16, t0.sku AS sku_17, t0.short_name AS short_name_18, t0.model_name AS model_name_19, t0.width AS width_20, t0.height AS height_21, t0.lenght AS lenght_22, t0.diameter AS diameter_23, t0.weight AS weight_24, t0.literage AS literage_25, t0.slider AS slider_26, t0.order_slider AS order_slider_27, t0.slider_bg AS slider_bg_28, t0.order_extracted AS order_extracted_29, t0.short_text AS short_text_30, t0.partner_sku AS partner_sku_31, t0.partner_id AS partner_id_32, t0.partner_product_number AS partner_product_number_33, t0.image_external AS image_external_34, t0.kamado_extracted AS kamado_extracted_35, t0.remark AS remark_36, t0.posalji_upit AS posalji_upit_37, t0.price_eur_discount AS price_eur_discount_38, t0.not_available AS not_available_39, t0.video AS video_40, t0.shop AS shop_41, t0.machine AS machine_42, t0.image_tech_specs AS image_tech_specs_43, t0.order_cat AS order_cat_44, t0.order_shop AS order_shop_45, t0.gallery_id AS gallery_id_46, t0.category_id AS category_id_47, t0.color_id AS color_id_48, t0.material_id AS material_id_49, t0.measure_id AS measure_id_50, t0.partner_id AS partner_id_51 FROM product t0 WHERE t0.is_active = ? AND t0.category_id = ? ORDER BY t0.id ASC LIMIT 4
Parameters:
[ 1 16 ] |
0.33 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.caliber AS caliber_4, t0.laser_head AS laser_head_5, t0.price15 AS price15_6, t0.price30 AS price30_7, t0.price30over AS price30over_8, t0.active AS active_9, t0.image AS image_10, t0.price AS price_11, t0.locale AS locale_12, t0.price_din AS price_din_13, t0.product_id AS product_id_14 FROM product_combination t0 WHERE t0.active = ? AND t0.product_id = ? AND t0.locale = ?
Parameters:
[ 1 82 "hr" ] |
0.31 ms (3.08%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.caliber AS caliber_4, t0.laser_head AS laser_head_5, t0.price15 AS price15_6, t0.price30 AS price30_7, t0.price30over AS price30over_8, t0.active AS active_9, t0.image AS image_10, t0.price AS price_11, t0.locale AS locale_12, t0.price_din AS price_din_13, t0.product_id AS product_id_14 FROM product_combination t0 WHERE t0.product_id = ?
Parameters:
[
82
]
|
0.28 ms (2.82%) |
1 |
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" ] |
0.28 ms (2.79%) |
1 |
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 ] |
0.24 ms (2.41%) |
1 |
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.parent_id IS NULL ORDER BY t0.cat_order ASC
Parameters:
[
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\Product | No errors. |
App\Entity\Gallery | No errors. |
App\Entity\Category | 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\ProductTranslation | No errors. |
App\Entity\ProductCombination | No errors. |
App\Entity\ImageTranslation | No errors. |
App\Entity\Caliber | No errors. |
App\Entity\CategoryDiscount | No errors. |
App\Entity\Article | No errors. |
App\Entity\CategoryTranslation | No errors. |
App\Entity\Page | No errors. |
App\Entity\Orders | No errors. |
App\Entity\Paragraph | No errors. |
App\Entity\Tag | No errors. |
App\Entity\PageTranslation | No errors. |
App\Entity\Country | No errors. |