Query Metrics

23 Database Queries
8 Different statements
1585.34 ms Query time
0 Invalid entities
668 Managed entities

Queries

Group similar statements

# Time Info
1 52.98 ms
SELECT i0_.id AS id_0, i0_.name_en AS name_en_1, i0_.name_fa AS name_fa_2, i0_.brand_en AS brand_en_3, i0_.brand_fa AS brand_fa_4, i0_.name_brand_en AS name_brand_en_5, i0_.name_brand_fa AS name_brand_fa_6, i0_.erx_code AS erx_code_7, i0_.erx_code_base AS erx_code_base_8, i0_.rx_behdasht AS rx_behdasht_9, i0_.generic_code AS generic_code_10, i0_.mother_code AS mother_code_11, i0_.licence_owner AS licence_owner_12, i0_.brand_owner AS brand_owner_13, i0_.brand_owner_country AS brand_owner_country_14, i0_.producer AS producer_15, i0_.producer_country AS producer_country_16, i0_.name_interactive AS name_interactive_17, i0_.packing AS packing_18, i0_.form AS form_19, i0_.pregnancy_category AS pregnancy_category_20, i0_.other AS other_21, i0_.features AS features_22, i0_.video_id AS video_id_23, i0_.last_price AS last_price_24, i0_.only_doctor_user AS only_doctor_user_25, i0_.status AS status_26, i1_.id AS id_27, i1_.pic_ext AS pic_ext_28, i1_.type AS type_29, i1_.updated_at AS updated_at_30, c2_.id AS id_31, c2_.name AS name_32, c2_.code AS code_33, c2_.level AS level_34, c2_.pic_ext AS pic_ext_35, c2_.features AS features_36, c2_.raychat_code AS raychat_code_37, c2_.visible AS visible_38, c2_.updated_at AS updated_at_39, i0_.license_owner_id AS license_owner_id_40, i1_.item_id AS item_id_41, c2_.parent_id AS parent_id_42 FROM item i0_ LEFT JOIN item_media i1_ ON i0_.id = i1_.item_id AND (i1_.type = ?) INNER JOIN item_category i3_ ON i0_.id = i3_.item_id INNER JOIN category c2_ ON c2_.id = i3_.category_id WHERE i0_.erx_code = ?
Parameters:
[
  1
  "eRx650102"
]
2 0.51 ms
SELECT count(i0_.id) AS sclr_0 FROM item_drugstore i0_ INNER JOIN user u1_ ON i0_.drugstore_id = u1_.id INNER JOIN item i2_ ON i0_.item_id = i2_.id WHERE i2_.id = ? AND u1_.status = ? AND u1_.enabled = ? AND i0_.exist = 1 AND i2_.status = ?
Parameters:
[
  502451
  2
  1
  1
]
3 1520.82 ms
SELECT i0_.id AS id_0, i0_.name_en AS name_en_1, i0_.name_fa AS name_fa_2, i0_.brand_en AS brand_en_3, i0_.brand_fa AS brand_fa_4, i0_.name_brand_en AS name_brand_en_5, i0_.name_brand_fa AS name_brand_fa_6, i0_.erx_code AS erx_code_7, i0_.erx_code_base AS erx_code_base_8, i0_.rx_behdasht AS rx_behdasht_9, i0_.generic_code AS generic_code_10, i0_.mother_code AS mother_code_11, i0_.licence_owner AS licence_owner_12, i0_.brand_owner AS brand_owner_13, i0_.brand_owner_country AS brand_owner_country_14, i0_.producer AS producer_15, i0_.producer_country AS producer_country_16, i0_.name_interactive AS name_interactive_17, i0_.packing AS packing_18, i0_.form AS form_19, i0_.pregnancy_category AS pregnancy_category_20, i0_.other AS other_21, i0_.features AS features_22, i0_.video_id AS video_id_23, i0_.last_price AS last_price_24, i0_.only_doctor_user AS only_doctor_user_25, i0_.status AS status_26, RAND() AS sclr_27, i0_.license_owner_id AS license_owner_id_28 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id WHERE c1_.id = ? AND i0_.id <> ? ORDER BY sclr_27 ASC, i0_.id DESC LIMIT 8
Parameters:
[
  6532
  502451
]
4 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ?
Parameters:
[
  6506
]
5 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ?
Parameters:
[
  6502
]
6 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ?
Parameters:
[
  6136
]
7 0.31 ms
SELECT t0.id AS id_1, t0.about_us AS about_us_2, t0.contact_us AS contact_us_3, t0.introduce AS introduce_4, t0.privacy_policy_ext AS privacy_policy_ext_5, t0.terms_and_conditions_ext AS terms_and_conditions_ext_6, t0.website_title AS website_title_7, t0.meta_description AS meta_description_8, t0.footer_description AS footer_description_9, t0.logo_ext AS logo_ext_10, t0.fav_icon_ext AS fav_icon_ext_11, t0.top_banner_ext AS top_banner_ext_12, t0.top_banner_link AS top_banner_link_13, t0.updated_at AS updated_at_14, t0.footer_column1_title AS footer_column1_title_15, t0.footer_column2_title AS footer_column2_title_16, t0.footer_column3_title AS footer_column3_title_17, t0.footer_column4_title AS footer_column4_title_18, t0.buy_without_login AS buy_without_login_19, t0.footer_social_instagram AS footer_social_instagram_20, t0.footer_social_whatsapp AS footer_social_whatsapp_21, t0.footer_social_telegram AS footer_social_telegram_22, t0.footer_social_twitter AS footer_social_twitter_23, t0.footer_script AS footer_script_24, t0.cart_item_count_step AS cart_item_count_step_25 FROM setting t0 LIMIT 1
Parameters:
[]
8 3.00 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = ?
Parameters:
[
  1
]
9 0.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
Parameters:
[
  0
]
10 2.97 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = ?
Parameters:
[
  1
]
11 0.45 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
Parameters:
[
  0
]
12 0.41 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  513827
]
13 0.23 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  474012
]
14 0.20 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  390011
]
15 0.19 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  380612
]
16 0.22 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  397811
]
17 0.19 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  426192
]
18 0.19 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  495474
]
19 0.22 ms
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
Parameters:
[
  455634
]
20 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
Parameters:
[
  1
]
21 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
Parameters:
[
  2
]
22 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
Parameters:
[
  3
]
23 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
Parameters:
[
  4
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Category 650
App\Entity\Item 9
App\Entity\Menu 8
App\Entity\Setting 1