GET https://www.daroox.com/

Query Metrics

25 Database Queries
8 Different statements
13.11 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
  1
]
2 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
  4
]
3 0.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
  2
]
4 0.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
  3
]
5 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.link AS link_4, t0.updated_at AS updated_at_5, t0.date_insert AS date_insert_6, t0.`order` AS order_7 FROM brand t0 ORDER BY t0.`order` ASC
Parameters:
[]
6 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.ordering AS ordering_4 FROM shop_special t0 WHERE t0.visible = ? ORDER BY t0.ordering ASC
Parameters:
[
  1
]
7 0.38 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 2.86 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.43 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.79 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.42 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 1.08 ms
SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fa AS name_fa_3, t0.brand_en AS brand_en_4, t0.brand_fa AS brand_fa_5, t0.name_brand_en AS name_brand_en_6, t0.name_brand_fa AS name_brand_fa_7, t0.erx_code AS erx_code_8, t0.erx_code_base AS erx_code_base_9, t0.rx_behdasht AS rx_behdasht_10, t0.generic_code AS generic_code_11, t0.mother_code AS mother_code_12, t0.licence_owner AS licence_owner_13, t0.brand_owner AS brand_owner_14, t0.brand_owner_country AS brand_owner_country_15, t0.producer AS producer_16, t0.producer_country AS producer_country_17, t0.name_interactive AS name_interactive_18, t0.packing AS packing_19, t0.form AS form_20, t0.pregnancy_category AS pregnancy_category_21, t0.other AS other_22, t0.features AS features_23, t0.video_id AS video_id_24, t0.last_price AS last_price_25, t0.only_doctor_user AS only_doctor_user_26, t0.status AS status_27, t0.license_owner_id AS license_owner_id_28 FROM item t0 INNER JOIN item_shop_specials ON t0.id = item_shop_specials.item_id WHERE item_shop_specials.shop_special_id = ?
Parameters:
[
  7
]
13 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:
[
  321083
]
14 0.24 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:
[
  321469
]
15 0.29 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:
[
  325041
]
16 0.27 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:
[
  325043
]
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:
[
  325053
]
18 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:
[
  575331
]
19 0.17 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:
[
  575483
]
20 0.17 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:
[
  575490
]
21 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:
[
  575507
]
22 0.29 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
]
23 0.23 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
]
24 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:
[
  3
]
25 0.21 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\Advertise No errors.
App\Entity\Brand No errors.
App\Entity\ShopSpecial No errors.
App\Entity\Item No errors.
App\Entity\Setting No errors.
App\Entity\Category No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User 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\LicenseOwner No errors.
App\Entity\ItemBarcode No errors.
App\Entity\ItemIRC No errors.
App\Entity\ItemMedia No errors.
App\Entity\ItemPriceHistory No errors.
App\Entity\ItemDrugstore No errors.
App\Entity\ItemUser No errors.
App\Entity\CartItem No errors.
App\Entity\SMS No errors.
App\Entity\Address No errors.
App\Entity\Cart
  • The mappings App\Entity\Cart#addressCity and App\Entity\City#addresses are inconsistent with each other.
App\Entity\MobileVerifyCode No errors.
App\Entity\City
  • The mappings App\Entity\City#carts and App\Entity\Cart#addressCity are inconsistent with each other.
App\Entity\DrugstoreType 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\ItemDrugstorePriceHistory No errors.
App\Entity\DeliverType No errors.
App\Entity\Province No errors.
App\Entity\DrugstoreData No errors.
App\Entity\Template No errors.
App\Entity\TicketType No errors.
App\Entity\Article No errors.
App\Entity\SettingApp No errors.
App\Entity\Vitrin No errors.
App\Entity\Contact No errors.
Vich\UploaderBundle\Entity\File No errors.