0.0003 |
select `key`,`en` from `languages` ;
|
0.0003 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '0' ORDER BY `PositionOrder`
|
0.0001 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '8' ORDER BY `PositionOrder`
|
0.0003 |
SELECT * FROM `categories` WHERE `CategoryID` =0 AND `ID` !=0 ORDER BY `Order`
|
0.0001 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '14' ORDER BY `PositionOrder`
|
0.0001 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '27' ORDER BY `PositionOrder`
|
0.0001 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '28' ORDER BY `PositionOrder`
|
0.0001 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '4' ORDER BY `PositionOrder`
|
0.0001 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '22' ORDER BY `PositionOrder`
|
0.0001 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '17' ORDER BY `PositionOrder`
|
0.0002 |
SELECT * FROM `categories` WHERE `CategoryID` = '0' AND `ID` >0 ORDER BY `ID` ASC
|
0.0002 |
SELECT * FROM `categories` WHERE `CategoryID` = '-1' AND `ID` >0 ORDER BY `ID` ASC
|
0.0002 |
SELECT * FROM `locations` ORDER BY `id`
|
0.0002 |
SELECT * FROM `adds_type` WHERE (`Name_en` like '%rest%' ) ORDER BY `ID` ASC
|
0.0002 |
SELECT * FROM `adds` WHERE `RestID` =0 AND `type` IN('3') AND `end` >= '2024-03-29' AND `start` <= '2024-03-29' ORDER BY `ID` ASC
|
0.0003 |
SELECT * FROM `restaurants` WHERE `ID` = '50'
|
0.0002 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '50'
|
0.0046 |
SELECT * FROM `food_items` WHERE `MenuID` = '1884'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1885'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1886'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1887'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1888'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1889'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1890'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1891'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1892'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1893'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1894'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1895'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` IN('1884', '1885', '1886', '1887', '1888', '1889', '1890', '1891', '1892', '1893', '1894', '1895') ORDER BY `ImageID` DESC LIMIT 7
|
0.0003 |
SELECT * FROM `images` WHERE `RestID` = '50' AND `ID` != '3918' AND `Exsst` = 3 ORDER BY `Size` DESC LIMIT 3
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '3'
|
0.0003 |
SELECT * FROM `rest_locations` WHERE `rest_id` = '50' ORDER BY `ID` ASC
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '3'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '3'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '19'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '19'
|
0.0016 |
SELECT * FROM `ratting` WHERE `RestID` = '50' AND `RateComment` = 'Food'
|
0.0015 |
SELECT * FROM `ratting` WHERE `RestID` = '50' AND `RateComment` = 'Service'
|
0.0015 |
SELECT * FROM `ratting` WHERE `RestID` = '50' AND `RateComment` = 'Ambiance'
|
0.0015 |
SELECT * FROM `ratting` WHERE `RestID` = '50' AND `RateComment` = 'Price'
|
0.0014 |
SELECT * FROM `ratting` WHERE `RestID` = '50'
|
0.0001 |
SELECT * FROM `locations` WHERE `ID` = '3'
|
0.0007 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '50'
|
0.0004 |
SELECT * FROM `rest_user_visited` WHERE `rest_id` = '50'
|
0.0004 |
SELECT * FROM `rest_user_wishtogo` WHERE `rest_id` = '50'
|
0.0002 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '50'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1884'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1885'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1886'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1887'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1888'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1889'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1890'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1891'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1892'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1893'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1894'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1895'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1884'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1885'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1886'
|
0.0036 |
SELECT * FROM `food_items` WHERE `MenuID` = '1887'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1888'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1889'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1890'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1891'
|
0.0038 |
SELECT * FROM `food_items` WHERE `MenuID` = '1892'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1893'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '1894'
|
0.0033 |
SELECT * FROM `food_items` WHERE `MenuID` = '1895'
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3439'
|
0.0001 |
SELECT * FROM `restaurant_menues` WHERE `ID` = '1885'
|
0.0002 |
SELECT * FROM `restaurants` WHERE `ID` = '50'
|
0.0023 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2538'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2538'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2538'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2538'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2538'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2538'
|
0.0006 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '50'
|
0.0003 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '2538' AND `CommentType` = 'menu' AND `Status` = '1' GROUP BY `RestID`
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3440'
|
0.0001 |
SELECT * FROM `restaurant_menues` WHERE `ID` = '1885'
|
0.0002 |
SELECT * FROM `restaurants` WHERE `ID` = '50'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2539'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2539'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2539'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2539'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2539'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2539'
|
0.0007 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '50'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '2539' AND `CommentType` = 'menu' AND `Status` = '1' GROUP BY `RestID`
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3441'
|
0.0001 |
SELECT * FROM `restaurant_menues` WHERE `ID` = '1885'
|
0.0001 |
SELECT * FROM `restaurants` WHERE `ID` = '50'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2540'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2540'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2540'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2540'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2540'
|
0.0016 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2540'
|
0.0006 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '50'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '2540' AND `CommentType` = 'menu' AND `Status` = '1' GROUP BY `RestID`
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3442'
|
0.0001 |
SELECT * FROM `restaurant_menues` WHERE `ID` = '1885'
|
0.0001 |
SELECT * FROM `restaurants` WHERE `ID` = '50'
|
0.0016 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2541'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2541'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2541'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2541'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2541'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2541'
|
0.0007 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '50'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '2541' AND `CommentType` = 'menu' AND `Status` = '1' GROUP BY `RestID`
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3443'
|
0.0001 |
SELECT * FROM `restaurant_menues` WHERE `ID` = '1885'
|
0.0001 |
SELECT * FROM `restaurants` WHERE `ID` = '50'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2542'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2542'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2542'
|
0.0016 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2542'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2542'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2542'
|
0.0006 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '50'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '2542' AND `CommentType` = 'menu' AND `Status` = '1' GROUP BY `RestID`
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3444'
|
0.0001 |
SELECT * FROM `restaurant_menues` WHERE `ID` = '1885'
|
0.0002 |
SELECT * FROM `restaurants` WHERE `ID` = '50'
|
0.0016 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2543'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2543'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2543'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2543'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2543'
|
0.0015 |
SELECT * FROM `item_user_like` WHERE `item_type` = 'fooditem' AND `oparation` = 'rate' AND `item_id` = '2543'
|
0.0006 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '50'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '2543' AND `CommentType` = 'menu' AND `Status` = '1' GROUP BY `RestID`
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3918'
|
0.0007 |
UPDATE `restaurants` SET `Logo` = '0d106fcfb6f2c7e140a1335dc2b03afa.jpg' WHERE `ID` = '50' LIMIT 1
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '3918'
|
0.0003 |
UPDATE `restaurants` SET `Logo` = '0d106fcfb6f2c7e140a1335dc2b03afa.jpg' WHERE `ID` = '50' LIMIT 1
|
0.0002 |
SELECT * FROM `features`
|
0.0010 |
SELECT DISTINCT `FeatureID` FROM `rest_features` WHERE `RestID` = '50'
|