https://test.uchideri.com/search

Query Metrics

45 Database Queries
7 Different statements
150.28 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 7.97 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM area t0 ORDER BY t0.position ASC
Parameters:
[]
2 5.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
3 43.95 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM shop s0_ LEFT JOIN location l1_ ON s0_.location_id = l1_.id WHERE s0_.public = 1 AND s0_.ready = 1
Parameters:
[]
4 6.71 ms
SELECT DISTINCT s0_.id AS id_0, (CASE WHEN (s0_.hour_from = s0_.hour_to) THEN RAND(20250426) + 10 ELSE CASE WHEN (s0_.hour_from < s0_.hour_to) THEN CASE WHEN ? >= s0_.hour_from AND ? <= s0_.hour_to THEN RAND(20250426) + 10 ELSE RAND(20250426) END ELSE CASE WHEN ? >= s0_.hour_from OR ? <= s0_.hour_to THEN RAND(20250426) + 10 ELSE RAND(20250426) END END END) AS sclr_1 FROM shop s0_ LEFT JOIN location l1_ ON s0_.location_id = l1_.id WHERE s0_.public = 1 AND s0_.ready = 1 ORDER BY sclr_1 DESC LIMIT 20
Parameters:
[
  "17:36:00"
  "17:36:00"
  "17:36:00"
  "17:36:00"
]
5 24.30 ms
SELECT s0_.id AS id_0, s0_.email AS email_1, s0_.roles AS roles_2, s0_.password AS password_3, s0_.name AS name_4, s0_.to_go AS to_go_5, s0_.delivery AS delivery_6, s0_.zipcode AS zipcode_7, s0_.address AS address_8, s0_.tel AS tel_9, s0_.notice AS notice_10, s0_.assignee AS assignee_11, s0_.public AS public_12, s0_.hour_from AS hour_from_13, s0_.hour_to AS hour_to_14, s0_.estimated_minutes AS estimated_minutes_15, s0_.reset_token AS reset_token_16, s0_.ready AS ready_17, s0_.paid_plan_next_billing_date AS paid_plan_next_billing_date_18, s0_.gmo_member_id AS gmo_member_id_19, s0_.image AS image_20, s0_.token_valid_after AS token_valid_after_21, s0_.app_estimated_minutes AS app_estimated_minutes_22, s0_.app_hour_from AS app_hour_from_23, s0_.app_hour_to AS app_hour_to_24, s0_.app_closed AS app_closed_25, s0_.rate AS rate_26, s0_.gmo_shop_id AS gmo_shop_id_27, s0_.gmo_shop_password AS gmo_shop_password_28, s0_.fcm_token AS fcm_token_29, s0_.law_name AS law_name_30, s0_.law_address AS law_address_31, s0_.law_representative_name AS law_representative_name_32, s0_.law_representative_name_kana AS law_representative_name_kana_33, s0_.law_url AS law_url_34, s0_.law_email AS law_email_35, s0_.law_tel AS law_tel_36, s0_.law_delivery_days_and_shipping_method AS law_delivery_days_and_shipping_method_37, s0_.law_payment_method AS law_payment_method_38, s0_.law_other_costs AS law_other_costs_39, s0_.law_return_policy AS law_return_policy_40, s0_.law_defective_product AS law_defective_product_41, s0_.law_user_delete AS law_user_delete_42, s0_.law_cancel AS law_cancel_43, s0_.bank_name AS bank_name_44, s0_.bank_code AS bank_code_45, s0_.bank_branch_name AS bank_branch_name_46, s0_.bank_branch_code AS bank_branch_code_47, s0_.bank_account_number AS bank_account_number_48, s0_.bank_account_type AS bank_account_type_49, s0_.bank_account_name AS bank_account_name_50, s0_.created_at AS created_at_51, s0_.updated_at AS updated_at_52, s0_.coordinate_latitude AS coordinate_latitude_53, s0_.coordinate_longitude AS coordinate_longitude_54, (CASE WHEN (s0_.hour_from = s0_.hour_to) THEN RAND(20250426) + 10 ELSE CASE WHEN (s0_.hour_from < s0_.hour_to) THEN CASE WHEN ? >= s0_.hour_from AND ? <= s0_.hour_to THEN RAND(20250426) + 10 ELSE RAND(20250426) END ELSE CASE WHEN ? >= s0_.hour_from OR ? <= s0_.hour_to THEN RAND(20250426) + 10 ELSE RAND(20250426) END END END) AS sclr_55, s0_.location_id AS location_id_56, s0_.shop_plan_id AS shop_plan_id_57 FROM shop s0_ LEFT JOIN location l1_ ON s0_.location_id = l1_.id WHERE s0_.public = 1 AND s0_.ready = 1 AND s0_.id IN (?) ORDER BY sclr_55 DESC
Parameters:
[
  "17:36:00"
  "17:36:00"
  "17:36:00"
  "17:36:00"
  [
    713
    306
    154
    619
    787
    491
    765
    642
    785
    315
    609
    840
    839
    772
    443
    663
    492
    823
    97
    710
  ]
]
6 7.01 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  787
]
7 5.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  787
]
8 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  772
]
9 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  772
]
10 2.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  765
]
11 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  765
]
12 2.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  492
]
13 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  492
]
14 4.90 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  609
]
15 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  609
]
16 3.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  97
]
17 1.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  97
]
18 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  785
]
19 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  785
]
20 1.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  840
]
21 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  840
]
22 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  839
]
23 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  839
]
24 2.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  619
]
25 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  619
]
26 2.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  710
]
27 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  710
]
28 2.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  823
]
29 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  823
]
30 3.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  306
]
31 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  306
]
32 2.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  491
]
33 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  491
]
34 2.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  443
]
35 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  443
]
36 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  642
]
37 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  642
]
38 2.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  154
]
39 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  154
]
40 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  315
]
41 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  315
]
42 1.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  663
]
43 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  663
]
44 1.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.minutes AS minutes_4, t0.price AS price_5, t0.image AS image_6, t0.position AS position_7, t0.discounted_price AS discounted_price_8, t0.app_stock AS app_stock_9, t0.shop_id AS shop_id_10, t0.group_id AS group_id_11 FROM menu t0 WHERE t0.shop_id = ?
Parameters:
[
  713
]
45 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.image AS image_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
  713
]

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\Area No errors.
App\Entity\Location No errors.
App\Entity\Category No errors.
App\Entity\Coordinate No errors.
App\Entity\Shop No errors.
App\Entity\ShopPlan No errors.
App\Entity\MenuGroup No errors.
App\Entity\Menu No errors.
App\Entity\ShopPlanContractHistory No errors.
App\Entity\PaymentMethod No errors.
App\Entity\Invoice
  • The association App\Entity\Invoice#shopSales refers to the owning side field App\Entity\ShopSales#invoice which does not exist.
App\Entity\Payment No errors.
App\Entity\Coupon No errors.
App\Entity\Cart No errors.
App\Entity\Order No errors.
App\Entity\ShopReview No errors.
App\Entity\ShopSales No errors.
App\Entity\CartItem No errors.
App\Entity\OrderMenu No errors.