0.0003 |
select `key`,`en` from `languages` ;
|
0.0004 |
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.0003 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '14' ORDER BY `PositionOrder`
|
0.0002 |
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.0002 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '4' ORDER BY `PositionOrder`
|
0.0002 |
SELECT * FROM `menu` WHERE `Position` = 'site' AND `FatherID` = '22' ORDER BY `PositionOrder`
|
0.0002 |
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.0003 |
SELECT * FROM `locations` ORDER BY `id`
|
0.0004 |
SELECT * FROM `categories` WHERE `CategoryID` = '0' AND `ID` >0 ORDER BY `ID` ASC
|
0.0099 |
SELECT * FROM `images` WHERE `RestID` >0 AND `logo` =0 AND `Exsst` = 4 GROUP BY `RestID` ORDER BY `Size` DESC LIMIT 4
|
0.0003 |
SELECT * FROM `categories` WHERE `ID` >0 AND `CategoryID` =0 ORDER BY `ID` ASC
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` >0 AND `CategoryID` = -1 ORDER BY `ID` ASC
|
0.0003 |
SELECT * FROM `locations` WHERE `ID` >0 ORDER BY `ID` ASC
|
0.0002 |
SELECT * FROM `features` WHERE `ID` >0 ORDER BY `ID` ASC
|
0.0002 |
SELECT * FROM `locations` WHERE `slug` = 'jabal-al-hussein'
|
0.0002 |
SELECT * FROM `locations` WHERE `ID` = '7'
|
0.0004 |
SELECT DISTINCT `rest_id` FROM `rest_locations` WHERE `loc_id` IN('7')
|
0.0050 |
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.0010 |
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.0002 |
SELECT * FROM `categories` WHERE `ID` = '48'
|
0.0028 |
SELECT * FROM `ratting` WHERE `RestID` = '93'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '93'
|
0.0027 |
SELECT * FROM `ratting` WHERE `RestID` = '93'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '93'
|
0.0028 |
SELECT * FROM `ratting` WHERE `RestID` = '93'
|
0.0026 |
SELECT * FROM `ratting` WHERE `RestID` = '93'
|
0.0005 |
SELECT * FROM `images` WHERE `RestID` = '93' AND `ID` != '3587' ORDER BY `Size` DESC LIMIT 3
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '48'
|
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` = '93'
|
0.0003 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '93'
|
0.0057 |
SELECT * FROM `food_items` WHERE `MenuID` = '2436'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2437'
|
0.0052 |
SELECT * FROM `food_items` WHERE `MenuID` = '2438'
|
0.0053 |
SELECT * FROM `food_items` WHERE `MenuID` = '2439'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2440'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2441'
|
0.0052 |
SELECT * FROM `food_items` WHERE `MenuID` = '2442'
|
0.0050 |
SELECT * FROM `food_items` WHERE `MenuID` = '2443'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2444'
|
0.0050 |
SELECT * FROM `food_items` WHERE `MenuID` = '2445'
|
0.0056 |
SELECT * FROM `food_items` WHERE `MenuID` = '2446'
|
0.0054 |
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.0010 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '93'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '58'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '122'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '122'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '122'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '122'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '122'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '122'
|
0.0003 |
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.0052 |
SELECT * FROM `food_items` WHERE `MenuID` = '2584'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2585'
|
0.0053 |
SELECT * FROM `food_items` WHERE `MenuID` = '2586'
|
0.0054 |
SELECT * FROM `food_items` WHERE `MenuID` = '2587'
|
0.0053 |
SELECT * FROM `food_items` WHERE `MenuID` = '2588'
|
0.0053 |
SELECT * FROM `food_items` WHERE `MenuID` = '2589'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2590'
|
0.0059 |
SELECT * FROM `food_items` WHERE `MenuID` = '2591'
|
0.0056 |
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.0011 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '122'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '58'
|
0.0027 |
SELECT * FROM `ratting` WHERE `RestID` = '123'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '123'
|
0.0026 |
SELECT * FROM `ratting` WHERE `RestID` = '123'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '123'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '123'
|
0.0027 |
SELECT * FROM `ratting` WHERE `RestID` = '123'
|
0.0003 |
SELECT * FROM `images` WHERE `RestID` = '123' AND `ID` != '236' ORDER BY `Size` DESC LIMIT 3
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '58'
|
0.0001 |
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.0057 |
SELECT * FROM `food_items` WHERE `MenuID` = '2592'
|
0.0059 |
SELECT * FROM `food_items` WHERE `MenuID` = '2593'
|
0.0058 |
SELECT * FROM `food_items` WHERE `MenuID` = '2594'
|
0.0054 |
SELECT * FROM `food_items` WHERE `MenuID` = '2595'
|
0.0056 |
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.0010 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '123'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '58'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '124'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '124'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '124'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '124'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '124'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '124'
|
0.0004 |
SELECT * FROM `images` WHERE `RestID` = '124' AND `ID` != '748' ORDER BY `Size` DESC LIMIT 3
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '58'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '54'
|
0.0003 |
SELECT * FROM `users_comment` WHERE `status` =0 AND `CommentType` != 'menu' AND `CommentType` != 'image' AND `RestID` = '124'
|
0.0002 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '124'
|
0.0051 |
SELECT * FROM `food_items` WHERE `MenuID` = '2596'
|
0.0050 |
SELECT * FROM `food_items` WHERE `MenuID` = '2597'
|
0.0051 |
SELECT * FROM `food_items` WHERE `MenuID` = '2598'
|
0.0050 |
SELECT * FROM `food_items` WHERE `MenuID` = '2599'
|
0.0054 |
SELECT * FROM `food_items` WHERE `MenuID` = '2600'
|
0.0053 |
SELECT * FROM `food_items` WHERE `MenuID` = '2601'
|
0.0054 |
SELECT * FROM `food_items` WHERE `MenuID` = '2602'
|
0.0049 |
SELECT * FROM `food_items` WHERE `MenuID` = '2603'
|
0.0046 |
SELECT * FROM `food_items` WHERE `MenuID` = '2604'
|
0.0052 |
SELECT * FROM `food_items` WHERE `MenuID` = '2605'
|
0.0056 |
SELECT * FROM `food_items` WHERE `MenuID` = '2606'
|
0.0053 |
SELECT * FROM `food_items` WHERE `MenuID` = '2607'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2608'
|
0.0053 |
SELECT * FROM `food_items` WHERE `MenuID` = '2609'
|
0.0055 |
SELECT * FROM `food_items` WHERE `MenuID` = '2610'
|
0.0056 |
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.0003 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '124'
|
0.0010 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '124'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '3'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '385'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '385'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '385'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '385'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '385'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '385'
|
0.0003 |
SELECT * FROM `images` WHERE `RestID` = '385' AND `ID` != '6514' ORDER BY `Size` DESC LIMIT 3
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '3'
|
0.0001 |
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.0010 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '385'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '53'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '462'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '462'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '462'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '462'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '462'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '462'
|
0.0003 |
SELECT * FROM `images` WHERE `RestID` = '462' AND `ID` != '7126' ORDER BY `Size` DESC LIMIT 3
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '53'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '19'
|
0.0002 |
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.0010 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '462'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '52'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '516'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '516'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '516'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '516'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '516'
|
0.0025 |
SELECT * FROM `ratting` WHERE `RestID` = '516'
|
0.0002 |
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.0002 |
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.0009 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '516'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '6'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '727'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '727'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '727'
|
0.0027 |
SELECT * FROM `ratting` WHERE `RestID` = '727'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '727'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '727'
|
0.0002 |
SELECT * FROM `images` WHERE `RestID` = '727' AND `ID` != '8707' ORDER BY `Size` DESC LIMIT 3
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '6'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '19'
|
0.0002 |
SELECT * FROM `users_comment` WHERE `status` =0 AND `CommentType` != 'menu' AND `CommentType` != 'image' AND `RestID` = '727'
|
0.0002 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '727'
|
0.0002 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '727'
|
0.0011 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '727'
|
0.0001 |
SELECT * FROM `categories` WHERE `ID` = '50'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '841'
|
0.0048 |
SELECT * FROM `ratting` WHERE `RestID` = '841'
|
0.0030 |
SELECT * FROM `ratting` WHERE `RestID` = '841'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '841'
|
0.0022 |
SELECT * FROM `ratting` WHERE `RestID` = '841'
|
0.0024 |
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.0001 |
SELECT * FROM `categories` WHERE `ID` = '12'
|
0.0003 |
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.0010 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '841'
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '5'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '879'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '879'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '879'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '879'
|
0.0024 |
SELECT * FROM `ratting` WHERE `RestID` = '879'
|
0.0023 |
SELECT * FROM `ratting` WHERE `RestID` = '879'
|
0.0003 |
SELECT * FROM `images` WHERE `RestID` = '879' AND `ID` != '10274' ORDER BY `Size` DESC LIMIT 3
|
0.0002 |
SELECT * FROM `categories` WHERE `ID` = '5'
|
0.0001 |
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.0002 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '879'
|
0.0001 |
SELECT * FROM `restaurant_menues` WHERE `RestID` = '879'
|
0.0010 |
SELECT * FROM `rest_user_like` WHERE `rest_id` = '879'
|