http://194-91-03-031.cprapid.com/restaurant-search/?genre%5B%5D=japanese_food

Method
GET
HTTP Status
500
IP
43.165.190.5
Profiled on
Sun, 12 Apr 2026 00:29:46 +0900
Token
bbd302

Query Metrics

15 Database Queries
13 Different statements
37.27 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
7.70 ms
(20.66%) 		2 
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-12 00:29:46") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2026-04-12 00:29:46") AND (t50.expires_at IS NULL OR t50.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")))
Parameters: 
[
  [
    405
    406
    409
    410
    413
    414
  ]
]
View formatted query    View runnable query    Explain query
4.92 ms
(13.21%) 		2 
SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")))
Parameters: 
[
  [
    1
  ]
]
View formatted query    View runnable query    Explain query
3.08 ms
(8.26%) 		1 
SELECT c0_.this_month_recommendation AS this_month_recommendation_0, c0_.title_kana AS title_kana_1, c0_.business_hours AS business_hours_2, c0_.business_hours_supplement AS business_hours_supplement_3, c0_.holiday AS holiday_4, c0_.holiday_supplement AS holiday_supplement_5, c0_.description AS description_6, c0_.map_url AS map_url_7, c0_.route AS route_8, c0_.tabelog_reserve AS tabelog_reserve_9, c0_.hotpepper_reserve AS hotpepper_reserve_10, c0_.ikyu_reserve AS ikyu_reserve_11, c0_.contact_etc AS contact_etc_12, c0_.tel AS tel_13, c0_.information AS information_14, c0_.budget AS budget_15, c0_.address AS address_16, c0_.access AS access_17, c0_.parking AS parking_18, c0_.seats AS seats_19, c0_.private_room AS private_room_20, c0_.payment AS payment_21, c0_.site_url_1 AS site_url_1_22, c0_.site_url_2 AS site_url_2_23, c0_.site_url_3 AS site_url_3_24, c0_.map_iframe AS map_iframe_25, c0_.public_date AS public_date_26, c0_.customblock AS customblock_27, c0_.id AS id_28, c0_.sort_num AS sort_num_29, c0_.status AS status_30, c0_.publish_at AS publish_at_31, c0_.expires_at AS expires_at_32, c0_.created_at AS created_at_33, c0_.updated_at AS updated_at_34, c0_.title AS title_35, c0_.language_parent AS language_parent_36, c0_.language_alias AS language_alias_37, c0_.language_active AS language_active_38, c0_.revision_parent AS revision_parent_39, c0_.revision_version AS revision_version_40, c0_.post_type AS post_type_41, c0_.access_token AS access_token_42, c0_.main_image AS main_image_43, c0_.time_by_car_id AS time_by_car_id_44, c0_.thumbnail AS thumbnail_45, c0_.facility_id AS facility_id_46, c0_.created_by AS created_by_47, c0_.updated_by AS updated_by_48, c0_.language_id AS language_id_49, c0_.latest_approval_request_id AS latest_approval_request_id_50 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 00:29:46") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ? AND c0_.id IN (?)) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.this_month_recommendation DESC
Parameters: 
[
  1
  "japanese_food"
  [
    29
    45
    30
    46
    31
    77
    32
    78
    33
    79
  ]
]
View formatted query    View runnable query    Explain query
2.80 ms
(7.51%) 		1 
SELECT DISTINCT c0_.id AS id_0, c0_.sort_num AS sort_num_1, c0_.this_month_recommendation AS this_month_recommendation_2 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 00:29:46") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.this_month_recommendation DESC LIMIT 10
Parameters: 
[
  1
  "japanese_food"
]
View formatted query    View runnable query    Explain query
2.71 ms
(7.28%) 		1 
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 00:29:46") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12"))
Parameters: 
[
  1
  "japanese_food"
]
View formatted query    View runnable query    Explain query
2.30 ms
(6.16%) 		1 
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.display_name AS display_name_9, t0.sort_num AS sort_num_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.salt AS salt_13, t0.password AS password_14, t0.group_id AS group_id_15, t16.id AS id_17, t16.is_wheel AS is_wheel_18, t16.is_system_admin AS is_system_admin_19, t16.level AS level_20, t16.name AS name_21, t16.display_name AS display_name_22, t16.description AS description_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t0.facility_id AS facility_id_26, t27.code AS code_28, t27.title AS title_29, t27.intro_text AS intro_text_30, t27.zip AS zip_31, t27.address AS address_32, t27.building AS building_33, t27.google_maps_url AS google_maps_url_34, t27.phone AS phone_35, t27.website AS website_36, t27.opening_hours AS opening_hours_37, t27.holiday AS holiday_38, t27.access AS access_39, t27.access_car AS access_car_40, t27.access_train AS access_train_41, t27.id AS id_42, t27.sort_num AS sort_num_43, t27.status AS status_44, t27.publish_at AS publish_at_45, t27.expires_at AS expires_at_46, t27.created_at AS created_at_47, t27.updated_at AS updated_at_48, t27.area_id AS area_id_49, t27.prefecture_id AS prefecture_id_50, t27.logo_image AS logo_image_51, t27.main_image AS main_image_52, t27.created_by AS created_by_53, t27.updated_by AS updated_by_54 FROM cms_user t0 LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id AND ((t27.status = 1 AND (t27.publish_at IS NULL OR t27.publish_at <= "2026-04-12 00:29:46") AND (t27.expires_at IS NULL OR t27.expires_at > "2026-04-12 00:29:46"))) WHERE t0.id IN (?)
Parameters: 
[
  [
    1
  ]
]
View formatted query    View runnable query    Explain query
2.22 ms
(5.94%) 		1 
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.03 ms
(5.46%) 		1 
SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.00 ms
(5.36%) 		1 
SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_1, c0_.id AS id_2, c0_.sort_num AS sort_num_3, c0_.status AS status_4, c0_.publish_at AS publish_at_5, c0_.expires_at AS expires_at_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.title AS title_9, c0_.language_parent AS language_parent_10, c0_.language_alias AS language_alias_11, c0_.language_active AS language_active_12, c0_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.00 ms
(5.36%) 		1 
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[
  "japanese_food"
]
View formatted query    View runnable query    Explain query
1.86 ms
(4.99%) 		1 
SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_banner c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.84 ms
(4.93%) 		1 
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.81 ms
(4.86%) 		1 
SELECT t0.id AS id_1, t0.is_wheel AS is_wheel_2, t0.is_system_admin AS is_system_admin_3, t0.level AS level_4, t0.name AS name_5, t0.display_name AS display_name_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_user_groups t0 WHERE t0.id IN (?)
Parameters: 
[
  [
    1
  ]
]
View formatted query    View runnable query    Explain query

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
AppBundle\Entity\Base\Base No errors.
Mod\RestaurantBundle\Entity\Genre No errors.
AppBundle\Entity\Media\ItemDetail No errors.
AppBundle\Entity\Master\Facility No errors.
FOS\UserBundle\Model\User No errors.
AppBundle\Entity\User No errors.
AppBundle\Entity\Master\Language No errors.
AppBundle\Entity\Approval\ApprovalRequest No errors.
Mod\RestaurantBundle\Entity\Restaurant No errors.
Mod\TopBundle\Entity\GourmetPickup No errors.
AppBundle\Entity\Media\Item No errors.
AppBundle\Entity\Media\Category No errors.
AppBundle\Entity\Media\Group No errors.
AppBundle\Entity\Master\UserGroup No errors.
AppBundle\Entity\Media\Tag No errors.
AppBundle\Entity\Media\Usage No errors.
AppBundle\Entity\Master\Area No errors.
AppBundle\Entity\Master\Prefecture No errors.
AppBundle\Entity\Master\UserPrivilege No errors.
Mod\RestaurantBundle\Entity\TimeByCar No errors.
Mod\RestaurantBundle\Entity\Scene No errors.
Mod\RestaurantBundle\Entity\Feature No errors.
Mod\RestaurantBundle\Entity\Banner No errors.