Query Metrics
3
Database Queries
3
Different statements
33.87 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.60 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.id = ?
Parameters:
[
"760"
]
|
| 2 | 29.42 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.to_go AS to_go_6, t0.delivery AS delivery_7, t0.zipcode AS zipcode_8, t0.address AS address_9, t0.tel AS tel_10, t0.notice AS notice_11, t0.assignee AS assignee_12, t0.public AS public_13, t0.hour_from AS hour_from_14, t0.hour_to AS hour_to_15, t0.estimated_minutes AS estimated_minutes_16, t0.reset_token AS reset_token_17, t0.ready AS ready_18, t0.paid_plan_next_billing_date AS paid_plan_next_billing_date_19, t0.gmo_member_id AS gmo_member_id_20, t0.image AS image_21, t0.token_valid_after AS token_valid_after_22, t0.app_estimated_minutes AS app_estimated_minutes_23, t0.app_hour_from AS app_hour_from_24, t0.app_hour_to AS app_hour_to_25, t0.app_closed AS app_closed_26, t0.rate AS rate_27, t0.gmo_shop_id AS gmo_shop_id_28, t0.gmo_shop_password AS gmo_shop_password_29, t0.fcm_token AS fcm_token_30, t0.law_name AS law_name_31, t0.law_address AS law_address_32, t0.law_representative_name AS law_representative_name_33, t0.law_representative_name_kana AS law_representative_name_kana_34, t0.law_url AS law_url_35, t0.law_email AS law_email_36, t0.law_tel AS law_tel_37, t0.law_delivery_days_and_shipping_method AS law_delivery_days_and_shipping_method_38, t0.law_payment_method AS law_payment_method_39, t0.law_other_costs AS law_other_costs_40, t0.law_return_policy AS law_return_policy_41, t0.law_defective_product AS law_defective_product_42, t0.law_user_delete AS law_user_delete_43, t0.law_cancel AS law_cancel_44, t0.bank_name AS bank_name_45, t0.bank_code AS bank_code_46, t0.bank_branch_name AS bank_branch_name_47, t0.bank_branch_code AS bank_branch_code_48, t0.bank_account_number AS bank_account_number_49, t0.bank_account_type AS bank_account_type_50, t0.bank_account_name AS bank_account_name_51, t0.created_at AS created_at_52, t0.updated_at AS updated_at_53, t0.coordinate_latitude AS coordinate_latitude_54, t0.coordinate_longitude AS coordinate_longitude_55, t0.location_id AS location_id_56, t0.shop_plan_id AS shop_plan_id_57 FROM shop t0 WHERE t0.id = ?
Parameters:
[
144
]
|
| 3 | 1.85 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.paid_plan_monthly_fee AS paid_plan_monthly_fee_4, t0.position AS position_5 FROM shop_plan t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Menu | No errors. |
| App\Entity\Coordinate | No errors. |
| App\Entity\Shop | No errors. |
| App\Entity\MenuGroup | No errors. |
| App\Entity\CartItem | No errors. |
| App\Entity\OrderMenu | No errors. |
| App\Entity\Location | No errors. |
| App\Entity\ShopPlan | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\ShopPlanContractHistory | No errors. |
| App\Entity\PaymentMethod | No errors. |
| App\Entity\Invoice |
|
| 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. |