Query Metrics
5
Database Queries
4
Different statements
76.55 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 57.99 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.extract_slider AS extract_slider_18, p0_.order_home AS order_home_19, p0_.order_category AS order_category_20, p0_.order_menu AS order_menu_21, p0_.order_slider AS order_slider_22, p0_.locked AS locked_23, p0_.hidden AS hidden_24, p0_.price AS price_25, p0_.locale AS locale_26, p0_.author AS author_27, p0_.author_link AS author_link_28, p0_.author_title AS author_title_29, p0_.tt AS tt_30, p0_.json_data AS json_data_31, p0_.keywords AS keywords_32, p0_.page_category_id AS page_category_id_33, p0_.label_id AS label_id_34, p0_.created_by_id AS created_by_id_35 FROM page p0_ INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id WHERE p1_.slug = ? AND p0_.slug = ? AND p0_.locale = ? LIMIT 1
Parameters:
[ "novosti" "screenz-company-eu-led-factory-for-outdoor-and-indoor-solutions" "en" ]
|
||||||||||||||||||||||||||||
| 2 | 15.79 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.extract_slider AS extract_slider_18, p0_.order_home AS order_home_19, p0_.order_category AS order_category_20, p0_.order_menu AS order_menu_21, p0_.order_slider AS order_slider_22, p0_.locked AS locked_23, p0_.hidden AS hidden_24, p0_.price AS price_25, p0_.locale AS locale_26, p0_.author AS author_27, p0_.author_link AS author_link_28, p0_.author_title AS author_title_29, p0_.tt AS tt_30, p0_.json_data AS json_data_31, p0_.keywords AS keywords_32, p0_.page_category_id AS page_category_id_33, p0_.label_id AS label_id_34, p0_.created_by_id AS created_by_id_35 FROM page p0_ INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.locale = ? ORDER BY p0_.published DESC LIMIT 4
Parameters:
[ "novosti" "en" ]
|
||||||||||||||||||||||||||||
| 3 | 0.52 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.created AS created_6, t0.guid AS guid_7, t0.is_active AS is_active_8, t0.main_image AS main_image_9, t0.icon_image AS icon_image_10, t0.bg_image AS bg_image_11, t0.video_url AS video_url_12, t0.published AS published_13, t0.color_font AS color_font_14, t0.color_bg AS color_bg_15, t0.extract_home AS extract_home_16, t0.extract_category AS extract_category_17, t0.extract_menu AS extract_menu_18, t0.order_home AS order_home_19, t0.order_category AS order_category_20, t0.order_menu AS order_menu_21, t0.price AS price_22, t0.locked AS locked_23, t0.modul_id AS modul_id_24, t0.label_id AS label_id_25, t0.client_id AS client_id_26, t0.project_id AS project_id_27, t0.workbook_id AS workbook_id_28, t0.document_status_id AS document_status_id_29, t0.product_id AS product_id_30, t0.product_category_id AS product_category_id_31, t0.lead_by_id AS lead_by_id_32, t0.page_id AS page_id_33, t0.page_category_id AS page_category_id_34, t0.service_id AS service_id_35, t0.paragraph_id AS paragraph_id_36, t0.vehicle_id AS vehicle_id_37, t0.item_id AS item_id_38 FROM image t0 WHERE t0.page_id = ? AND t0.is_active = ? ORDER BY t0.id DESC
Parameters:
[ 33 1 ]
|
||||||||||||||||||||||||||||
| 4 | 1.13 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.locale = ? ORDER BY p0_.id ASC LIMIT 20
Parameters:
[ "proizvodi" "en" ] |
||||||||||||||||||||||||||||
| 5 | 1.11 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.locale = ? ORDER BY p0_.id ASC LIMIT 20
Parameters:
[ "proizvodi" "en" ] |
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.