Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

90.80 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	90.80 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.public = ? AND t0.ready = ? Parameters: [`1 1`] View formatted query View runnable query Explain query 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.public = ? AND t0.ready = ? 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.public = 1 AND t0.ready = 1;

#▲

Time

Info

90.80 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.public = ? AND t0.ready = ?

Parameters:

View formatted query View runnable query Explain query

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.public = ?
  AND t0.ready = ?

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.public = 1 AND t0.ready = 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\Coordinate	No errors.
App\Entity\Shop	No errors.
App\Entity\Location	No errors.
App\Entity\ShopPlan	No errors.
App\Entity\Category	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.

Symfony Profiler

https://test.uchideri.com/map

Configuration Settings

Theme