Query Metrics

23 Database Queries
8 Different statements
1738.35 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 21.13 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
  "eRx605971"
]
2 0.71 ms
SELECT i0_.id AS id_0, i0_.sale_code AS sale_code_1, i0_.exist AS exist_2, i0_.last_percent_price AS last_percent_price_3, i0_.last_custom_price AS last_custom_price_4, i0_.broadcast_code AS broadcast_code_5, i0_.broadcast_name AS broadcast_name_6, i0_.respite AS respite_7, i0_.award AS award_8, i0_.date_expire AS date_expire_9, i0_.date_update AS date_update_10, i0_.inventory AS inventory_11, u1_.username AS username_12, u1_.username_canonical AS username_canonical_13, u1_.email AS email_14, u1_.email_canonical AS email_canonical_15, u1_.enabled AS enabled_16, u1_.salt AS salt_17, u1_.password AS password_18, u1_.last_login AS last_login_19, u1_.confirmation_token AS confirmation_token_20, u1_.password_requested_at AS password_requested_at_21, u1_.roles AS roles_22, u1_.id AS id_23, u1_.full_name AS full_name_24, u1_.code_melli AS code_melli_25, u1_.mobile AS mobile_26, u1_.mail AS mail_27, u1_.insert_date AS insert_date_28, u1_.api_key AS api_key_29, u1_.pic_ext AS pic_ext_30, u1_.updated_at AS updated_at_31, u1_.medical_council_code AS medical_council_code_32, u1_.drugstore_code AS drugstore_code_33, u1_.drugstore_originator AS drugstore_originator_34, u1_.drugstore_license AS drugstore_license_35, u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_36, u1_.drugstore_hix AS drugstore_hix_37, u1_.drugstore_gln AS drugstore_gln_38, u1_.birth_date AS birth_date_39, u1_.status AS status_40, u1_.is_male AS is_male_41, u1_.is_information_complete AS is_information_complete_42, u1_.description AS description_43, u1_.operator_job_title AS operator_job_title_44, u1_.auth_code AS auth_code_45, u1_.trusted_version AS trusted_version_46, u1_.balance AS balance_47, u1_.operator_all_categories AS operator_all_categories_48, u1_.operator_all_license_owners AS operator_all_license_owners_49, u1_.cart_count AS cart_count_50, i0_.item_id AS item_id_51, i0_.drugstore_id AS drugstore_id_52, u1_.city_id AS city_id_53, u1_.type_id AS type_id_54 FROM item_drugstore i0_ INNER JOIN user u1_ ON i0_.drugstore_id = u1_.id INNER JOIN address a2_ ON u1_.id = a2_.user_id INNER JOIN drugstore_type d3_ ON u1_.type_id = d3_.id INNER JOIN item i4_ ON i0_.item_id = i4_.id WHERE i4_.id = ? AND u1_.status = ? AND u1_.enabled = ? AND i0_.exist = 1 AND i4_.status = ? AND u1_.id <> ? ORDER BY i0_.last_percent_price DESC LIMIT 20
Parameters:
[
  448539
  2
  1
  1
  null
]
3 1661.67 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:
[
  6519
  448539
]
4 0.35 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:
[
  6507
]
5 6.11 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.19 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.33 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 FROM setting t0 LIMIT 1
Parameters:
[]
8 15.24 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.41 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 5.08 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 9.16 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.35 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:
[
  434967
]
13 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:
[
  482563
]
14 0.18 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:
[
  401891
]
15 3.14 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:
[
  390363
]
16 2.79 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:
[
  439089
]
17 3.80 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:
[
  339784
]
18 0.21 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:
[
  374852
]
19 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:
[
  366220
]
20 3.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.28 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 3.25 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.27 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.

Entities Mapping

Class Mapping errors
App\Entity\Item No errors.
App\Entity\ItemMedia No errors.
App\Entity\Category No errors.
App\Entity\LicenseOwner No errors.
App\Entity\ShopSpecial No errors.
App\Entity\ItemBarcode No errors.
App\Entity\ItemIRC No errors.
App\Entity\ItemPriceHistory No errors.
App\Entity\ItemDrugstore No errors.
App\Entity\ItemUser No errors.
App\Entity\CartItem No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
App\Entity\Address No errors.
App\Entity\DrugstoreType No errors.
App\Entity\City
  • The mappings App\Entity\City#carts and App\Entity\Cart#addressCity are inconsistent with each other.
App\Entity\Setting No errors.
App\Entity\Menu
  • The association App\Entity\Menu#category refers to the inverse side field App\Entity\Category#menus which does not exist.
App\Entity\Page No errors.
App\Entity\ItemDrugstorePriceHistory No errors.
App\Entity\Cart
  • The mappings App\Entity\Cart#addressCity and App\Entity\City#addresses are inconsistent with each other.
App\Entity\SMS No errors.
App\Entity\MobileVerifyCode No errors.
App\Entity\PushNotification No errors.
App\Entity\Ticket No errors.
App\Entity\Log No errors.
App\Entity\Payment No errors.
App\Entity\BankAccount No errors.
App\Entity\Receipt No errors.
App\Entity\Transaction No errors.
App\Entity\SupplyDrugstore No errors.
App\Entity\DrugstoreData No errors.
App\Entity\Province No errors.
App\Entity\DeliverType No errors.
App\Entity\Template No errors.
App\Entity\TicketType No errors.
App\Entity\Article No errors.
App\Entity\SettingApp No errors.
App\Entity\Brand No errors.
App\Entity\Advertise No errors.
App\Entity\Vitrin No errors.
App\Entity\Contact No errors.
Vich\UploaderBundle\Entity\File No errors.