GET https://www.dev.screenz.eu/hr/blog-hr/tko-bi-trebao-uloziti-u-oglasavanje-na-led-zaslonu/

Query Metrics

5 Database Queries
4 Different statements
83.19 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.03 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:
[
  "blog"
  "tko-bi-trebao-uloziti-u-oglasavanje-na-led-zaslonu"
  "hr"
]
2 10.41 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"
  "hr"
]
3 69.54 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:
[
  77
  1
]
4 1.04 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"
  "hr"
]
5 1.16 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"
  "hr"
]

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\Page
  • The association App\Entity\Page#createdBy refers to the inverse side field App\Entity\User#pages which does not exist.
App\Entity\PageCategory No errors.
App\Entity\Label No errors.
App\Entity\User No errors.
App\Entity\Document No errors.
App\Entity\Image No errors.
App\Entity\Paragraph No errors.
App\Entity\Item No errors.
App\Entity\Embedding No errors.
App\Entity\Modul No errors.
App\Entity\Client No errors.
App\Entity\Project No errors.
App\Entity\Workbook No errors.
App\Entity\DocumentStatus No errors.
App\Entity\Product No errors.
App\Entity\ProductCategory No errors.
App\Entity\Lead No errors.
App\Entity\Service No errors.
App\Entity\Vehicle No errors.
App\Entity\NjuskaloCategory No errors.
App\Entity\Inventory No errors.
App\Entity\Tag No errors.
App\Entity\OrderItem No errors.
App\Entity\ChatConversation No errors.
App\Entity\ChatMessage No errors.
App\Entity\UserLabel No errors.
App\Entity\DocumentEmbeddings No errors.
App\Entity\Country No errors.
App\Entity\Phase No errors.
App\Entity\ProjectStatus No errors.
App\Entity\WorkbookStatus No errors.
App\Entity\InvoiceStatus No errors.
App\Entity\WorkbookTask No errors.
App\Entity\ProductTemp No errors.
App\Entity\Order No errors.
App\Entity\WorkbookTaskExplain No errors.