| 1 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `sabzgostar_sabzgostar`.`aros` AS `Aro` WHERE `Aro`.`model` = 'Role' AND `Aro`.`foreign_key` = 5 LIMIT 1 | | 1 | 1 | 1 |
| 2 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `sabzgostar_sabzgostar`.`acos` AS `Aco` JOIN `sabzgostar_sabzgostar`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` = 2958 AND `Permission`.`aco_id` = `Aco`.`id`) | | 29 | 29 | 1 |
| 3 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `sabzgostar_sabzgostar`.`acos` AS `Aco` LEFT JOIN `sabzgostar_sabzgostar`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'controllers') LEFT JOIN `sabzgostar_sabzgostar`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'shop' AND `Aco0`.`id` = `Aco1`.`parent_id`) LEFT JOIN `sabzgostar_sabzgostar`.`acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'Products' AND `Aco1`.`id` = `Aco2`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY `Aco`.`lft` DESC | | 3 | 3 | 160 |
| 4 | SELECT `Aco`.`id`, `Aco`.`alias` FROM `sabzgostar_sabzgostar`.`acos` AS `Aco` WHERE `Aco`.`parent_id` = 345 | | 13 | 13 | 0 |
| 5 | SELECT `Permission`.`id`, `Permission`.`aco_id` FROM `sabzgostar_sabzgostar`.`aros_acos` AS `Permission` WHERE `Permission`.`aro_id` = 2958 AND `Permission`.`aco_id` IN (346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 435) AND `Permission`.`_create` = '1' AND `Permission`.`_read` = '1' AND `Permission`.`_update` = '1' AND `Permission`.`_delete` = '1' | | 6 | 6 | 1 |
| 6 | SELECT `Domain`.`id`, `Domain`.`url`, `Domain`.`active`, `Domain`.`created` FROM `sabzgostar_sabzgostar`.`domains` AS `Domain` WHERE `Domain`.`url` = 'tbuy.biz' LIMIT 1 | | 1 | 1 | 0 |
| 7 | SELECT `Shop`.`id`, `Shop`.`user_id`, `Shop`.`type_url`, `Shop`.`name`, `Shop`.`domain`, `Shop`.`ads`, `Shop`.`code`, `Shop`.`theme_id`, `Shop`.`active`, `Shop`.`description`, `Shop`.`keywords`, `Shop`.`limit_page`, `Shop`.`sort_product`, `Shop`.`created`, `User`.`id`, `User`.`role_id`, `User`.`parent_id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`active`, `User`.`lname`, `User`.`mobile`, `User`.`site`, `User`.`phone`, `User`.`created`, `User`.`modified`, `User`.`lastvisit`, `User`.`ip`, `User`.`acc_name`, `User`.`acc_bank`, `User`.`acc_number`, `User`.`acc_cart`, `User`.`acc_shaba`, `User`.`buy_num`, `User`.`hit`, `User`.`city`, `User`.`config_p`, `User`.`acc_kind`, `User`.`resetpass`, `User`.`passdate`, `User`.`subset`, (CONCAT(`User`.`name`, " ", `User`.`lname`)) AS `User__name`, `Theme`.`id`, `Theme`.`name`, `Theme`.`title`, `Theme`.`active`, `Domain`.`id`, `Domain`.`url`, `Domain`.`active`, `Domain`.`created` FROM `sabzgostar_sabzgostar`.`shops` AS `Shop` LEFT JOIN `sabzgostar_sabzgostar`.`users` AS `User` ON (`Shop`.`user_id` = `User`.`id`) LEFT JOIN `sabzgostar_sabzgostar`.`themes` AS `Theme` ON (`Shop`.`theme_id` = `Theme`.`id`) LEFT JOIN `sabzgostar_sabzgostar`.`domains` AS `Domain` ON (`Shop`.`type_url` = `Domain`.`id`) WHERE `Shop`.`domain` = ('98ava') AND `Shop`.`type_url` = 1 LIMIT 1 | | 0 | 0 | 8 |
| 8 | SELECT `Prod`.`id`, `Prod`.`pros_id` FROM `sabzgostar_sabzgostar`.`pros_ushops` AS `Prod` WHERE ((((`Prod`.`ushops_id` IS NULL) AND (`Prod`.`type` = 3))) OR (((`Prod`.`ushops_id` IS NULL) AND (`Prod`.`type` = 1))) OR (((`Prod`.`ushops_id` IS NULL) AND (`Prod`.`type` = 5)))) | | 0 | 0 | 0 |
| 9 | SELECT `Prod`.`id`, `Prod`.`pros_id` FROM `sabzgostar_sabzgostar`.`pros_ushops` AS `Prod` WHERE ((((`Prod`.`ushops_id` IS NULL) AND (`Prod`.`type` = 4))) OR (((`Prod`.`ushops_id` IS NULL) AND (`Prod`.`type` = 2))) OR (((`Prod`.`ushops_id` IS NULL) AND (`Prod`.`type` = 6)))) | | 0 | 0 | 0 |
| 10 | SELECT `Product`.`id`, `Product`.`product_link`, `Product`.`order`, `Product`.`active`, `Product`.`price`, `Product`.`off`, `Product`.`cate_id`, `Product`.`view`, `Product`.`name`, `Product`.`extra`, `Product`.`created`, `Product`.`modified`, `Product`.`short_description`, `Product`.`description`, `Product`.`tags`, `Product`.`page_title`, `Product`.`meta_keywords`, `Product`.`meta_description`, `Product`.`product_num`, `Product`.`buy_num`, `Product`.`hit`, `Product`.`weight_p`, `Product`.`percent_p`, `Product`.`product_code`, `Product`.`url`, `Product`.`thumbs`, `ProductsCate`.`id`, `ProductsCate`.`title`, `ProductsCate`.`img`, `ProductsCate`.`parent_id`, `ProductsCate`.`lft`, `ProductsCate`.`rght`, `ProductsCate`.`sort_order`, `ProductsCate`.`active`, `ProductsCate`.`page_title`, `ProductsCate`.`meta_keywords`, `ProductsCate`.`meta_description`, `ProductsCate`.`created`, `ProductsCate`.`modified` FROM `sabzgostar_sabzgostar`.`products` AS `Product` LEFT JOIN `sabzgostar_sabzgostar`.`products_cates` AS `ProductsCate` ON (`Product`.`cate_id` = `ProductsCate`.`id`) WHERE `Product`.`active` = 1 AND NOT (`Product`.`id` IS NULL) AND NOT (`Product`.`cate_id` IS NULL) LIMIT 1 | | 1 | 1 | 0 |
| 11 | SELECT `Banner`.`id`, `Banner`.`size_id`, `Banner`.`product_id`, `Banner`.`product_link`, `Banner`.`title`, `Banner`.`pic`, `Banner`.`active`, `Banner`.`created`, `Banner`.`modified`, `Banner`.`type` FROM `sabzgostar_sabzgostar`.`banners` AS `Banner` WHERE `Banner`.`product_id` = (12) | | 2 | 2 | 1 |
| 12 | SELECT COUNT(*) AS `count` FROM `sabzgostar_sabzgostar`.`products` AS `Product` LEFT JOIN `sabzgostar_sabzgostar`.`products_cates` AS `ProductsCate` ON (`Product`.`cate_id` = `ProductsCate`.`id`) WHERE `Product`.`active` = 1 AND NOT (`Product`.`id` IS NULL) AND NOT (`Product`.`cate_id` IS NULL) | | 1 | 1 | 1 |
| 13 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `sabzgostar_sabzgostar`.`aros` AS `Aro` WHERE `Aro`.`model` = 'Role' AND `Aro`.`foreign_key` = 5 LIMIT 1 | | 1 | 1 | 1 |
| 14 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `sabzgostar_sabzgostar`.`acos` AS `Aco` JOIN `sabzgostar_sabzgostar`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` = 2958 AND `Permission`.`aco_id` = `Aco`.`id`) | | 29 | 29 | 1 |
| 15 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `sabzgostar_sabzgostar`.`acos` AS `Aco` LEFT JOIN `sabzgostar_sabzgostar`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'controllers') LEFT JOIN `sabzgostar_sabzgostar`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'shop' AND `Aco0`.`id` = `Aco1`.`parent_id`) LEFT JOIN `sabzgostar_sabzgostar`.`acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'CakeError' AND `Aco1`.`id` = `Aco2`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY `Aco`.`lft` DESC | | 1 | 1 | 137 |
| 16 | SELECT `Domain`.`id`, `Domain`.`url`, `Domain`.`active`, `Domain`.`created` FROM `sabzgostar_sabzgostar`.`domains` AS `Domain` WHERE `Domain`.`url` = 'tbuy.biz' LIMIT 1 | | 1 | 1 | 8 |
| 17 | SELECT `Shop`.`id`, `Shop`.`user_id`, `Shop`.`type_url`, `Shop`.`name`, `Shop`.`domain`, `Shop`.`ads`, `Shop`.`code`, `Shop`.`theme_id`, `Shop`.`active`, `Shop`.`description`, `Shop`.`keywords`, `Shop`.`limit_page`, `Shop`.`sort_product`, `Shop`.`created`, `User`.`id`, `User`.`role_id`, `User`.`parent_id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`active`, `User`.`lname`, `User`.`mobile`, `User`.`site`, `User`.`phone`, `User`.`created`, `User`.`modified`, `User`.`lastvisit`, `User`.`ip`, `User`.`acc_name`, `User`.`acc_bank`, `User`.`acc_number`, `User`.`acc_cart`, `User`.`acc_shaba`, `User`.`buy_num`, `User`.`hit`, `User`.`city`, `User`.`config_p`, `User`.`acc_kind`, `User`.`resetpass`, `User`.`passdate`, `User`.`subset`, (CONCAT(`User`.`name`, " ", `User`.`lname`)) AS `User__name`, `Theme`.`id`, `Theme`.`name`, `Theme`.`title`, `Theme`.`active`, `Domain`.`id`, `Domain`.`url`, `Domain`.`active`, `Domain`.`created` FROM `sabzgostar_sabzgostar`.`shops` AS `Shop` LEFT JOIN `sabzgostar_sabzgostar`.`users` AS `User` ON (`Shop`.`user_id` = `User`.`id`) LEFT JOIN `sabzgostar_sabzgostar`.`themes` AS `Theme` ON (`Shop`.`theme_id` = `Theme`.`id`) LEFT JOIN `sabzgostar_sabzgostar`.`domains` AS `Domain` ON (`Shop`.`type_url` = `Domain`.`id`) WHERE `Shop`.`domain` = ('98ava') AND `Shop`.`type_url` = 1 LIMIT 1 | | 0 | 0 | 7 |