| 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` FROM `arabarom_news`.`products` AS `Product` LEFT JOIN `arabarom_news`.`companies` AS `Company` ON (`Product`.`company` = `Company`.`id`) WHERE `Product`.`status` = 1 AND `Product`.`id` = 1195 LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `ProductsRate`.`id`, `ProductsRate`.`product`, `ProductsRate`.`rate`, `ProductsRate`.`comment`, `ProductsRate`.`created`, `User`.`first_name`, `User`.`last_name` FROM `arabarom_news`.`products_rates` AS `ProductsRate` LEFT JOIN `arabarom_news`.`users` AS `User` ON (`ProductsRate`.`user_id` = `User`.`id`) WHERE `ProductsRate`.`product` = 1195 AND `ProductsRate`.`status` = 1 LIMIT 2 | | 0 | 0 | 0 |
| 3 | SELECT `Comment`.`id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`comment`, `Comment`.`product`, `Comment`.`created`, `Comment`.`modified` FROM `arabarom_news`.`comments` AS `Comment` WHERE `product` = 1195 ORDER BY `id` desc | | 0 | 0 | 0 |
| 4 | 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 |
| 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 ORDER BY `id` desc LIMIT 8 | | 8 | 8 | 0 |
| 6 | 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 |
| 7 | SELECT `Country`.`id`, `Country`.`fullname` FROM `arabarom_news`.`countries` AS `Country` WHERE `status` = '1' ORDER BY `fullname` asc | | 6 | 6 | 0 |
| 8 | SELECT `City`.`id`, `City`.`city_name` FROM `arabarom_news`.`cities` AS `City` WHERE `country_id` IS NULL | | 0 | 0 | 0 |
| 9 | SELECT `Company`.`id`, `Company`.`title_en` FROM `arabarom_news`.`companies` AS `Company` WHERE `status` = 1 ORDER BY `title_en` asc | | 19 | 19 | 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 |
