| 1 | SELECT `Product`.`id`, `Product`.`title_en`, `Product`.`title_ar`, `Product`.`details_en`, `Product`.`details_ar`, `Product`.`status`, `Product`.`pic`, `Product`.`new_arrival`, `Product`.`best_seller`, `Product`.`rate`, `Product`.`created`, `Product`.`modified`, `Product`.`category`, `Product`.`type`, `Product`.`company`, `Product`.`price`, `Product`.`amount`, `Product`.`unit`, `Product`.`for`, `Company`.`id`, `Company`.`user_id`, `Company`.`title_en`, `Company`.`title_ar`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Company`.`desc`, `Company`.`address`, `Company`.`city`, `Company`.`email`, `Company`.`website`, `Company`.`phone`, `Company`.`pic`, `Company`.`allocated_user_id`, `Category`.`id`, `Category`.`title_en`, `Category`.`title_ar`, `Category`.`status`, `Category`.`created`, `Category`.`modified`, `Category`.`pic` FROM `arabarom_news`.`products` AS `Product` LEFT JOIN `arabarom_news`.`companies` AS `Company` ON (`Product`.`company` = `Company`.`id`) LEFT JOIN `arabarom_news`.`categories` AS `Category` ON (`Product`.`category` = `Category`.`id`) WHERE `Product`.`status` = 1 AND `Product`.`company` = 35 AND `Product`.`category` = 17 ORDER BY `Product`.`id` desc LIMIT 40 | | 40 | 40 | 1 |
| 2 | SELECT `ProductsRate`.`id`, `ProductsRate`.`product`, `ProductsRate`.`user_id`, `ProductsRate`.`rate`, `ProductsRate`.`comment`, `ProductsRate`.`created`, `ProductsRate`.`modified`, `ProductsRate`.`status` FROM `arabarom_news`.`products_rates` AS `ProductsRate` WHERE `ProductsRate`.`product` IN (1326, 1325, 1324, 1323, 1322, 1321, 1320, 1319, 1318, 1317, 1316, 1315, 1314, 1313, 1312, 1311, 1310, 1309, 1308, 1307, 1306, 1305, 1304, 1303, 1302, 1301, 1300, 1299, 1298, 1297, 1296, 1295, 1294, 1293, 1292, 1291, 1279, 1278, 1277, 1276) | | 0 | 0 | 0 |
| 3 | SELECT COUNT(*) AS `count` FROM `arabarom_news`.`products` AS `Product` LEFT JOIN `arabarom_news`.`companies` AS `Company` ON (`Product`.`company` = `Company`.`id`) LEFT JOIN `arabarom_news`.`categories` AS `Category` ON (`Product`.`category` = `Category`.`id`) WHERE `Product`.`status` = 1 AND `Product`.`company` = 35 AND `Product`.`category` = 17 | | 1 | 1 | 5 |
| 4 | SELECT `Company`.`id`, `Company`.`user_id`, `Company`.`title_en`, `Company`.`title_ar`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Company`.`desc`, `Company`.`address`, `Company`.`city`, `Company`.`email`, `Company`.`website`, `Company`.`phone`, `Company`.`pic`, `Company`.`allocated_user_id` FROM `arabarom_news`.`companies` AS `Company` WHERE `id` = 35 LIMIT 1 | | 1 | 1 | 0 |
| 5 | SELECT `Category`.`id`, `Category`.`title_en`, `Category`.`title_ar`, `Category`.`status`, `Category`.`created`, `Category`.`modified`, `Category`.`pic` FROM `arabarom_news`.`categories` AS `Category` WHERE `status` = 1 AND `id` = 17 ORDER BY `id` desc LIMIT 1 | | 1 | 1 | 0 |
| 6 | SELECT `Company`.`id`, `Company`.`title_en` FROM `arabarom_news`.`companies` AS `Company` WHERE `status` = 1 ORDER BY `title_en` asc LIMIT 10 | | 10 | 10 | 0 |
| 7 | SELECT `Category`.`id`, `Category`.`title_en`, `Category`.`title_ar`, `Category`.`status`, `Category`.`created`, `Category`.`modified`, `Category`.`pic` FROM `arabarom_news`.`categories` AS `Category` WHERE `status` = 1 ORDER BY `id` desc LIMIT 8 | | 8 | 8 | 0 |
| 8 | SELECT `Company`.`id`, `Company`.`user_id`, `Company`.`title_en`, `Company`.`title_ar`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Company`.`desc`, `Company`.`address`, `Company`.`city`, `Company`.`email`, `Company`.`website`, `Company`.`phone`, `Company`.`pic`, `Company`.`allocated_user_id` FROM `arabarom_news`.`companies` AS `Company` WHERE `status` = 1 ORDER BY `title_en` asc LIMIT 10 | | 10 | 10 | 0 |
| 9 | SELECT `Country`.`id`, `Country`.`fullname` FROM `arabarom_news`.`countries` AS `Country` WHERE `status` = '1' ORDER BY `fullname` asc | | 6 | 6 | 0 |
| 10 | SELECT `City`.`id`, `City`.`city_name` FROM `arabarom_news`.`cities` AS `City` WHERE `country_id` IS NULL | | 0 | 0 | 0 |
| 11 | SELECT `Company`.`id`, `Company`.`title_en` FROM `arabarom_news`.`companies` AS `Company` WHERE `status` = 1 ORDER BY `title_en` asc | | 19 | 19 | 0 |
| 12 | SELECT `City`.`id`, `City`.`city_name` FROM `arabarom_news`.`cities` AS `City` WHERE `country_id` IS NULL | | 0 | 0 | 0 |
| 13 | SELECT `Company`.`id`, `Company`.`title_en` FROM `arabarom_news`.`companies` AS `Company` WHERE `status` = 1 ORDER BY `title_en` asc | | 19 | 19 | 0 |
.png)
.png)
.png)
.png)
.png)
