| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `MenuLink`.`id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`menu_id`, `MenuLink`.`icon`, `MenuLink`.`title`, `MenuLink`.`link`, `MenuLink`.`attributes`, `MenuLink`.`active`, `MenuLink`.`created`, `MenuLink`.`modified` FROM `acewebin_hpilluminations`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`menu_id` = 2 AND `MenuLink`.`active` = '1' ORDER BY `MenuLink`.`lft` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `MenuLink`.`id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`menu_id`, `MenuLink`.`icon`, `MenuLink`.`title`, `MenuLink`.`link`, `MenuLink`.`attributes`, `MenuLink`.`active`, `MenuLink`.`created`, `MenuLink`.`modified` FROM `acewebin_hpilluminations`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`menu_id` = 4 AND `MenuLink`.`active` = '1' ORDER BY `MenuLink`.`lft` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `Client`.`id`, `Client`.`name`, `Client`.`short_note`, `Client`.`note`, `Client`.`logo`, `Client`.`active`, `Client`.`display_order`, `Client`.`created`, `Client`.`modified` FROM `acewebin_hpilluminations`.`clients` AS `Client` WHERE `Client`.`active` = '1' ORDER BY `Client`.`display_order` ASC | 3 | 3 | 1 | maybe slow |
| SELECT `OurWork`.`id`, `OurWork`.`client_id`, `OurWork`.`name`, `OurWork`.`image`, `OurWork`.`active`, `OurWork`.`its_up_comming`, `OurWork`.`display_order`, `OurWork`.`created`, `OurWork`.`modified`, `Client`.`id`, `Client`.`name`, `Client`.`short_note`, `Client`.`note`, `Client`.`logo`, `Client`.`active`, `Client`.`display_order`, `Client`.`created`, `Client`.`modified` FROM `acewebin_hpilluminations`.`our_works` AS `OurWork` LEFT JOIN `acewebin_hpilluminations`.`clients` AS `Client` ON (`OurWork`.`client_id` = `Client`.`id`) WHERE `OurWork`.`active` = '1' ORDER BY `OurWork`.`display_order` ASC LIMIT 20 | 4 | 4 | 1 | maybe slow |
| SELECT `OurWorkImage`.`id`, `OurWorkImage`.`our_work_id`, `OurWorkImage`.`client_id`, `OurWorkImage`.`name`, `OurWorkImage`.`image`, `OurWorkImage`.`producer`, `OurWorkImage`.`director`, `OurWorkImage`.`active`, `OurWorkImage`.`dop`, `OurWorkImage`.`created`, `OurWorkImage`.`modified` FROM `acewebin_hpilluminations`.`our_work_images` AS `OurWorkImage` WHERE `OurWorkImage`.`our_work_id` IN (1, 2, 3, 4) | 50 | 50 | 1 | |
| SELECT COUNT(*) AS `count` FROM `acewebin_hpilluminations`.`our_works` AS `OurWork` LEFT JOIN `acewebin_hpilluminations`.`clients` AS `Client` ON (`OurWork`.`client_id` = `Client`.`id`) WHERE `OurWork`.`active` = '1' | 1 | 1 | 1 | |