| 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` = 18 ORDER BY `Product`.`id` desc LIMIT 40 | | 12 | 12 | 2 |
| 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 (1198, 1197, 1196, 1195, 1194, 1193, 1192, 1191, 1190, 1189, 1188, 1187) | | 0 | 0 | 0 |
| 3 | 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 |
| 4 | 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` = 18 ORDER BY `id` desc LIMIT 1 | | 1 | 1 | 0 |
| 5 | 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 |
| 6 | 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 |
| 7 | 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 |
| 8 | SELECT `Country`.`id`, `Country`.`fullname` FROM `arabarom_news`.`countries` AS `Country` WHERE `status` = '1' ORDER BY `fullname` asc | | 6 | 6 | 0 |
| 9 | SELECT `City`.`id`, `City`.`city_name` FROM `arabarom_news`.`cities` AS `City` WHERE `country_id` IS NULL | | 0 | 0 | 0 |
| 10 | SELECT `Company`.`id`, `Company`.`title_en` FROM `arabarom_news`.`companies` AS `Company` WHERE `status` = 1 ORDER BY `title_en` asc | | 19 | 19 | 0 |
| 11 | SELECT `City`.`id`, `City`.`city_name` FROM `arabarom_news`.`cities` AS `City` WHERE `country_id` IS NULL | | 0 | 0 | 0 |
| 12 | SELECT `Company`.`id`, `Company`.`title_en` FROM `arabarom_news`.`companies` AS `Company` WHERE `status` = 1 ORDER BY `title_en` asc | | 19 | 19 | 0 |
