select `product_code`, `product_slug`, `allow_back_order` from `products` where `product_code` in ('PJ2-P2B-GWH', 'PJ2-2B-GWH-L01', 'L-BDG2-WH', 'RR-PROC3-KIT1') and `products`.`deleted_at` isnull
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` leftjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`group_id` in (7) orderby `menus`.`lft` asc
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` leftjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`group_id` in (5) orderby `menus`.`lft` asc
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` innerjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`parent_id` in (56, 71, 72, 73, 84, 85, 98)
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` leftjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`group_id` in (6) orderby `menus`.`lft` asc
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` innerjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`parent_id` in (59, 61, 65, 69, 70, 97)