| 0.0005 |
select `key`,`en` from `languages` ;
|
| 0.0006 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '0'
ORDER BY `PositionOrder`
|
| 0.0005 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '8'
ORDER BY `PositionOrder`
|
| 0.0006 |
SELECT *
FROM `categories`
WHERE `CategoryID` =0
AND `ID` !=0
ORDER BY `Order`
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '14'
ORDER BY `PositionOrder`
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '27'
ORDER BY `PositionOrder`
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '28'
ORDER BY `PositionOrder`
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '4'
ORDER BY `PositionOrder`
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '22'
ORDER BY `PositionOrder`
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `Position` = 'site'
AND `FatherID` = '17'
ORDER BY `PositionOrder`
|
| 0.0004 |
SELECT *
FROM `categories`
WHERE `CategoryID` = '0'
AND `ID` >0
ORDER BY `ID` ASC
|
| 0.0005 |
SELECT *
FROM `categories`
WHERE `CategoryID` = '-1'
AND `ID` >0
ORDER BY `ID` ASC
|
| 0.0005 |
SELECT *
FROM `locations`
ORDER BY `id`
|
| 0.0005 |
SELECT *
FROM `categories`
WHERE `CategoryID` = '0'
AND `ID` >0
ORDER BY `ID` ASC
|
| 0.0153 |
SELECT *
FROM `images`
WHERE `RestID` >0
AND `logo` =0
AND `Exsst` = 4
GROUP BY `RestID`
ORDER BY `Size` DESC
LIMIT 4
|
| 0.0004 |
SELECT *
FROM `categories`
WHERE `ID` >0
AND `CategoryID` =0
ORDER BY `ID` ASC
|
| 0.0004 |
SELECT *
FROM `categories`
WHERE `ID` >0
AND `CategoryID` = -1
ORDER BY `ID` ASC
|
| 0.0005 |
SELECT *
FROM `locations`
WHERE `ID` >0
ORDER BY `ID` ASC
|
| 0.0004 |
SELECT *
FROM `features`
WHERE `ID` >0
ORDER BY `ID` ASC
|
| 0.0003 |
SELECT *
FROM `locations`
WHERE `slug` = 'jabal-al-hussein'
|
| 0.0002 |
SELECT *
FROM `locations`
WHERE `ID` = '7'
|
| 0.0006 |
SELECT DISTINCT `rest_id`
FROM `rest_locations`
WHERE `loc_id` IN('7')
|
| 0.0074 |
SELECT *
FROM `restaurants`
WHERE `status` = 1
AND `ID` IN(0, '122', '123', '124', '93', '334', '462', '385', '727', '879', '841', '516', '453')
ORDER BY `ID` ASC
LIMIT 12
|
| 0.0015 |
SELECT COUNT(*) AS `numrows`
FROM `restaurants`
WHERE `status` = 1
AND `ID` IN(0, '122', '123', '124', '93', '334', '462', '385', '727', '879', '841', '516', '453')
ORDER BY `ID` ASC
|
| 0.0004 |
SELECT *
FROM `categories`
WHERE `ID` = '48'
|
| 0.0038 |
SELECT *
FROM `ratting`
WHERE `RestID` = '93'
|
| 0.0033 |
SELECT *
FROM `ratting`
WHERE `RestID` = '93'
|
| 0.0033 |
SELECT *
FROM `ratting`
WHERE `RestID` = '93'
|
| 0.0031 |
SELECT *
FROM `ratting`
WHERE `RestID` = '93'
|
| 0.0031 |
SELECT *
FROM `ratting`
WHERE `RestID` = '93'
|
| 0.0031 |
SELECT *
FROM `ratting`
WHERE `RestID` = '93'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '93'
AND `ID` != '3587'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '48'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '19'
|
| 0.0005 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '93'
|
| 0.0005 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '93'
|
| 0.0097 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2436'
|
| 0.0088 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2437'
|
| 0.0084 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2438'
|
| 0.0079 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2439'
|
| 0.0076 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2440'
|
| 0.0073 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2441'
|
| 0.0070 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2442'
|
| 0.0068 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2443'
|
| 0.0066 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2444'
|
| 0.0066 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2445'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2446'
|
| 0.0069 |
SELECT *
FROM `food_items`
WHERE `MenuID` IN('2436', '2437', '2438', '2439', '2440', '2441', '2442', '2443', '2444', '2445', '2446')
ORDER BY `ID` ASC
|
| 0.0003 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '93'
|
| 0.0013 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '93'
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '58'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '122'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '122'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '122'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '122'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '122'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '122'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '122'
AND `ID` != '235'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '58'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '19'
|
| 0.0003 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '122'
|
| 0.0003 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '122'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2584'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2585'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2586'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2587'
|
| 0.0064 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2588'
|
| 0.0064 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2589'
|
| 0.0064 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2590'
|
| 0.0064 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2591'
|
| 0.0067 |
SELECT *
FROM `food_items`
WHERE `MenuID` IN('2584', '2585', '2586', '2587', '2588', '2589', '2590', '2591')
ORDER BY `ID` ASC
|
| 0.0003 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '122'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '122'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '58'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '123'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '123'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '123'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '123'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '123'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '123'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '123'
AND `ID` != '236'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '58'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '13'
|
| 0.0003 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '123'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '123'
|
| 0.0066 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2592'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2593'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2594'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2595'
|
| 0.0067 |
SELECT *
FROM `food_items`
WHERE `MenuID` IN('2592', '2593', '2594', '2595')
ORDER BY `ID` ASC
|
| 0.0003 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '123'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '123'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '58'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '124'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '124'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '124'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '124'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '124'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '124'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '124'
AND `ID` != '748'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '58'
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '54'
|
| 0.0004 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '124'
|
| 0.0003 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '124'
|
| 0.0066 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2596'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2597'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2598'
|
| 0.0066 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2599'
|
| 0.0068 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2600'
|
| 0.0064 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2601'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2602'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2603'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2604'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2605'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2606'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2607'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2608'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2609'
|
| 0.0065 |
SELECT *
FROM `food_items`
WHERE `MenuID` = '2610'
|
| 0.0070 |
SELECT *
FROM `food_items`
WHERE `MenuID` IN('2596', '2597', '2598', '2599', '2600', '2601', '2602', '2603', '2604', '2605', '2606', '2607', '2608', '2609', '2610')
ORDER BY `ID` ASC
|
| 0.0004 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '124'
|
| 0.0013 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '124'
|
| 0.0004 |
SELECT *
FROM `categories`
WHERE `ID` = '3'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '385'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '385'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '385'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '385'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '385'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '385'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '385'
AND `ID` != '6514'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '3'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '13'
|
| 0.0003 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '385'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '385'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '385'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '385'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '53'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '462'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '462'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '462'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '462'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '462'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '462'
|
| 0.0003 |
SELECT *
FROM `images`
WHERE `RestID` = '462'
AND `ID` != '7126'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '53'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '19'
|
| 0.0003 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '462'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '462'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '462'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '462'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '52'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '516'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '516'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '516'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '516'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '516'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '516'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '516'
AND `ID` != '7521'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '52'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '19'
|
| 0.0003 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '516'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '516'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '516'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '516'
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '6'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '727'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '727'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '727'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '727'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '727'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '727'
|
| 0.0003 |
SELECT *
FROM `images`
WHERE `RestID` = '727'
AND `ID` != '8707'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '6'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '19'
|
| 0.0004 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '727'
|
| 0.0003 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '727'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '727'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '727'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '50'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '841'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '841'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '841'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '841'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '841'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '841'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '841'
AND `ID` != '10299'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '50'
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '12'
|
| 0.0004 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '841'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '841'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '841'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '841'
|
| 0.0003 |
SELECT *
FROM `categories`
WHERE `ID` = '5'
|
| 0.0031 |
SELECT *
FROM `ratting`
WHERE `RestID` = '879'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '879'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '879'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '879'
|
| 0.0030 |
SELECT *
FROM `ratting`
WHERE `RestID` = '879'
|
| 0.0029 |
SELECT *
FROM `ratting`
WHERE `RestID` = '879'
|
| 0.0004 |
SELECT *
FROM `images`
WHERE `RestID` = '879'
AND `ID` != '10274'
ORDER BY `Size` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '5'
|
| 0.0002 |
SELECT *
FROM `categories`
WHERE `ID` = '19'
|
| 0.0003 |
SELECT *
FROM `users_comment`
WHERE `status` =0
AND `CommentType` != 'menu'
AND `CommentType` != 'image'
AND `RestID` = '879'
|
| 0.0003 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '879'
|
| 0.0002 |
SELECT *
FROM `restaurant_menues`
WHERE `RestID` = '879'
|
| 0.0012 |
SELECT *
FROM `rest_user_like`
WHERE `rest_id` = '879'
|
