Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `CmsPages`.`id`, `CmsPages`.`url`, `CmsPages`.`title`, `CmsPages`.`content`, `CmsPages`.`additional_content`, `CmsPages`.`created`, `CmsPages`.`modified`, `CmsPages`.`draft`, `CmsPages`.`empty_action`, `CmsPages`.`instance_id`, `CmsPages`.`in_navigation`, `CmsPages`.`nav_position`, `CmsPages`.`is_homepage`, `CmsPages`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPages` WHERE 1 = 1 ORDER BY `url` DESC | 6 | 6 | 0 | |
SELECT `Instance`.`id`, `Instance`.`name`, `Instance`.`domain`, `Instance`.`reservation_time`, `Instance`.`slogan` FROM `chainrefferdevra_cakeapp`.`instances` AS `Instance` WHERE `Instance`.`domain` = 'chainreffer.dev.rakdesign.com' LIMIT 1 | 1 | 1 | 0 | |
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`instance_id`, `CmsPage`.`in_navigation`, `CmsPage`.`nav_position`, `CmsPage`.`is_homepage`, `CmsPage`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPage` WHERE `CmsPage`.`in_navigation`=1 AND `CmsPage`.`instance_id`=1 ORDER BY `CmsPage`.`nav_position` ASC | 2 | 2 | 0 | |
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`instance_id`, `CmsPage`.`in_navigation`, `CmsPage`.`nav_position`, `CmsPage`.`is_homepage`, `CmsPage`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPage` WHERE `CmsPage`.`footer`=1 AND `CmsPage`.`instance_id`=1 ORDER BY `CmsPage`.`nav_position` ASC | 3 | 3 | 0 | |
SELECT COUNT(*) AS `count` FROM `chainrefferdevra_cakeapp`.`chains` AS `Chain` WHERE `Chain`.`id` = 14 | 1 | 1 | 0 | |
SELECT `Chain`.`id`, `Chain`.`name`, `Chain`.`description`, `Chain`.`instructions`, `Chain`.`status`, `Chain`.`instance_id`, `Chain`.`image`, `Chain`.`scheme_id`, `Scheme`.`id`, `Scheme`.`name`, `Scheme`.`instance_id`, `Scheme`.`recomended`, `Scheme`.`created`, `Instance`.`id`, `Instance`.`name`, `Instance`.`domain`, `Instance`.`reservation_time`, `Instance`.`slogan` FROM `chainrefferdevra_cakeapp`.`chains` AS `Chain` LEFT JOIN `chainrefferdevra_cakeapp`.`schemes` AS `Scheme` ON (`Chain`.`scheme_id` = `Scheme`.`id`) LEFT JOIN `chainrefferdevra_cakeapp`.`instances` AS `Instance` ON (`Chain`.`instance_id` = `Instance`.`id`) WHERE `Chain`.`id` = 14 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Code`.`id`, `Code`.`name`, `Code`.`chain_id`, `Code`.`owner_user_id`, `Code`.`created`, `Code`.`code_referal_id`, `Code`.`semafor_user_id`, `Code`.`semafor_created`, `Code`.`complain`, `Code`.`completed`, `Code`.`is_validated`, `Code`.`code_parent_id`, (SELECT Count(`u`.`code_parent_id`) FROM codes u WHERE `u`.`code_parent_id` = `Code`.`code_parent_id`) AS `Code__allcount`, (SELECT Count(`u`.`code_parent_id`) FROM codes u WHERE `u`.`code_parent_id` = `Code`.`code_parent_id` and `Code`.`created`>`u`.`created`) AS `Code__position` FROM `chainrefferdevra_cakeapp`.`codes` AS `Code` WHERE `Code`.`chain_id` = (14) | 3 | 3 | 1 | maybe slow |
SELECT `Code`.`id`, `Code`.`name`, `Code`.`chain_id`, `Code`.`owner_user_id`, `Code`.`created`, `Code`.`code_referal_id`, `Code`.`semafor_user_id`, `Code`.`semafor_created`, `Code`.`complain`, `Code`.`completed`, `Code`.`is_validated`, `Code`.`code_parent_id`, (SELECT Count(`u`.`code_parent_id`) FROM codes u WHERE `u`.`code_parent_id` = `Code`.`code_parent_id`) AS `Code__allcount`, (SELECT Count(`u`.`code_parent_id`) FROM codes u WHERE `u`.`code_parent_id` = `Code`.`code_parent_id` and `Code`.`created`>`u`.`created`) AS `Code__position`, `Chain`.`id`, `Chain`.`name`, `Chain`.`description`, `Chain`.`instructions`, `Chain`.`status`, `Chain`.`instance_id`, `Chain`.`image`, `Chain`.`scheme_id`, `OwnerUser`.`id`, `OwnerUser`.`username`, `OwnerUser`.`email`, `OwnerUser`.`password`, `OwnerUser`.`status`, `OwnerUser`.`created`, `OwnerUser`.`modified`, `OwnerUser`.`role_id`, `OwnerUser`.`born`, `OwnerUser`.`instance_id`, `CodeReferal`.`id`, `CodeReferal`.`name`, `CodeReferal`.`chain_id`, `CodeReferal`.`owner_user_id`, `CodeReferal`.`created`, `CodeReferal`.`code_referal_id`, `CodeReferal`.`semafor_user_id`, `CodeReferal`.`semafor_created`, `CodeReferal`.`complain`, `CodeReferal`.`completed`, `CodeReferal`.`is_validated`, `CodeReferal`.`code_parent_id`, (SELECT Count(`u`.`code_parent_id`) FROM codes u WHERE `u`.`code_parent_id` = `Code`.`code_parent_id`) AS `CodeReferal__allcount`, (SELECT Count(`u`.`code_parent_id`) FROM codes u WHERE `u`.`code_parent_id` = `Code`.`code_parent_id` and `Code`.`created`>`u`.`created`) AS `CodeReferal__position`, `SemaforUser`.`id`, `SemaforUser`.`username`, `SemaforUser`.`email`, `SemaforUser`.`password`, `SemaforUser`.`status`, `SemaforUser`.`created`, `SemaforUser`.`modified`, `SemaforUser`.`role_id`, `SemaforUser`.`born`, `SemaforUser`.`instance_id` FROM `chainrefferdevra_cakeapp`.`codes` AS `Code` LEFT JOIN `chainrefferdevra_cakeapp`.`chains` AS `Chain` ON (`Code`.`chain_id` = `Chain`.`id`) LEFT JOIN `chainrefferdevra_cakeapp`.`users` AS `OwnerUser` ON (`Code`.`owner_user_id` = `OwnerUser`.`id`) LEFT JOIN `chainrefferdevra_cakeapp`.`codes` AS `CodeReferal` ON (`Code`.`code_referal_id` = `CodeReferal`.`id`) LEFT JOIN `chainrefferdevra_cakeapp`.`users` AS `SemaforUser` ON (`Code`.`semafor_user_id` = `SemaforUser`.`id`) WHERE `Code`.`is_validated` = '1' AND `Code`.`complain` IS NULL AND `Code`.`chain_id` = 14 AND `Code`.`semafor_user_id` IS NULL ORDER BY rand() ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`instance_id`, `CmsPage`.`in_navigation`, `CmsPage`.`nav_position`, `CmsPage`.`is_homepage`, `CmsPage`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPage` WHERE `url` = 'en/chains/list_of_codes/14' LIMIT 1 | 0 | 0 | 0 | |