Artbol.nl verzorgt al uw wanddecoratie. Of u nu op zoek bent naar een poster voor uw kinderen, of een origineel schilderij voor in de woonkamer, Artbol.nl heeft uw kunstwerk in het assortiment.
Op dit moment bekijkt u de categorie (). Wanneer u de welke u zoekt niet kunt vinden, kunt u gebruik maken van onze uitgebreide zoekfunctie.
| Query | Rows | Time | |
| 1 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/webshop/cart/add/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 2 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/favorites/add/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 3 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/framing/start/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 4 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 5 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_formats/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 6 | SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/decoratief' AND `language` = '1' | 1 | 0 ms |
| 7 | SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/decoratief/' AND `language` = '1' | 1 | 0 ms |
| 8 | SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/decoratief' AND `language` = '1' | 1 | 0 ms |
| 9 | SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/decoratief/' AND `language` = '1' | 1 | 0 ms |
| 10 | SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen' AND `language` = '1' | 1 | 0 ms |
| 11 | SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/' AND `language` = '1' | 1 | 0 ms |
| 12 | SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 13 | SELECT `id` as `Configuration.Id`, `value` as `Configuration.Value` FROM `configurations` AS `Configuration` | 15 | 0 ms |
| 14 | DELETE FROM `discount_codes` WHERE `valid_till` < 1765356708 | 0 | 0 ms |
| 15 | SELECT `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `id` = '634' ORDER BY `category_name` ASC LIMIT 1 | 0 | 0 ms |
| 16 | SELECT `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `id` = '634' ORDER BY `category_name` ASC LIMIT 1 | 0 | 0 ms |
| 17 | DESCRIBE `product_categories` | 4 | 0.01 ms |
| 18 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `id` = '634' ORDER BY `category_name` ASC LIMIT 1 | 0 | 0 ms |
| 19 | SELECT `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` WHERE `product_type_id` = '' ORDER BY `menu_order` ASC LIMIT 1 | 0 | 0 ms |
| 20 | SELECT `id` as `Translation.Id`, `value` as `Translation.Value` FROM `translations` AS `Translation` WHERE `language` = '1' | 32 | 0.11 ms |
| 21 | SELECT `reference` as `ProductLimitedEdition.Reference`, `circulation` as `ProductLimitedEdition.Circulation` FROM `product_limited_editions` AS `ProductLimitedEdition` | 208 | 0 ms |
| 22 | SELECT `id` as `ProductCategory.Id`, `id` as `ProductCategory.Id` FROM `product_categories` AS `ProductCategory` WHERE `parent` = '634' | 0 | 0 ms |
| 23 | SELECT `product` as `ProductInCategory.Product`, `category` as `ProductInCategory.Category`, `product` as `ProductInCategory.Product` FROM `products_in_categories` AS `ProductInCategory` WHERE `category` IN(634,-1) | 0 | 0 ms |
| 24 | SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `id` IN() AND `deleted` = 0 AND `tagged` = 1 AND `file_exists` = 1 | ||
| 25 | SELECT `id` as `ProductCategory.Id`, `id` as `ProductCategory.Id` FROM `product_categories` AS `ProductCategory` WHERE `parent` = '634' | 0 | 0 ms |
| 26 | SELECT `product` as `ProductInCategory.Product`, `category` as `ProductInCategory.Category`, `product` as `ProductInCategory.Product` FROM `products_in_categories` AS `ProductInCategory` WHERE `category` IN(634,-1) | 0 | 0 ms |
| 27 | DESCRIBE `products` | 33 | 0.01 ms |
| 28 | SELECT `id` as `Product.Id`, `vendor` as `Product.Vendor`, `vendor_podexchange` as `Product.Vendor_podexchange`, `reference` as `Product.Reference`, `artist_first` as `Product.Artist_first`, `artist_last` as `Product.Artist_last`, `title` as `Product.Title`, `description` as `Product.Description`, `paper_width` as `Product.Paper_width`, `paper_height` as `Product.Paper_height`, `image_width` as `Product.Image_width`, `image_height` as `Product.Image_height`, `price` as `Product.Price`, `discount` as `Product.Discount`, `deleted` as `Product.Deleted`, `tagged` as `Product.Tagged`, `retag` as `Product.Retag`, `product_type` as `Product.Product_type`, `product_on` as `Product.Product_on`, `file_exists` as `Product.File_exists`, `allow_framing` as `Product.Allow_framing`, `order` as `Product.Order`, `placed` as `Product.Placed`, `artline_pricecode` as `Product.Artline_pricecode`, `pod` as `Product.Pod`, `pod_allow_canvas` as `Product.Pod_allow_canvas`, `pod_allow_dibond` as `Product.Pod_allow_dibond`, `pod_allow_plexi` as `Product.Pod_allow_plexi`, `pod_wh_ratio` as `Product.Pod_wh_ratio`, `newimported` as `Product.Newimported`, `randomfrontpage` as `Product.Randomfrontpage`, `img` as `Product.Img`, `thumb` as `Product.Thumb` FROM `products` AS `Product` WHERE `id` IN() AND `deleted` = 0 AND `tagged` = 1 AND `file_exists` = 1 ORDER BY `order` ASC LIMIT -24, 24 | ||
| 29 | SELECT `product_type_id` as `ProductType.Product_type_id`, `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` ORDER BY `menu_order` ASC | 9 | 0 ms |
| 30 | SELECT `product_type_id` as `ProductType.Product_type_id`, `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` ORDER BY `menu_order` ASC | 9 | 0 ms |
| 31 | SELECT `id` as `ProductOn.Id`, `value` as `ProductOn.Value` FROM `product_on` AS `ProductOn` | 15 | 0 ms |
| 32 | SELECT COUNT(*) AS `WebshopCart.Findcount` FROM `webshop_carts` AS `WebshopCart` WHERE `ip` = '216.73.216.35' | 1 | 0.54 ms |
| 33 | DESCRIBE `webshop_carts` | 14 | 0.01 ms |
| 34 | DESCRIBE `frame_static` | 12 | 0.01 ms |
| 35 | DESCRIBE `lj_frame_static` | 21 | 0.01 ms |
| 36 | DESCRIBE `frame_borders` | 15 | 0.01 ms |
| 37 | DESCRIBE `frame_glasses` | 9 | 0 ms |
| 38 | SELECT `WebshopCart`.`id` as `WebshopCart.Id`, `WebshopCart`.`ip` as `WebshopCart.Ip`, `WebshopCart`.`product` as `WebshopCart.Product`, `WebshopCart`.`quantity` as `WebshopCart.Quantity`, `WebshopCart`.`frame_border` as `WebshopCart.Frame_border`, `WebshopCart`.`static_frame` as `WebshopCart.Static_frame`, `WebshopCart`.`lj_static_frame` as `WebshopCart.Lj_static_frame`, `WebshopCart`.`passepartout` as `WebshopCart.Passepartout`, `WebshopCart`.`ppt_size` as `WebshopCart.Ppt_size`, `WebshopCart`.`cut` as `WebshopCart.Cut`, `WebshopCart`.`glass` as `WebshopCart.Glass`, `WebshopCart`.`extra` as `WebshopCart.Extra`, `WebshopCart`.`giftcard` as `WebshopCart.Giftcard`, `WebshopCart`.`last_update` as `WebshopCart.Last_update`, `Product`.`id` as `Product.Id`, `Product`.`vendor` as `Product.Vendor`, `Product`.`vendor_podexchange` as `Product.Vendor_podexchange`, `Product`.`reference` as `Product.Reference`, `Product`.`artist_first` as `Product.Artist_first`, `Product`.`artist_last` as `Product.Artist_last`, `Product`.`title` as `Product.Title`, `Product`.`description` as `Product.Description`, `Product`.`paper_width` as `Product.Paper_width`, `Product`.`paper_height` as `Product.Paper_height`, `Product`.`image_width` as `Product.Image_width`, `Product`.`image_height` as `Product.Image_height`, `Product`.`price` as `Product.Price`, `Product`.`discount` as `Product.Discount`, `Product`.`deleted` as `Product.Deleted`, `Product`.`tagged` as `Product.Tagged`, `Product`.`retag` as `Product.Retag`, `Product`.`product_type` as `Product.Product_type`, `Product`.`product_on` as `Product.Product_on`, `Product`.`file_exists` as `Product.File_exists`, `Product`.`allow_framing` as `Product.Allow_framing`, `Product`.`order` as `Product.Order`, `Product`.`placed` as `Product.Placed`, `Product`.`artline_pricecode` as `Product.Artline_pricecode`, `Product`.`pod` as `Product.Pod`, `Product`.`pod_allow_canvas` as `Product.Pod_allow_canvas`, `Product`.`pod_allow_dibond` as `Product.Pod_allow_dibond`, `Product`.`pod_allow_plexi` as `Product.Pod_allow_plexi`, `Product`.`pod_wh_ratio` as `Product.Pod_wh_ratio`, `Product`.`newimported` as `Product.Newimported`, `Product`.`randomfrontpage` as `Product.Randomfrontpage`, `Product`.`img` as `Product.Img`, `Product`.`thumb` as `Product.Thumb`, `FrameStatic`.`id` as `FrameStatic.Id`, `FrameStatic`.`vendor` as `FrameStatic.Vendor`, `FrameStatic`.`code` as `FrameStatic.Code`, `FrameStatic`.`material` as `FrameStatic.Material`, `FrameStatic`.`color` as `FrameStatic.Color`, `FrameStatic`.`profile_width_mm` as `FrameStatic.Profile_width_mm`, `FrameStatic`.`cost` as `FrameStatic.Cost`, `FrameStatic`.`height` as `FrameStatic.Height`, `FrameStatic`.`width` as `FrameStatic.Width`, `FrameStatic`.`framefile` as `FrameStatic.Framefile`, `FrameStatic`.`deleted` as `FrameStatic.Deleted`, `FrameStatic`.`order` as `FrameStatic.Order`, `LjFrameStatic`.`id` as `LjFrameStatic.Id`, `LjFrameStatic`.`code` as `LjFrameStatic.Code`, `LjFrameStatic`.`material` as `LjFrameStatic.Material`, `LjFrameStatic`.`color` as `LjFrameStatic.Color`, `LjFrameStatic`.`profile_width_mm` as `LjFrameStatic.Profile_width_mm`, `LjFrameStatic`.`cost` as `LjFrameStatic.Cost`, `LjFrameStatic`.`height` as `LjFrameStatic.Height`, `LjFrameStatic`.`width` as `LjFrameStatic.Width`, `LjFrameStatic`.`description` as `LjFrameStatic.Description`, `LjFrameStatic`.`framefile` as `LjFrameStatic.Framefile`, `LjFrameStatic`.`alt_desc` as `LjFrameStatic.Alt_desc`, `LjFrameStatic`.`google_feed_use` as `LjFrameStatic.Google_feed_use`, `LjFrameStatic`.`google_title` as `LjFrameStatic.Google_title`, `LjFrameStatic`.`google_description` as `LjFrameStatic.Google_description`, `LjFrameStatic`.`google_product_category` as `LjFrameStatic.Google_product_category`, `LjFrameStatic`.`google_site_category` as `LjFrameStatic.Google_site_category`, `LjFrameStatic`.`google_brand` as `LjFrameStatic.Google_brand`, `LjFrameStatic`.`google_gtin` as `LjFrameStatic.Google_gtin`, `LjFrameStatic`.`order` as `LjFrameStatic.Order`, `LjFrameStatic`.`visible` as `LjFrameStatic.Visible`, `LjFrameStatic`.`deleted` as `LjFrameStatic.Deleted`, `FrameBorder`.`id` as `FrameBorder.Id`, `FrameBorder`.`vendor` as `FrameBorder.Vendor`, `FrameBorder`.`code` as `FrameBorder.Code`, `FrameBorder`.`color` as `FrameBorder.Color`, `FrameBorder`.`material` as `FrameBorder.Material`, `FrameBorder`.`profile_width_mm` as `FrameBorder.Profile_width_mm`, `FrameBorder`.`max_width` as `FrameBorder.Max_width`, `FrameBorder`.`max_height` as `FrameBorder.Max_height`, `FrameBorder`.`cost_static` as `FrameBorder.Cost_static`, `FrameBorder`.`cost_m_under5cm` as `FrameBorder.Cost_m_under5cm`, `FrameBorder`.`cost_m_over5cm` as `FrameBorder.Cost_m_over5cm`, `FrameBorder`.`baklijst` as `FrameBorder.Baklijst`, `FrameBorder`.`tagged` as `FrameBorder.Tagged`, `FrameBorder`.`file_exists` as `FrameBorder.File_exists`, `FrameBorder`.`deleted` as `FrameBorder.Deleted`, `FrameGlass`.`id` as `FrameGlass.Id`, `FrameGlass`.`vendor` as `FrameGlass.Vendor`, `FrameGlass`.`code` as `FrameGlass.Code`, `FrameGlass`.`description` as `FrameGlass.Description`, `FrameGlass`.`cost_m2` as `FrameGlass.Cost_m2`, `FrameGlass`.`cost_static` as `FrameGlass.Cost_static`, `FrameGlass`.`max_length_cm` as `FrameGlass.Max_length_cm`, `FrameGlass`.`can_have_ppt` as `FrameGlass.Can_have_ppt`, `FrameGlass`.`laminate` as `FrameGlass.Laminate` FROM `webshop_carts` AS `WebshopCart` LEFT JOIN `products` AS `Product` ON `Product`.`id` = `WebshopCart`.`product` LEFT JOIN `frame_static` AS `FrameStatic` ON `FrameStatic`.`id` = `WebshopCart`.`static_frame` LEFT JOIN `lj_frame_static` AS `LjFrameStatic` ON `LjFrameStatic`.`id` = `WebshopCart`.`lj_static_frame` LEFT JOIN `frame_borders` AS `FrameBorder` ON `FrameBorder`.`id` = `WebshopCart`.`frame_border` LEFT JOIN `frame_glasses` AS `FrameGlass` ON `FrameGlass`.`id` = `WebshopCart`.`glass` WHERE `ip` = '216.73.216.35' | 49 | 0.4 ms |
| 39 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/search/advanced' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 40 | SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/decoratief' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 0 | 0 ms |
| 41 | SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/decoratief' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 0 | 0 ms |
| 42 | SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/online-kunst-bestellen/decoratief' ORDER BY `route` DESC LIMIT 1 | 0 | 0 ms |
| 43 | DESCRIBE `routes` | 4 | 0.01 ms |
| 44 | SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/online-kunst-bestellen/decoratief' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 0 | 0 ms |
| 45 | SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/online-kunst-bestellen/decoratief' AND `language` = '3' ORDER BY `route` DESC LIMIT 1 | 0 | 0 ms |
| 46 | SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/online-kunst-bestellen/decoratief' AND `language` = '2' ORDER BY `route` DESC LIMIT 1 | 0 | 0 ms |
| 47 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/user/login' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 48 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/user/register' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 49 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/webshop/cart' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 50 | SELECT *, SUM(`id`) AS `discounted` FROM `products_in_categories` LEFT JOIN `products` ON `products`.`id` = `products_in_categories`.`product` WHERE `products`.`discount` > 0 GROUP BY `category` | 200 | 0.28 ms |
| 51 | SELECT `product_type_id` as `ProductType.Product_type_id`, `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` WHERE `menu_order` >= 0 ORDER BY `menu_order` ASC | 7 | 0 ms |
| 52 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 53 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 54 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 55 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/plexiglas' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 56 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 57 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 58 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/aluminium' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 59 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 60 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 61 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/1' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 62 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '0' | 1 | 0 ms |
| 63 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '0' ORDER BY `category_name` ASC | 32 | 0 ms |
| 64 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3' | 1 | 0 ms |
| 65 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/3' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 66 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3' | 1 | 0 ms |
| 67 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/3' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 68 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3' ORDER BY `category_name` ASC | 6 | 0 ms |
| 69 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '26' | 1 | 0 ms |
| 70 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/26' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 71 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '26' | 1 | 0 ms |
| 72 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '24' | 1 | 0 ms |
| 73 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/24' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 74 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '24' | 1 | 0 ms |
| 75 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '118' | 1 | 0 ms |
| 76 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/118' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 77 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '118' | 1 | 0 ms |
| 78 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '25' | 1 | 0 ms |
| 79 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/25' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 80 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '25' | 1 | 0 ms |
| 81 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '1' | 1 | 0 ms |
| 82 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/1' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 83 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '1' | 1 | 0 ms |
| 84 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '598' | 1 | 0 ms |
| 85 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/598' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 86 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '598' | 1 | 0 ms |
| 87 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134' | 1 | 0 ms |
| 88 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/134' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 89 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134' | 1 | 0 ms |
| 90 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134' ORDER BY `category_name` ASC | 3 | 0 ms |
| 91 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '154' | 1 | 0 ms |
| 92 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/154' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 93 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '154' | 1 | 0 ms |
| 94 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '156' | 1 | 0 ms |
| 95 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/156' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 96 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '156' | 1 | 0 ms |
| 97 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '155' | 1 | 0 ms |
| 98 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/155' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 99 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '155' | 1 | 0 ms |
| 100 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '5' | 1 | 0 ms |
| 101 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/5' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 102 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '5' | 1 | 0 ms |
| 103 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4' | 1 | 0 ms |
| 104 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 105 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4' | 1 | 0 ms |
| 106 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 107 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4' ORDER BY `category_name` ASC | 4 | 0 ms |
| 108 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '711' | 1 | 0 ms |
| 109 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/711' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 110 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '711' | 1 | 0 ms |
| 111 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '27' | 1 | 0 ms |
| 112 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/27' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 113 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '27' | 1 | 0 ms |
| 114 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '28' | 1 | 0 ms |
| 115 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/28' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 116 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '28' | 1 | 0 ms |
| 117 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '119' | 1 | 0 ms |
| 118 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/119' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 119 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '119' | 1 | 0 ms |
| 120 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135' | 1 | 0 ms |
| 121 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/135' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 122 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135' | 1 | 0 ms |
| 123 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/135' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 124 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135' ORDER BY `category_name` ASC | 2 | 0 ms |
| 125 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '222' | 1 | 0 ms |
| 126 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/222' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 127 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '222' | 1 | 0 ms |
| 128 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '235' | 1 | 0 ms |
| 129 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/235' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 130 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '235' | 1 | 0 ms |
| 131 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2' | 1 | 0 ms |
| 132 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/2' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 133 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2' | 1 | 0 ms |
| 134 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/2' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 135 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2' ORDER BY `category_name` ASC | 15 | 0 ms |
| 136 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '595' | 1 | 0 ms |
| 137 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/595' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 138 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '595' | 1 | 0 ms |
| 139 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '30' | 1 | 0 ms |
| 140 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/30' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 141 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '30' | 1 | 0 ms |
| 142 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '32' | 1 | 0 ms |
| 143 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/32' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 144 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '32' | 1 | 0 ms |
| 145 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '600' | 1 | 0 ms |
| 146 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/600' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 147 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '600' | 1 | 0 ms |
| 148 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '29' | 1 | 0 ms |
| 149 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/29' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 150 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '29' | 1 | 0 ms |
| 151 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '36' | 1 | 0 ms |
| 152 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/36' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 153 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '36' | 1 | 0 ms |
| 154 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '717' | 1 | 0 ms |
| 155 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/717' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 156 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '717' | 1 | 0 ms |
| 157 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '597' | 1 | 0 ms |
| 158 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/597' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 159 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '597' | 1 | 0 ms |
| 160 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '34' | 1 | 0 ms |
| 161 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/34' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 162 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '34' | 1 | 0 ms |
| 163 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '35' | 1 | 0 ms |
| 164 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/35' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 165 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '35' | 1 | 0 ms |
| 166 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '596' | 1 | 0 ms |
| 167 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/596' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 168 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '596' | 1 | 0 ms |
| 169 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '31' | 1 | 0 ms |
| 170 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/31' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 171 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '31' | 1 | 0 ms |
| 172 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '603' | 1 | 0 ms |
| 173 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/603' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 174 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '603' | 1 | 0 ms |
| 175 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '33' | 1 | 0 ms |
| 176 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/33' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 177 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '33' | 1 | 0 ms |
| 178 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '726' | 1 | 0 ms |
| 179 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/726' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 180 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '726' | 1 | 0 ms |
| 181 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7' | 1 | 0 ms |
| 182 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 183 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7' | 1 | 0 ms |
| 184 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 185 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7' ORDER BY `category_name` ASC | 3 | 0 ms |
| 186 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '593' | 1 | 0 ms |
| 187 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/593' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 188 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '593' | 1 | 0 ms |
| 189 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '592' | 1 | 0 ms |
| 190 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/592' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 191 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '592' | 1 | 0 ms |
| 192 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '594' | 1 | 0 ms |
| 193 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/594' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 194 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '594' | 1 | 0 ms |
| 195 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138' | 1 | 0 ms |
| 196 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/138' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 197 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138' | 1 | 0 ms |
| 198 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/138' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 199 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138' ORDER BY `category_name` ASC | 3 | 0 ms |
| 200 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '244' | 1 | 0 ms |
| 201 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/244' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 202 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '244' | 1 | 0 ms |
| 203 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '160' | 1 | 0 ms |
| 204 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/160' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 205 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '160' | 1 | 0 ms |
| 206 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '161' | 1 | 0 ms |
| 207 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/161' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 208 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '161' | 1 | 0 ms |
| 209 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6' | 1 | 0 ms |
| 210 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 211 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6' | 1 | 0 ms |
| 212 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 213 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6' ORDER BY `category_name` ASC | 17 | 0 ms |
| 214 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '43' | 1 | 0 ms |
| 215 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/43' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 216 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '43' | 1 | 0 ms |
| 217 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '253' | 1 | 0 ms |
| 218 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/253' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 219 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '253' | 1 | 0 ms |
| 220 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '234' | 1 | 0 ms |
| 221 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/234' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 222 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '234' | 1 | 0 ms |
| 223 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '262' | 1 | 0 ms |
| 224 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/262' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 225 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '262' | 1 | 0 ms |
| 226 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '609' | 1 | 0 ms |
| 227 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/609' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 228 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '609' | 1 | 0 ms |
| 229 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '40' | 1 | 0 ms |
| 230 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/40' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 231 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '40' | 1 | 0 ms |
| 232 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '38' | 1 | 0 ms |
| 233 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/38' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 234 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '38' | 1 | 0 ms |
| 235 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '41' | 1 | 0 ms |
| 236 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/41' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 237 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '41' | 1 | 0 ms |
| 238 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '44' | 1 | 0 ms |
| 239 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/44' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 240 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '44' | 1 | 0 ms |
| 241 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '39' | 1 | 0 ms |
| 242 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/39' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 243 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '39' | 1 | 0 ms |
| 244 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '263' | 1 | 0 ms |
| 245 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/263' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 246 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '263' | 1 | 0 ms |
| 247 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '37' | 1 | 0 ms |
| 248 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/37' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 249 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '37' | 1 | 0 ms |
| 250 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '629' | 1 | 0 ms |
| 251 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/629' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 252 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '629' | 1 | 0 ms |
| 253 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '610' | 1 | 0 ms |
| 254 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/610' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 255 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '610' | 1 | 0 ms |
| 256 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '42' | 1 | 0 ms |
| 257 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/42' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 258 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '42' | 1 | 0 ms |
| 259 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '257' | 1 | 0 ms |
| 260 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/257' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 261 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '257' | 1 | 0 ms |
| 262 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '712' | 1 | 0 ms |
| 263 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/712' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 264 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '712' | 1 | 0 ms |
| 265 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139' | 1 | 0 ms |
| 266 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/139' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 267 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139' | 1 | 0 ms |
| 268 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/139' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 269 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139' ORDER BY `category_name` ASC | 2 | 0 ms |
| 270 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '308' | 1 | 0 ms |
| 271 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/308' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 272 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '308' | 1 | 0 ms |
| 273 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '247' | 1 | 0 ms |
| 274 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/247' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 275 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '247' | 1 | 0 ms |
| 276 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8' | 1 | 0 ms |
| 277 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/8' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 278 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8' | 1 | 0 ms |
| 279 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/8' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 280 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8' ORDER BY `category_name` ASC | 3 | 0 ms |
| 281 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '49' | 1 | 0.01 ms |
| 282 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/49' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 283 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '49' | 1 | 0 ms |
| 284 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '51' | 1 | 0 ms |
| 285 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/51' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 286 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '51' | 1 | 0 ms |
| 287 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '50' | 1 | 0 ms |
| 288 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/50' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 289 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '50' | 1 | 0 ms |
| 290 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9' | 1 | 0 ms |
| 291 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/9' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 292 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9' | 1 | 0 ms |
| 293 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/9' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 294 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9' ORDER BY `category_name` ASC | 8 | 0 ms |
| 295 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '54' | 1 | 0 ms |
| 296 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/54' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 297 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '54' | 1 | 0 ms |
| 298 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '57' | 1 | 0 ms |
| 299 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/57' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 300 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '57' | 1 | 0 ms |
| 301 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '140' | 1 | 0 ms |
| 302 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/140' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 303 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '140' | 1 | 0 ms |
| 304 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '55' | 1 | 0 ms |
| 305 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/55' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 306 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '55' | 1 | 0 ms |
| 307 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '727' | 1 | 0 ms |
| 308 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/727' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 309 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '727' | 1 | 0 ms |
| 310 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '56' | 1 | 0 ms |
| 311 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/56' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 312 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '56' | 1 | 0 ms |
| 313 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '53' | 1 | 0 ms |
| 314 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/53' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 315 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '53' | 1 | 0 ms |
| 316 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '599' | 1 | 0 ms |
| 317 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/599' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 318 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '599' | 1 | 0 ms |
| 319 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10' | 1 | 0 ms |
| 320 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/10' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 321 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10' | 1 | 0 ms |
| 322 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/10' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 323 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10' ORDER BY `category_name` ASC | 2 | 0 ms |
| 324 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '59' | 1 | 0 ms |
| 325 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/59' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 326 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '59' | 1 | 0 ms |
| 327 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '58' | 1 | 0 ms |
| 328 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/58' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 329 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '58' | 1 | 0 ms |
| 330 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141' | 1 | 0 ms |
| 331 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/141' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 332 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141' | 1 | 0 ms |
| 333 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/141' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 334 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141' ORDER BY `category_name` ASC | 1 | 0 ms |
| 335 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '718' | 1 | 0 ms |
| 336 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/718' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 337 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '718' | 1 | 0 ms |
| 338 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11' | 1 | 0 ms |
| 339 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 340 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11' | 1 | 0 ms |
| 341 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 342 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11' ORDER BY `category_name` ASC | 19 | 0 ms |
| 343 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '239' | 1 | 0 ms |
| 344 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/239' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 345 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '239' | 1 | 0 ms |
| 346 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '63' | 1 | 0 ms |
| 347 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/63' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 348 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '63' | 1 | 0 ms |
| 349 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '255' | 1 | 0 ms |
| 350 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/255' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 351 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '255' | 1 | 0 ms |
| 352 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '265' | 1 | 0 ms |
| 353 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/265' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 354 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '265' | 1 | 0 ms |
| 355 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '314' | 1 | 0 ms |
| 356 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/314' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 357 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '314' | 1 | 0 ms |
| 358 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '719' | 1 | 0 ms |
| 359 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/719' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 360 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '719' | 1 | 0 ms |
| 361 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '62' | 1 | 0 ms |
| 362 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/62' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 363 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '62' | 1 | 0 ms |
| 364 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '178' | 1 | 0 ms |
| 365 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/178' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 366 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '178' | 1 | 0 ms |
| 367 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '61' | 1 | 0 ms |
| 368 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/61' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 369 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '61' | 1 | 0 ms |
| 370 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '728' | 1 | 0 ms |
| 371 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/728' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 372 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '728' | 1 | 0 ms |
| 373 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '725' | 1 | 0 ms |
| 374 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/725' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 375 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '725' | 1 | 0 ms |
| 376 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '705' | 1 | 0 ms |
| 377 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/705' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 378 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '705' | 1 | 0 ms |
| 379 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '252' | 1 | 0 ms |
| 380 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/252' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 381 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '252' | 1 | 0 ms |
| 382 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '60' | 1 | 0 ms |
| 383 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/60' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 384 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '60' | 1 | 0 ms |
| 385 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '412' | 1 | 0 ms |
| 386 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/412' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 387 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '412' | 1 | 0 ms |
| 388 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '460' | 1 | 0 ms |
| 389 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/460' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 390 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '460' | 1 | 0 ms |
| 391 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '242' | 1 | 0 ms |
| 392 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/242' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 393 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '242' | 1 | 0 ms |
| 394 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '180' | 1 | 0 ms |
| 395 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/180' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 396 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '180' | 1 | 0 ms |
| 397 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '706' | 1 | 0 ms |
| 398 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/706' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 399 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '706' | 1 | 0 ms |
| 400 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142' | 1 | 0 ms |
| 401 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/142' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 402 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142' | 1 | 0 ms |
| 403 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/142' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 404 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142' ORDER BY `category_name` ASC | 11 | 0 ms |
| 405 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '306' | 1 | 0 ms |
| 406 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/306' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 407 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '306' | 1 | 0 ms |
| 408 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '246' | 1 | 0 ms |
| 409 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/246' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 410 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '246' | 1 | 0 ms |
| 411 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '325' | 1 | 0 ms |
| 412 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/325' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 413 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '325' | 1 | 0 ms |
| 414 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '302' | 1 | 0 ms |
| 415 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/302' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 416 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '302' | 1 | 0 ms |
| 417 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '237' | 1 | 0 ms |
| 418 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/237' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 419 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '237' | 1 | 0 ms |
| 420 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '254' | 1 | 0 ms |
| 421 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/254' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 422 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '254' | 1 | 0 ms |
| 423 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '232' | 1 | 0 ms |
| 424 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/232' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 425 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '232' | 1 | 0 ms |
| 426 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '241' | 1 | 0 ms |
| 427 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/241' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 428 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '241' | 1 | 0 ms |
| 429 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '236' | 1 | 0 ms |
| 430 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/236' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 431 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '236' | 1 | 0 ms |
| 432 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '301' | 1 | 0 ms |
| 433 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/301' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 434 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '301' | 1 | 0 ms |
| 435 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '300' | 1 | 0 ms |
| 436 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/300' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 437 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '300' | 1 | 0 ms |
| 438 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12' | 1 | 0 ms |
| 439 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/12' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 440 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12' | 1 | 0 ms |
| 441 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/12' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 442 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12' ORDER BY `category_name` ASC | 13 | 0 ms |
| 443 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '133' | 1 | 0 ms |
| 444 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/133' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 445 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '133' | 1 | 0 ms |
| 446 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '66' | 1 | 0 ms |
| 447 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/66' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 448 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '66' | 1 | 0 ms |
| 449 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '259' | 1 | 0 ms |
| 450 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/259' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 451 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '259' | 1 | 0 ms |
| 452 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '163' | 1 | 0 ms |
| 453 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/163' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 454 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '163' | 1 | 0 ms |
| 455 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '130' | 1 | 0 ms |
| 456 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/130' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 457 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '130' | 1 | 0 ms |
| 458 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '65' | 1 | 0 ms |
| 459 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/65' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 460 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '65' | 1 | 0 ms |
| 461 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '120' | 1 | 0 ms |
| 462 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/120' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 463 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '120' | 1 | 0 ms |
| 464 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '164' | 1 | 0 ms |
| 465 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/164' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 466 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '164' | 1 | 0 ms |
| 467 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '131' | 1 | 0 ms |
| 468 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/131' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 469 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '131' | 1 | 0 ms |
| 470 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '129' | 1 | 0 ms |
| 471 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/129' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 472 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '129' | 1 | 0 ms |
| 473 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '128' | 1 | 0 ms |
| 474 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/128' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 475 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '128' | 1 | 0 ms |
| 476 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '165' | 1 | 0 ms |
| 477 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/165' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 478 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '165' | 1 | 0 ms |
| 479 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '64' | 1 | 0 ms |
| 480 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/64' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 481 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '64' | 1 | 0 ms |
| 482 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13' | 1 | 0 ms |
| 483 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/13' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 484 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13' | 1 | 0 ms |
| 485 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/13' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 486 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13' ORDER BY `category_name` ASC | 14 | 0 ms |
| 487 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '168' | 1 | 0 ms |
| 488 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/168' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 489 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '168' | 1 | 0 ms |
| 490 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '352' | 1 | 0 ms |
| 491 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/352' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 492 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '352' | 1 | 0 ms |
| 493 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '307' | 1 | 0 ms |
| 494 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/307' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 495 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '307' | 1 | 0 ms |
| 496 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '67' | 1 | 0 ms |
| 497 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/67' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 498 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '67' | 1 | 0 ms |
| 499 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '167' | 1 | 0 ms |
| 500 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/167' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 501 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '167' | 1 | 0 ms |
| 502 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '303' | 1 | 0 ms |
| 503 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/303' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 504 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '303' | 1 | 0 ms |
| 505 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '249' | 1 | 0 ms |
| 506 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/249' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 507 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '249' | 1 | 0 ms |
| 508 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '330' | 1 | 0 ms |
| 509 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/330' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 510 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '330' | 1 | 0 ms |
| 511 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '68' | 1 | 0 ms |
| 512 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/68' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 513 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '68' | 1 | 0 ms |
| 514 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '630' | 1 | 0 ms |
| 515 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/630' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 516 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '630' | 1 | 0 ms |
| 517 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '631' | 1 | 0 ms |
| 518 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/631' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 519 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '631' | 1 | 0 ms |
| 520 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '309' | 1 | 0 ms |
| 521 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/309' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 522 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '309' | 1 | 0 ms |
| 523 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '231' | 1 | 0 ms |
| 524 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/231' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 525 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '231' | 1 | 0 ms |
| 526 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '296' | 1 | 0 ms |
| 527 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/296' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 528 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '296' | 1 | 0 ms |
| 529 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604' | 1 | 0 ms |
| 530 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/604' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 531 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604' | 1 | 0 ms |
| 532 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/604' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 533 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604' ORDER BY `category_name` ASC | 5 | 0 ms |
| 534 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '606' | 1 | 0 ms |
| 535 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/606' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 536 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '606' | 1 | 0 ms |
| 537 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '632' | 1 | 0 ms |
| 538 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/632' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 539 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '632' | 1 | 0 ms |
| 540 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '605' | 1 | 0 ms |
| 541 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/605' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 542 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '605' | 1 | 0 ms |
| 543 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '607' | 1 | 0 ms |
| 544 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/607' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 545 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '607' | 1 | 0 ms |
| 546 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '710' | 1 | 0 ms |
| 547 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/710' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 548 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '710' | 1 | 0 ms |
| 549 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14' | 1 | 0 ms |
| 550 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/14' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 551 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14' | 1 | 0 ms |
| 552 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/14' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 553 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14' ORDER BY `category_name` ASC | 9 | 0 ms |
| 554 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '602' | 1 | 0 ms |
| 555 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/602' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 556 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '602' | 1 | 0 ms |
| 557 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '378' | 1 | 0 ms |
| 558 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/378' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 559 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '378' | 1 | 0 ms |
| 560 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '132' | 1 | 0 ms |
| 561 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/132' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 562 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '132' | 1 | 0 ms |
| 563 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '72' | 1 | 0 ms |
| 564 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/72' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 565 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '72' | 1 | 0 ms |
| 566 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '70' | 1 | 0 ms |
| 567 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/70' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 568 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '70' | 1 | 0 ms |
| 569 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '121' | 1 | 0 ms |
| 570 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/121' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 571 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '121' | 1 | 0 ms |
| 572 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '73' | 1 | 0 ms |
| 573 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/73' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 574 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '73' | 1 | 0 ms |
| 575 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '601' | 1 | 0 ms |
| 576 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/601' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 577 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '601' | 1 | 0 ms |
| 578 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '71' | 1 | 0 ms |
| 579 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/71' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 580 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '71' | 1 | 0 ms |
| 581 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407' | 1 | 0 ms |
| 582 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/407' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 583 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407' | 1 | 0 ms |
| 584 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/407' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 585 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407' ORDER BY `category_name` ASC | 1 | 0 ms |
| 586 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '447' | 1 | 0 ms |
| 587 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/447' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 588 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '447' | 1 | 0 ms |
| 589 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16' | 1 | 0 ms |
| 590 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/16' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 591 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16' | 1 | 0 ms |
| 592 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/16' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 593 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16' ORDER BY `category_name` ASC | 14 | 0 ms |
| 594 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '297' | 1 | 0 ms |
| 595 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/297' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 596 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '297' | 1 | 0 ms |
| 597 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '389' | 1 | 0 ms |
| 598 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/389' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 599 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '389' | 1 | 0 ms |
| 600 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '81' | 1 | 0 ms |
| 601 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/81' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 602 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '81' | 1 | 0 ms |
| 603 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '79' | 1 | 0 ms |
| 604 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/79' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 605 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '79' | 1 | 0 ms |
| 606 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '80' | 1 | 0 ms |
| 607 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/80' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 608 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '80' | 1 | 0 ms |
| 609 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '267' | 1 | 0 ms |
| 610 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/267' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 611 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '267' | 1 | 0 ms |
| 612 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '298' | 1 | 0 ms |
| 613 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/298' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 614 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '298' | 1 | 0 ms |
| 615 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '83' | 1 | 0 ms |
| 616 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/83' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 617 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '83' | 1 | 0 ms |
| 618 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '417' | 1 | 0 ms |
| 619 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/417' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 620 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '417' | 1 | 0 ms |
| 621 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '77' | 1 | 0 ms |
| 622 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/77' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 623 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '77' | 1 | 0 ms |
| 624 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '76' | 1 | 0 ms |
| 625 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/76' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 626 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '76' | 1 | 0 ms |
| 627 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '78' | 1 | 0 ms |
| 628 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/78' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 629 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '78' | 1 | 0 ms |
| 630 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '82' | 1 | 0 ms |
| 631 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/82' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 632 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '82' | 1 | 0 ms |
| 633 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '396' | 1 | 0 ms |
| 634 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/396' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 635 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '396' | 1 | 0 ms |
| 636 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15' | 1 | 0 ms |
| 637 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/15' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 638 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15' | 1 | 0 ms |
| 639 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/15' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 640 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15' ORDER BY `category_name` ASC | 2 | 0 ms |
| 641 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '74' | 1 | 0 ms |
| 642 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/74' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 643 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '74' | 1 | 0.01 ms |
| 644 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '75' | 1 | 0 ms |
| 645 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/75' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 646 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '75' | 1 | 0 ms |
| 647 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '233' | 1 | 0 ms |
| 648 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/233' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 649 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '233' | 1 | 0 ms |
| 650 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '153' | 1 | 0 ms |
| 651 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/153' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 652 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '153' | 1 | 0 ms |
| 653 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17' | 1 | 0 ms |
| 654 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/17' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 655 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17' | 1 | 0 ms |
| 656 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/17' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 657 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17' ORDER BY `category_name` ASC | 2 | 0 ms |
| 658 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '85' | 1 | 0 ms |
| 659 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/85' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 660 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '85' | 1 | 0 ms |
| 661 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '88' | 1 | 0 ms |
| 662 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/88' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 663 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '88' | 1 | 0 ms |
| 664 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21' | 1 | 0 ms |
| 665 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/21' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 666 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21' | 1 | 0 ms |
| 667 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/21' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 668 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21' ORDER BY `category_name` ASC | 6 | 0 ms |
| 669 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '98' | 1 | 0 ms |
| 670 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/98' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 671 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '98' | 1 | 0 ms |
| 672 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '96' | 1 | 0 ms |
| 673 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/96' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 674 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '96' | 1 | 0 ms |
| 675 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '146' | 1 | 0 ms |
| 676 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/146' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 677 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '146' | 1 | 0 ms |
| 678 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '101' | 1 | 0 ms |
| 679 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/101' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 680 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '101' | 1 | 0 ms |
| 681 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '100' | 1 | 0 ms |
| 682 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/100' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 683 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '100' | 1 | 0 ms |
| 684 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '97' | 1 | 0 ms |
| 685 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/97' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 686 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '97' | 1 | 0 ms |
| 687 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152' | 1 | 0 ms |
| 688 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/152' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 689 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152' | 1 | 0 ms |
| 690 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/152' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 691 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152' ORDER BY `category_name` ASC | 3 | 0 ms |
| 692 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '387' | 1 | 0 ms |
| 693 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/387' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 694 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '387' | 1 | 0 ms |
| 695 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '245' | 1 | 0 ms |
| 696 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/245' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 697 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '245' | 1 | 0 ms |
| 698 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '388' | 1 | 0 ms |
| 699 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/388' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 700 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '388' | 1 | 0 ms |
| 701 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19' | 1 | 0 ms |
| 702 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/19' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 703 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19' | 1 | 0 ms |
| 704 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/19' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 705 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19' ORDER BY `category_name` ASC | 4 | 0 ms |
| 706 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '124' | 1 | 0 ms |
| 707 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/124' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 708 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '124' | 1 | 0 ms |
| 709 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '127' | 1 | 0 ms |
| 710 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/127' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 711 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '127' | 1 | 0 ms |
| 712 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '126' | 1 | 0 ms |
| 713 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/126' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 714 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '126' | 1 | 0 ms |
| 715 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '125' | 1 | 0 ms |
| 716 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/125' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 717 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '125' | 1 | 0 ms |
| 718 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18' | 1 | 0 ms |
| 719 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/18' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 720 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18' | 1 | 0 ms |
| 721 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/18' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 722 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18' ORDER BY `category_name` ASC | 7 | 0 ms |
| 723 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '89' | 1 | 0 ms |
| 724 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/89' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 725 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '89' | 1 | 0 ms |
| 726 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '91' | 1 | 0 ms |
| 727 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/91' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 728 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '91' | 1 | 0 ms |
| 729 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '90' | 1 | 0 ms |
| 730 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/90' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 731 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '90' | 1 | 0 ms |
| 732 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '709' | 1 | 0 ms |
| 733 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/709' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 734 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '709' | 1 | 0 ms |
| 735 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '707' | 1 | 0 ms |
| 736 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/707' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 737 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '707' | 1 | 0 ms |
| 738 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '724' | 1 | 0 ms |
| 739 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/724' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 740 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '724' | 1 | 0 ms |
| 741 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '92' | 1 | 0 ms |
| 742 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/92' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 743 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '92' | 1 | 0 ms |
| 744 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713' | 1 | 0 ms |
| 745 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/713' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 746 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713' | 1 | 0 ms |
| 747 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713' ORDER BY `category_name` ASC | 2 | 0 ms |
| 748 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '715' | 1 | 0 ms |
| 749 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/715' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 750 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '715' | 1 | 0 ms |
| 751 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '714' | 1 | 0 ms |
| 752 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/714' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 753 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '714' | 1 | 0 ms |
| 754 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23' | 1 | 0 ms |
| 755 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/23' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 756 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23' | 1 | 0 ms |
| 757 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/23' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 758 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23' ORDER BY `category_name` ASC | 4 | 0 ms |
| 759 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '114' | 1 | 0 ms |
| 760 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/114' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 761 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '114' | 1 | 0 ms |
| 762 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '113' | 1 | 0 ms |
| 763 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/113' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 764 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '113' | 1 | 0 ms |
| 765 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '716' | 1 | 0 ms |
| 766 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/716' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 767 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '716' | 1 | 0 ms |
| 768 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '708' | 1 | 0 ms |
| 769 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/708' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0.01 ms |
| 770 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '708' | 1 | 0 ms |
| 771 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 772 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '0' | 1 | 0 ms |
| 773 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '0' ORDER BY `category_name` ASC | 39 | 0 ms |
| 774 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637' | 1 | 0 ms |
| 775 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/637' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 776 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637' | 1 | 0 ms |
| 777 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637' ORDER BY `category_name` ASC | 3 | 0 ms |
| 778 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '649' | 1 | 0 ms |
| 779 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/649' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 780 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '649' | 1 | 0 ms |
| 781 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '652' | 1 | 0 ms |
| 782 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/652' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 783 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '652' | 1 | 0 ms |
| 784 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '650' | 1 | 0 ms |
| 785 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/650' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 786 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '650' | 1 | 0 ms |
| 787 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '938' | 1 | 0 ms |
| 788 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/938' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 789 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '938' | 1 | 0 ms |
| 790 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702' | 1 | 0 ms |
| 791 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/702' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0.01 ms |
| 792 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702' | 1 | 0 ms |
| 793 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702' ORDER BY `category_name` ASC | 2 | 0 ms |
| 794 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '703' | 1 | 0 ms |
| 795 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/703' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 796 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '703' | 1 | 0 ms |
| 797 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '704' | 1 | 0 ms |
| 798 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/704' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 799 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '704' | 1 | 0 ms |
| 800 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638' | 1 | 0 ms |
| 801 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/638' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 802 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638' | 1 | 0 ms |
| 803 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638' ORDER BY `category_name` ASC | 6 | 0 ms |
| 804 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '919' | 1 | 0 ms |
| 805 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/919' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 806 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '919' | 1 | 0 ms |
| 807 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '653' | 1 | 0 ms |
| 808 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/653' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 809 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '653' | 1 | 0 ms |
| 810 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '651' | 1 | 0 ms |
| 811 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/651' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 812 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '651' | 1 | 0 ms |
| 813 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '654' | 1 | 0 ms |
| 814 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/654' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 815 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '654' | 1 | 0 ms |
| 816 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '916' | 1 | 0 ms |
| 817 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/916' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 818 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '916' | 1 | 0 ms |
| 819 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '915' | 1 | 0 ms |
| 820 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/915' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 821 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '915' | 1 | 0 ms |
| 822 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648' | 1 | 0 ms |
| 823 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/648' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 824 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648' | 1 | 0 ms |
| 825 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648' ORDER BY `category_name` ASC | 3 | 0 ms |
| 826 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '655' | 1 | 0 ms |
| 827 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/655' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 828 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '655' | 1 | 0 ms |
| 829 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '656' | 1 | 0 ms |
| 830 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/656' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 831 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '656' | 1 | 0 ms |
| 832 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '657' | 1 | 0 ms |
| 833 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/657' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 834 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '657' | 1 | 0 ms |
| 835 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641' | 1 | 0 ms |
| 836 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/641' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 837 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641' | 1 | 0 ms |
| 838 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641' ORDER BY `category_name` ASC | 3 | 0 ms |
| 839 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '659' | 1 | 0 ms |
| 840 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/659' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 841 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '659' | 1 | 0 ms |
| 842 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '660' | 1 | 0 ms |
| 843 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/660' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 844 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '660' | 1 | 0 ms |
| 845 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '658' | 1 | 0 ms |
| 846 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/658' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 847 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '658' | 1 | 0 ms |
| 848 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903' | 1 | 0 ms |
| 849 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/903' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 850 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903' | 1 | 0 ms |
| 851 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903' ORDER BY `category_name` ASC | 1 | 0 ms |
| 852 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '926' | 1 | 0 ms |
| 853 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/926' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 854 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '926' | 1 | 0 ms |
| 855 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647' | 1 | 0 ms |
| 856 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/647' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 857 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647' | 1 | 0 ms |
| 858 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647' ORDER BY `category_name` ASC | 3 | 0 ms |
| 859 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '663' | 1 | 0 ms |
| 860 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/663' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 861 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '663' | 1 | 0 ms |
| 862 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '662' | 1 | 0 ms |
| 863 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/662' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 864 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '662' | 1 | 0 ms |
| 865 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '664' | 1 | 0 ms |
| 866 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/664' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 867 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '664' | 1 | 0 ms |
| 868 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902' | 1 | 0 ms |
| 869 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/902' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 870 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902' | 1 | 0 ms |
| 871 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902' ORDER BY `category_name` ASC | 2 | 0 ms |
| 872 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '921' | 1 | 0 ms |
| 873 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/921' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 874 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '921' | 1 | 0 ms |
| 875 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '922' | 1 | 0 ms |
| 876 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/922' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 877 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '922' | 1 | 0 ms |
| 878 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640' | 1 | 0 ms |
| 879 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/640' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 880 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640' | 1 | 0 ms |
| 881 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640' ORDER BY `category_name` ASC | 5 | 0 ms |
| 882 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '667' | 1 | 0.01 ms |
| 883 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/667' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 884 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '667' | 1 | 0 ms |
| 885 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '884' | 1 | 0 ms |
| 886 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/884' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 887 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '884' | 1 | 0.01 ms |
| 888 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '666' | 1 | 0 ms |
| 889 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/666' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 890 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '666' | 1 | 0 ms |
| 891 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '665' | 1 | 0 ms |
| 892 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/665' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 893 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '665' | 1 | 0 ms |
| 894 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '917' | 1 | 0 ms |
| 895 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/917' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 896 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '917' | 1 | 0 ms |
| 897 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673' | 1 | 0 ms |
| 898 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/673' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 899 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673' | 1 | 0 ms |
| 900 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673' ORDER BY `category_name` ASC | 7 | 0 ms |
| 901 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '677' | 1 | 0 ms |
| 902 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/677' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 903 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '677' | 1 | 0 ms |
| 904 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '680' | 1 | 0 ms |
| 905 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/680' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 906 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '680' | 1 | 0 ms |
| 907 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '676' | 1 | 0 ms |
| 908 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/676' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 909 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '676' | 1 | 0 ms |
| 910 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '674' | 1 | 0.01 ms |
| 911 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/674' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 912 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '674' | 1 | 0 ms |
| 913 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '675' | 1 | 0 ms |
| 914 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/675' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 915 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '675' | 1 | 0 ms |
| 916 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '923' | 1 | 0 ms |
| 917 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/923' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 918 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '923' | 1 | 0 ms |
| 919 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '678' | 1 | 0 ms |
| 920 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/678' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 921 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '678' | 1 | 0 ms |
| 922 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '965' | 1 | 0 ms |
| 923 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/965' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 924 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '965' | 1 | 0 ms |
| 925 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '967' | 1 | 0 ms |
| 926 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/967' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 927 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '967' | 1 | 0 ms |
| 928 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '969' | 1 | 0 ms |
| 929 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/969' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 930 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '969' | 1 | 0 ms |
| 931 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '966' | 1 | 0 ms |
| 932 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/966' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 933 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '966' | 1 | 0 ms |
| 934 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '968' | 1 | 0 ms |
| 935 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/968' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 936 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '968' | 1 | 0 ms |
| 937 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '970' | 1 | 0 ms |
| 938 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/970' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 939 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '970' | 1 | 0 ms |
| 940 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '971' | 1 | 0 ms |
| 941 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/971' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 942 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '971' | 1 | 0 ms |
| 943 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '972' | 1 | 0 ms |
| 944 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/972' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 945 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '972' | 1 | 0 ms |
| 946 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '973' | 1 | 0 ms |
| 947 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/973' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 948 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '973' | 1 | 0 ms |
| 949 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '974' | 1 | 0 ms |
| 950 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/974' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 951 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '974' | 1 | 0 ms |
| 952 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '975' | 1 | 0 ms |
| 953 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/975' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 954 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '975' | 1 | 0 ms |
| 955 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693' | 1 | 0 ms |
| 956 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/693' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 957 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693' | 1 | 0 ms |
| 958 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693' ORDER BY `category_name` ASC | 2 | 0 ms |
| 959 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '695' | 1 | 0 ms |
| 960 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/695' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 961 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '695' | 1 | 0 ms |
| 962 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '694' | 1 | 0 ms |
| 963 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/694' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 964 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '694' | 1 | 0 ms |
| 965 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '936' | 1 | 0 ms |
| 966 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/936' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 967 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '936' | 1 | 0 ms |
| 968 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698' | 1 | 0 ms |
| 969 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/698' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 970 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698' | 1 | 0 ms |
| 971 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698' ORDER BY `category_name` ASC | 1 | 0 ms |
| 972 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '701' | 1 | 0 ms |
| 973 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/701' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 974 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '701' | 1 | 0 ms |
| 975 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642' | 1 | 0 ms |
| 976 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/642' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 977 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642' | 1 | 0 ms |
| 978 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642' ORDER BY `category_name` ASC | 5 | 0 ms |
| 979 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '671' | 1 | 0 ms |
| 980 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/671' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 981 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '671' | 1 | 0 ms |
| 982 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '670' | 1 | 0 ms |
| 983 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/670' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 984 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '670' | 1 | 0 ms |
| 985 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '669' | 1 | 0 ms |
| 986 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/669' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 987 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '669' | 1 | 0 ms |
| 988 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '668' | 1 | 0 ms |
| 989 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/668' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 990 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '668' | 1 | 0 ms |
| 991 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '672' | 1 | 0 ms |
| 992 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/672' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 993 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '672' | 1 | 0 ms |
| 994 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '944' | 1 | 0 ms |
| 995 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/944' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 996 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '944' | 1 | 0 ms |
| 997 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681' | 1 | 0.01 ms |
| 998 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/681' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 999 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681' | 1 | 0 ms |
| 1000 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681' ORDER BY `category_name` ASC | 5 | 0 ms |
| 1001 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '683' | 1 | 0 ms |
| 1002 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/683' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1003 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '683' | 1 | 0 ms |
| 1004 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '682' | 1 | 0 ms |
| 1005 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/682' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1006 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '682' | 1 | 0 ms |
| 1007 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '684' | 1 | 0 ms |
| 1008 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/684' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1009 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '684' | 1 | 0 ms |
| 1010 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '883' | 1 | 0 ms |
| 1011 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/883' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1012 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '883' | 1 | 0 ms |
| 1013 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '901' | 1 | 0 ms |
| 1014 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/901' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1015 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '901' | 1 | 0 ms |
| 1016 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '952' | 1 | 0 ms |
| 1017 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/952' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1018 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '952' | 1 | 0 ms |
| 1019 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720' | 1 | 0 ms |
| 1020 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/720' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1021 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720' | 1 | 0 ms |
| 1022 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720' ORDER BY `category_name` ASC | 3 | 0 ms |
| 1023 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '900' | 1 | 0 ms |
| 1024 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/900' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1025 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '900' | 1 | 0 ms |
| 1026 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '882' | 1 | 0 ms |
| 1027 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/882' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1028 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '882' | 1 | 0 ms |
| 1029 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '722' | 1 | 0 ms |
| 1030 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/722' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1031 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '722' | 1 | 0 ms |
| 1032 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '943' | 1 | 0 ms |
| 1033 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/943' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1034 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '943' | 1 | 0 ms |
| 1035 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906' | 1 | 0 ms |
| 1036 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/906' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1037 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906' | 1 | 0 ms |
| 1038 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906' ORDER BY `category_name` ASC | 5 | 0 ms |
| 1039 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '928' | 1 | 0 ms |
| 1040 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/928' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1041 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '928' | 1 | 0 ms |
| 1042 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '929' | 1 | 0 ms |
| 1043 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/929' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1044 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '929' | 1 | 0 ms |
| 1045 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '930' | 1 | 0 ms |
| 1046 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/930' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1047 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '930' | 1 | 0 ms |
| 1048 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '927' | 1 | 0 ms |
| 1049 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/927' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1050 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '927' | 1 | 0 ms |
| 1051 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '931' | 1 | 0 ms |
| 1052 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/931' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1053 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '931' | 1 | 0 ms |
| 1054 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696' | 1 | 0 ms |
| 1055 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/696' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1056 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696' | 1 | 0 ms |
| 1057 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696' ORDER BY `category_name` ASC | 3 | 0 ms |
| 1058 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '697' | 1 | 0 ms |
| 1059 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/697' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1060 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '697' | 1 | 0 ms |
| 1061 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '723' | 1 | 0 ms |
| 1062 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/723' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1063 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '723' | 1 | 0 ms |
| 1064 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '933' | 1 | 0 ms |
| 1065 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/933' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1066 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '933' | 1 | 0 ms |
| 1067 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646' | 1 | 0 ms |
| 1068 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/646' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1069 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646' | 1 | 0 ms |
| 1070 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646' ORDER BY `category_name` ASC | 4 | 0 ms |
| 1071 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '679' | 1 | 0 ms |
| 1072 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/679' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1073 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '679' | 1 | 0 ms |
| 1074 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '899' | 1 | 0 ms |
| 1075 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/899' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1076 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '899' | 1 | 0 ms |
| 1077 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '685' | 1 | 0 ms |
| 1078 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/685' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1079 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '685' | 1 | 0 ms |
| 1080 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '924' | 1 | 0 ms |
| 1081 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/924' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1082 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '924' | 1 | 0 ms |
| 1083 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643' | 1 | 0 ms |
| 1084 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/643' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1085 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643' | 1 | 0 ms |
| 1086 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643' ORDER BY `category_name` ASC | 4 | 0 ms |
| 1087 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '686' | 1 | 0 ms |
| 1088 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/686' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1089 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '686' | 1 | 0 ms |
| 1090 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '687' | 1 | 0 ms |
| 1091 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/687' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1092 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '687' | 1 | 0 ms |
| 1093 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '688' | 1 | 0 ms |
| 1094 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/688' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1095 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '688' | 1 | 0 ms |
| 1096 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '918' | 1 | 0 ms |
| 1097 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/918' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1098 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '918' | 1 | 0 ms |
| 1099 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905' | 1 | 0 ms |
| 1100 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/905' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1101 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905' | 1 | 0 ms |
| 1102 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905' ORDER BY `category_name` ASC | 2 | 0 ms |
| 1103 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '935' | 1 | 0 ms |
| 1104 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/935' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1105 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '935' | 1 | 0 ms |
| 1106 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '934' | 1 | 0 ms |
| 1107 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/934' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1108 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '934' | 1 | 0 ms |
| 1109 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907' | 1 | 0 ms |
| 1110 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/907' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1111 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907' | 1 | 0 ms |
| 1112 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907' ORDER BY `category_name` ASC | 1 | 0 ms |
| 1113 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '925' | 1 | 0 ms |
| 1114 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/925' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1115 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '925' | 1 | 0 ms |
| 1116 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '937' | 1 | 0 ms |
| 1117 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/937' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1118 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '937' | 1 | 0 ms |
| 1119 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644' | 1 | 0 ms |
| 1120 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/644' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1121 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644' | 1 | 0 ms |
| 1122 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644' ORDER BY `category_name` ASC | 2 | 0 ms |
| 1123 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '689' | 1 | 0 ms |
| 1124 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/689' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1125 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '689' | 1 | 0 ms |
| 1126 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '700' | 1 | 0 ms |
| 1127 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/700' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1128 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '700' | 1 | 0 ms |
| 1129 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1130 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '0' | 1 | 0 ms |
| 1131 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '0' ORDER BY `category_name` ASC | 2 | 0 ms |
| 1132 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618' | 1 | 0 ms |
| 1133 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/618' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1134 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618' | 1 | 0 ms |
| 1135 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618' ORDER BY `category_name` ASC | 11 | 0 ms |
| 1136 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '619' | 1 | 0 ms |
| 1137 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/619' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1138 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '619' | 1 | 0 ms |
| 1139 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '620' | 1 | 0 ms |
| 1140 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/620' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1141 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '620' | 1 | 0 ms |
| 1142 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '621' | 1 | 0 ms |
| 1143 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/621' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1144 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '621' | 1 | 0 ms |
| 1145 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '622' | 1 | 0 ms |
| 1146 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/622' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1147 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '622' | 1 | 0 ms |
| 1148 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '623' | 1 | 0 ms |
| 1149 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/623' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1150 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '623' | 1 | 0 ms |
| 1151 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '624' | 1 | 0 ms |
| 1152 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/624' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1153 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '624' | 1 | 0 ms |
| 1154 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '625' | 1 | 0 ms |
| 1155 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/625' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1156 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '625' | 1 | 0 ms |
| 1157 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '626' | 1 | 0 ms |
| 1158 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/626' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1159 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '626' | 1 | 0 ms |
| 1160 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '627' | 1 | 0 ms |
| 1161 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/627' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1162 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '627' | 1 | 0 ms |
| 1163 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '628' | 1 | 0 ms |
| 1164 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/628' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1165 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '628' | 1 | 0 ms |
| 1166 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '951' | 1 | 0 ms |
| 1167 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/951' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1168 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '951' | 1 | 0 ms |
| 1169 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584' | 1 | 0 ms |
| 1170 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/584' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1171 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584' | 1 | 0 ms |
| 1172 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584' ORDER BY `category_name` ASC | 20 | 0 ms |
| 1173 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '511' | 1 | 0 ms |
| 1174 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/511' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1175 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '511' | 1 | 0 ms |
| 1176 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '512' | 1 | 0 ms |
| 1177 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/512' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1178 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '512' | 1 | 0 ms |
| 1179 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '513' | 1 | 0 ms |
| 1180 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/513' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1181 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '513' | 1 | 0 ms |
| 1182 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '514' | 1 | 0 ms |
| 1183 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/514' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1184 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '514' | 1 | 0 ms |
| 1185 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '515' | 1 | 0 ms |
| 1186 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/515' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1187 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '515' | 1 | 0 ms |
| 1188 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '516' | 1 | 0 ms |
| 1189 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/516' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1190 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '516' | 1 | 0 ms |
| 1191 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '517' | 1 | 0 ms |
| 1192 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/517' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1193 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '517' | 1 | 0 ms |
| 1194 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '518' | 1 | 0 ms |
| 1195 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/518' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1196 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '518' | 1 | 0 ms |
| 1197 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '519' | 1 | 0 ms |
| 1198 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/519' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1199 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '519' | 1 | 0 ms |
| 1200 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '520' | 1 | 0 ms |
| 1201 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/520' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1202 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '520' | 1 | 0 ms |
| 1203 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '521' | 1 | 0 ms |
| 1204 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/521' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1205 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '521' | 1 | 0 ms |
| 1206 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '522' | 1 | 0 ms |
| 1207 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/522' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1208 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '522' | 1 | 0 ms |
| 1209 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '523' | 1 | 0 ms |
| 1210 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/523' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1211 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '523' | 1 | 0 ms |
| 1212 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '524' | 1 | 0 ms |
| 1213 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/524' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1214 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '524' | 1 | 0 ms |
| 1215 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '525' | 1 | 0 ms |
| 1216 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/525' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1217 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '525' | 1 | 0 ms |
| 1218 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '526' | 1 | 0 ms |
| 1219 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/526' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1220 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '526' | 1 | 0 ms |
| 1221 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '527' | 1 | 0 ms |
| 1222 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/527' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1223 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '527' | 1 | 0 ms |
| 1224 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '528' | 1 | 0 ms |
| 1225 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/528' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1226 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '528' | 1 | 0 ms |
| 1227 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '529' | 1 | 0 ms |
| 1228 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/529' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1229 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '529' | 1 | 0 ms |
| 1230 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '950' | 1 | 0 ms |
| 1231 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/950' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1232 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '950' | 1 | 0 ms |
| 1233 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1234 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '0' | 1 | 0 ms |
| 1235 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '0' ORDER BY `category_name` ASC | 6 | 0 ms |
| 1236 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889' | 1 | 0 ms |
| 1237 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/889' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1238 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889' | 1 | 0 ms |
| 1239 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889' ORDER BY `category_name` ASC | 9 | 0 ms |
| 1240 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '890' | 1 | 0 ms |
| 1241 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/890' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1242 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '890' | 1 | 0 ms |
| 1243 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '891' | 1 | 0 ms |
| 1244 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/891' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1245 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '891' | 1 | 0 ms |
| 1246 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '893' | 1 | 0 ms |
| 1247 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/893' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1248 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '893' | 1 | 0 ms |
| 1249 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '892' | 1 | 0 ms |
| 1250 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/892' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1251 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '892' | 1 | 0 ms |
| 1252 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '896' | 1 | 0 ms |
| 1253 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/896' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1254 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '896' | 1 | 0 ms |
| 1255 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '894' | 1 | 0 ms |
| 1256 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/894' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1257 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '894' | 1 | 0 ms |
| 1258 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '898' | 1 | 0 ms |
| 1259 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/898' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1260 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '898' | 1 | 0 ms |
| 1261 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '895' | 1 | 0 ms |
| 1262 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/895' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1263 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '895' | 1 | 0 ms |
| 1264 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '897' | 1 | 0 ms |
| 1265 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/897' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1266 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '897' | 1 | 0 ms |
| 1267 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444' | 1 | 0 ms |
| 1268 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/444' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1269 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444' | 1 | 0 ms |
| 1270 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444' ORDER BY `category_name` ASC | 1 | 0 ms |
| 1271 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '911' | 1 | 0 ms |
| 1272 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/911' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1273 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '911' | 1 | 0 ms |
| 1274 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947' | 1 | 0 ms |
| 1275 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/947' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1276 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947' | 1 | 0 ms |
| 1277 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947' ORDER BY `category_name` ASC | 1 | 0 ms |
| 1278 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '949' | 1 | 0 ms |
| 1279 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/949' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1280 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '949' | 1 | 0 ms |
| 1281 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611' | 1 | 0 ms |
| 1282 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/611' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1283 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611' | 1 | 0 ms |
| 1284 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611' ORDER BY `category_name` ASC | 5 | 0 ms |
| 1285 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '613' | 1 | 0 ms |
| 1286 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/613' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1287 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '613' | 1 | 0 ms |
| 1288 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '614' | 1 | 0 ms |
| 1289 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/614' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1290 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '614' | 1 | 0 ms |
| 1291 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '615' | 1 | 0 ms |
| 1292 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/615' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1293 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '615' | 1 | 0 ms |
| 1294 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '617' | 1 | 0 ms |
| 1295 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/617' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1296 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '617' | 1 | 0 ms |
| 1297 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '616' | 1 | 0 ms |
| 1298 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/616' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1299 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '616' | 1 | 0 ms |
| 1300 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '446' | 1 | 0 ms |
| 1301 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/446' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1302 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '446' | 1 | 0 ms |
| 1303 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908' | 1 | 0 ms |
| 1304 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/908' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1305 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908' | 1 | 0 ms |
| 1306 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908' ORDER BY `category_name` ASC | 1 | 0 ms |
| 1307 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '910' | 1 | 0 ms |
| 1308 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/910' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1309 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '910' | 1 | 0 ms |
| 1310 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/9' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1311 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '9' AND `parent` = '0' | 1 | 0 ms |
| 1312 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1313 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '0' | 1 | 0 ms |
| 1314 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '0' ORDER BY `category_name` ASC | 15 | 0 ms |
| 1315 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '497' | 1 | 0 ms |
| 1316 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/497' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1317 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '497' | 1 | 0 ms |
| 1318 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '498' | 1 | 0 ms |
| 1319 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/498' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1320 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '498' | 1 | 0 ms |
| 1321 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '499' | 1 | 0 ms |
| 1322 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/499' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1323 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '499' | 1 | 0 ms |
| 1324 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '500' | 1 | 0 ms |
| 1325 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/500' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1326 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '500' | 1 | 0 ms |
| 1327 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '501' | 1 | 0 ms |
| 1328 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/501' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1329 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '501' | 1 | 0 ms |
| 1330 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '502' | 1 | 0 ms |
| 1331 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/502' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1332 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '502' | 1 | 0 ms |
| 1333 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '503' | 1 | 0 ms |
| 1334 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/503' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1335 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '503' | 1 | 0 ms |
| 1336 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '504' | 1 | 0 ms |
| 1337 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/504' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1338 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '504' | 1 | 0 ms |
| 1339 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '505' | 1 | 0 ms |
| 1340 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/505' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1341 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '505' | 1 | 0 ms |
| 1342 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '506' | 1 | 0 ms |
| 1343 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/506' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1344 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '506' | 1 | 0 ms |
| 1345 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '507' | 1 | 0 ms |
| 1346 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/507' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1347 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '507' | 1 | 0 ms |
| 1348 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '608' | 1 | 0 ms |
| 1349 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/608' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1350 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '608' | 1 | 0 ms |
| 1351 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '508' | 1 | 0 ms |
| 1352 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/508' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1353 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '508' | 1 | 0 ms |
| 1354 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '509' | 1 | 0 ms |
| 1355 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/509' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1356 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '509' | 1 | 0 ms |
| 1357 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '510' | 1 | 0 ms |
| 1358 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/510' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1359 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '510' | 1 | 0 ms |
| 1360 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/13' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1361 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '0' | 1 | 0 ms |
| 1362 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '0' ORDER BY `category_name` ASC | 1 | 0 ms |
| 1363 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945' | 1 | 0 ms |
| 1364 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/945' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1365 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945' | 1 | 0 ms |
| 1366 | SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945' ORDER BY `category_name` ASC | 1 | 0 ms |
| 1367 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '948' | 1 | 0 ms |
| 1368 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/948' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1369 | SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '948' | 1 | 0 ms |
| 1370 | SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/online-kunst-bestellen/decoratief' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 0 | 0 ms |
| 1371 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/ingelijste-kunst' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1372 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1373 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/veilig-en-betrouwbaar' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1374 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1375 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/search/simple' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1376 | SELECT `` as `ArtistBiography.` FROM `artist_biographies` AS `ArtistBiography` WHERE LENGTH(`artist_first`) > 0 AND LENGTH(`artist_last`) > 0 AND `language` = '1' ORDER BY `artist_last`, `artist_first` | ||
| 1377 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1378 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1379 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/customupload' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1380 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/1' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0.04 ms |
| 1381 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1382 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1383 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/static_frames' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1384 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/index' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1385 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1386 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1387 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/customupload' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1388 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/giftcards' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1389 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/over-ons' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1390 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/in-de-media' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1391 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/assortiment' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1392 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1393 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/veelgestelde-vragen' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1394 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/bestellen-verzenden-retourneren' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1395 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/retour' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1396 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/betaling' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1397 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/aanleverspecificaties' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1398 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/bedrijven' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1399 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/onze-klanten' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1400 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/algemene-voorwaarden' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
| 1401 | SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/privacy-policy' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 | 1 | 0 ms |
