0.0003 |
select `key`,`en` from `languages` ;
|
0.0003 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '0' ORDER BY `PositionOrder`
|
0.0002 |
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.0002 |
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-04-18' AND `start` <= '2024-04-18' ORDER BY `ID` ASC
|
0.0002 |
SELECT * FROM `rest_events` WHERE `end` >= '2024-04-18' ORDER BY `start` DESC LIMIT 10
|
0.0003 |
SELECT * FROM `restaurants` WHERE `ID` = '68'
|
0.0003 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '68'
|
0.0035 |
SELECT * FROM `food_items` WHERE `MenuID` = '2075'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2076'
|
0.0035 |
SELECT * FROM `food_items` WHERE `MenuID` = '2077'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2078'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2079'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2080'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2081'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2082'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2083'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2084'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2085'
|
0.0034 |
SELECT * FROM `food_items` WHERE `MenuID` = '2091'
|
0.0035 |
SELECT * FROM `food_items` WHERE `MenuID` IN('2075', '2076', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2084', '2085', '2091') ORDER BY `ImageID` DESC LIMIT 4
|
0.0003 |
SELECT * FROM `images` WHERE `RestID` = '68' AND `ID` != '2513' AND `Exsst` = 3 ORDER BY `Size` DESC LIMIT 3
|
0.0004 |
UPDATE `restaurants` SET `userview` = 6983 WHERE `ID` = '68' LIMIT 1
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '5'
|
0.0013 |
SELECT * FROM `rest_locations` WHERE `rest_id` = '68' ORDER BY `ID` ASC
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '5'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '5'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '19'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '19'
|
0.0016 |
SELECT * FROM `ratting` WHERE `RestID` = '68' AND `RateComment` = 'Food'
|
0.0015 |
SELECT * FROM `ratting` WHERE `RestID` = '68' AND `RateComment` = 'Service'
|
0.0015 |
SELECT * FROM `ratting` WHERE `RestID` = '68' AND `RateComment` = 'Ambiance'
|
0.0015 |
SELECT * FROM `ratting` WHERE `RestID` = '68' AND `RateComment` = 'Price'
|
0.0015 |
SELECT * FROM `ratting` WHERE `RestID` = '68'
|
0.0001 |
SELECT * FROM `locations` WHERE `ID` = '1'
|
0.0012 |
SELECT * FROM `rest_user_favorite` WHERE `rest_id` = '68'
|
0.0008 |
SELECT * FROM `rest_user_visited` WHERE `rest_id` = '68'
|
0.0007 |
SELECT * FROM `rest_user_wishtogo` WHERE `rest_id` = '68'
|
0.0002 |
SELECT * FROM `images` WHERE `RestID` = '68' AND `for` = 'rest' ORDER BY `Size` DESC
|
0.0002 |
SELECT * FROM `restaurants` WHERE `ID` = '68'
|
0.0003 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '1690' AND `CommentType` = 'image' AND `Status` = '1' GROUP BY `RestID`
|
0.0002 |
SELECT * FROM `restaurants` WHERE `ID` = '68'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '1691' AND `CommentType` = 'image' AND `Status` = '1' GROUP BY `RestID`
|
0.0002 |
SELECT * FROM `restaurants` WHERE `ID` = '68'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '1689' AND `CommentType` = 'image' AND `Status` = '1' GROUP BY `RestID`
|
0.0002 |
SELECT * FROM `restaurants` WHERE `ID` = '68'
|
0.0002 |
SELECT *, COUNT( * ) AS count, GROUP_CONCAT( `Comment` SEPARATOR '<br/>' ) AS UComments FROM `users_comment` WHERE `RestID` = '1692' AND `CommentType` = 'image' AND `Status` = '1' GROUP BY `RestID`
|
0.0002 |
SELECT * FROM `images` WHERE `ID` = '2513'
|
0.0005 |
UPDATE `restaurants` SET `Logo` = '99c01bf8c831abcdf8384e742391c979.jpg' WHERE `ID` = '68' LIMIT 1
|
0.0001 |
SELECT * FROM `images` WHERE `ID` = '2513'
|
0.0003 |
UPDATE `restaurants` SET `Logo` = '99c01bf8c831abcdf8384e742391c979.jpg' WHERE `ID` = '68' LIMIT 1
|
0.0001 |
SELECT * FROM `features`
|
0.0014 |
SELECT DISTINCT `FeatureID` FROM `rest_features` WHERE `RestID` = '68'
|