Warning (2): Invalid argument supplied for foreach() [APP/Model/Menu.php, line 249]
Warning (2): Invalid argument supplied for foreach() [APP/Model/Menu.php, line 256]
iMeal - 好市围烧腊BBQ AT WORK - 外卖 订餐 送餐
(default) 10 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Store`.`url_name` FROM `imealcom_prod`.`stores` AS `Store` WHERE `Store`.`id` = 192 LIMIT 1110
2SELECT `Store`.`id`, `Store`.`url_name`, `Store`.`name`, `Store`.`logo_ext`, `Store`.`street_number_located`, `Store`.`street_located`, `Suburb`.`id`, `Suburb`.`name`, `Suburb`.`postcode`, `Store`.`is_hot`, `Store`.`is_featured`, `Store`.`open_sunday_time`, `Store`.`open_monday_time`, `Store`.`open_tuesday_time`, `Store`.`open_wednesday_time`, `Store`.`open_thursday_time`, `Store`.`open_friday_time`, `Store`.`open_saturday_time`, `Store`.`pickup_offline`, `Store`.`pickup_sunday_time`, `Store`.`pickup_monday_time`, `Store`.`pickup_tuesday_time`, `Store`.`pickup_wednesday_time`, `Store`.`pickup_thursday_time`, `Store`.`pickup_friday_time`, `Store`.`pickup_saturday_time`, `Store`.`delivery_self_service`, `Store`.`min_charge`, `Store`.`description` FROM `imealcom_prod`.`stores` AS `Store` INNER JOIN `imealcom_prod`.`suburbs` AS `Suburb` ON (`Store`.`suburb_id` = `Suburb`.`id`) WHERE `Store`.`id` = 192 AND `Store`.`is_active` = '1' AND `Suburb`.`is_active` = '1' LIMIT 1110
3SELECT `StoreType`.`id`, `StoreType`.`name` FROM `imealcom_prod`.`store_types` AS `StoreType` INNER JOIN `imealcom_prod`.`stores_store_types` AS `StoreStoreType` ON (`StoreStoreType`.`store_type_id` = `StoreType`.`id`) WHERE `StoreStoreType`.`store_id` = 192110
4SELECT `Suburb`.*, `StoresSuburb`.*, (CONCAT(LCASE(`Suburb`.`name`), ' - ', `Suburb`.`postcode`)) AS `Suburb__display_name` FROM `imealcom_prod`.`suburbs` AS `Suburb` LEFT JOIN `imealcom_prod`.`stores_suburbs` AS `StoresSuburb` ON (`StoresSuburb`.`suburb_id` = `Suburb`.`id`) INNER JOIN `imealcom_prod`.`delivery_areas` AS `DeliveryArea` ON (`DeliveryArea`.`id` = `Suburb`.`delivery_area_id` AND `DeliveryArea`.`is_open` = '1') WHERE `StoresSuburb`.`store_id` = 192 ORDER BY `Suburb`.`name` ASC001
5SELECT `PaymentMethod`.`id`, `PaymentMethod`.`name` FROM `imealcom_prod`.`payment_methods` AS `PaymentMethod` INNER JOIN `imealcom_prod`.`stores_payment_methods` AS `StorePaymentMethod` ON (`StorePaymentMethod`.`payment_method_id` = `PaymentMethod`.`id` AND `StorePaymentMethod`.`store_id` = 192) WHERE 1 = 1000
6SELECT `StoreMenuCategory`.`id`, `StoreMenuCategory`.`name` FROM `imealcom_prod`.`store_menu_categories` AS `StoreMenuCategory` WHERE `store_id` = 192 AND `is_active` = '1' ORDER BY `category_order` ASC, `name` ASC550
7SELECT `StoreSpecial`.`id`, `StoreSpecial`.`store_id`, `StoreSpecial`.`promotion_code`, `StoreSpecial`.`type`, `StoreSpecial`.`rule`, `StoreSpecial`.`x`, `StoreSpecial`.`y`, `StoreSpecial`.`created`, `StoreSpecial`.`modified`, `StoreSpecial`.`z` FROM `imealcom_prod`.`store_specials` AS `StoreSpecial` WHERE `StoreSpecial`.`promotion_code` IS NULL AND `StoreSpecial`.`store_id` = 192000
8SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`price`, `Menu`.`store_menu_category_id` AS `category_id`, `Menu`.`is_featured`, `Menu`.`description`, `Menu`.`image_ext` FROM `imealcom_prod`.`menus` AS `Menu` WHERE `Menu`.`store_id` = 192 AND `Menu`.`is_active` = '1' ORDER BY `Menu`.`store_menu_category_id` ASC, `Menu`.`menu_order` ASC, `Menu`.`name` ASC34340
9SELECT `MenuChoice`.`id`, `MenuChoice`.`menu_id`, `MenuChoice`.`choice_name` AS `name`, `MenuChoice`.`max_choices` AS `choice_max`, `MenuChoice`.`min_choices` AS `choice_min` FROM `imealcom_prod`.`menus` AS `Menu` INNER JOIN `imealcom_prod`.`menu_choices` AS `MenuChoice` ON (`Menu`.`id` = `MenuChoice`.`menu_id`) WHERE `Menu`.`store_id` = 192 AND `Menu`.`is_active` = '1' ORDER BY `Menu`.`store_menu_category_id` ASC, `Menu`.`menu_order` ASC, `Menu`.`name` ASC, `MenuChoice`.`choice_order` ASC, `MenuChoice`.`choice_name` ASC, `MenuChoice`.`id` ASC000
10SELECT `MenuChoiceItem`.`id`, `MenuChoiceItem`.`menu_choice_id`, `MenuChoiceItem`.`choice_value` AS `name`, `MenuChoiceItem`.`additional_price` AS `add_price` FROM `imealcom_prod`.`menus` AS `Menu` INNER JOIN `imealcom_prod`.`menu_choices` AS `MenuChoice` ON (`Menu`.`id` = `MenuChoice`.`menu_id`) INNER JOIN `imealcom_prod`.`menu_choice_items` AS `MenuChoiceItem` ON (`MenuChoice`.`id` = `MenuChoiceItem`.`menu_choice_id`) WHERE `Menu`.`store_id` = 192 AND `Menu`.`is_active` = '1' ORDER BY `Menu`.`store_menu_category_id` ASC, `Menu`.`menu_order` ASC, `Menu`.`name` ASC, `MenuChoice`.`choice_order` ASC, `MenuChoice`.`choice_name` ASC, `MenuChoice`.`id` ASC, `MenuChoiceItem`.`item_order` ASC, `MenuChoiceItem`.`choice_value` ASC000