select `product_code`, `product_slug`, `allow_back_order` from `products` where `product_code` in ('2GIGANT2X', '2GIG-ANT5XL-GC3', 'SLE-ANTEXT50', 'SLE-ANTEXT30', 'SLE-ANTEXT04') 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)