Toon submenu

Tropisch (posters)

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 Tropisch (posters). Wanneer u de posters welke u zoekt niet kunt vinden, kunt u gebruik maken van onze uitgebreide zoekfunctie.

Pagina 1 van 5

volgende pagina »

1 • 2 • 3 • 4 • 5

Posters

Decoratief& Still...

Keith Mallett

50 x 50 cm

Nu: € 35,02

Inlijsten

Toevoegen aan favorietenlijst

Posters

Teardrop By The Ocean

Gary Whinn

50 x 50 cm

Nu: € 39,93

Inlijsten

Toevoegen aan favorietenlijst

Posters

Island Breeze

Chris Simpson

50 x 40 cm

Nu: € 33,28

Inlijsten

Toevoegen aan favorietenlijst

Posters

Palm Trees II

Mel Patrick

56 x 71 cm

Nu: € 66,55

Inlijsten

Toevoegen aan favorietenlijst

Posters

Beach and Jetty w...

Tom Mackie

95 x 33 cm

Verkrijgbaar in andere afmetingen!

Nu: € 23,50

Inlijsten

Toevoegen aan favorietenlijst

Posters

Les terrasses d'Ajaccio

Anne-Marie Grossi

30 x 30 cm

Verkrijgbaar in andere afmetingen!

Nu: € 8,05

Inlijsten

Toevoegen aan favorietenlijst

Posters

Palmiers

Laurent Pinsard

95 x 33 cm

Verkrijgbaar in andere afmetingen!

Nu: € 24,45

Inlijsten

Toevoegen aan favorietenlijst

Posters

Caribbean Comfort

Bill Saunders

100 x 70 cm

Nu: € 48,99

Inlijsten

Toevoegen aan favorietenlijst

Posters

Moorish Buildings...

Adolphe Balfourier

84 x 63 cm

Nu: € 45,25

Inlijsten

Toevoegen aan favorietenlijst

Posters

Sentier maritime

Veronique Vadon

80 x 60 cm

Verkrijgbaar in andere afmetingen!

Nu: € 30,52

Inlijsten

Toevoegen aan favorietenlijst

Posters

Paradisimo II

Jen Kirstein

60 x 90 cm

Nu: € 66,55

Inlijsten

Toevoegen aan favorietenlijst

Posters

Mer d'huile

Roger Keiflin

30 x 24 cm

Verkrijgbaar in andere afmetingen!

Nu: € 5,02

Inlijsten

Toevoegen aan favorietenlijst

Posters

Tres Barcas

Didier Lourenço

70 x 100 cm

Nu: € 52,44

Inlijsten

Toevoegen aan favorietenlijst

Posters

Tahitian Sunset I

John Douglas

20 x 50 cm

Verkrijgbaar in andere afmetingen!

Nu: € 26,62

Inlijsten

Toevoegen aan favorietenlijst

Posters

Baby Elephant

Sophie Harding

20 x 25 cm

Nu: € 11,98

Inlijsten

Toevoegen aan favorietenlijst

Posters

Olivier V

Marthe

30 x 30 cm

Verkrijgbaar in andere afmetingen!

Nu: € 10,42

Inlijsten

Toevoegen aan favorietenlijst

Posters

Hollywood

Mary Anne James

30 x 91 cm

Nu: € 22,77

Inlijsten

Toevoegen aan favorietenlijst

Posters

Tahitian Sunset II

John Douglas

20 x 50 cm

Verkrijgbaar in andere afmetingen!

Nu: € 26,62

Inlijsten

Toevoegen aan favorietenlijst

Posters

Bamboo's Calm

Katsumi Sugita

30 x 61 cm

Nu: € 23,87

Inlijsten

Toevoegen aan favorietenlijst

Posters

Tall Palms I

Mark Pulliam

56 x 76 cm

Verkrijgbaar in andere afmetingen!

Nu: € 45,39

Inlijsten

Toevoegen aan favorietenlijst

Posters

Villa Antiqua I

Joel Giovanni

81 x 60 cm

Nu: € 66,55

Inlijsten

Toevoegen aan favorietenlijst

Posters

Banana Leaves

Clair Kelly

100 x 41 cm

Nu: € 38,16

Inlijsten

Toevoegen aan favorietenlijst

Posters

Raw Perfume

Sarah Caswell

122 x 40 cm

Nu: € 66,55

Inlijsten

Toevoegen aan favorietenlijst

Posters

Livistona Australis

Anonymous

34 x 46 cm

Nu: € 33,28

Inlijsten

Toevoegen aan favorietenlijst

Posters

Neon Palm I

Liz Jardine

51 x 56 cm

Verkrijgbaar in andere afmetingen!

Nu: € 23,87

Inlijsten

Toevoegen aan favorietenlijst

Posters

Seabreeze

Bill Saunders

80 x 60 cm

Nu: € 42,40

Inlijsten

Toevoegen aan favorietenlijst

Posters

A l'ombre des pins

Veronique Vadon

60 x 80 cm

Nu: € 30,52

Inlijsten

Toevoegen aan favorietenlijst

Posters

Fuentes y Jardines

Jose Luis Castrillo

89 x 112 cm

Verkrijgbaar in andere afmetingen!

Nu: € 76,31

Inlijsten

Toevoegen aan favorietenlijst

Posters

Modern Bamboo I

Don Li-Leger

70 x 70 cm

Nu: € 42,40

Inlijsten

Toevoegen aan favorietenlijst

Posters

Tropical Isle II

John Douglas

60 x 60 cm

Verkrijgbaar in andere afmetingen!

Nu: € 66,55

Inlijsten

Toevoegen aan favorietenlijst

Posters

Palm Frond Triptych II

Bill Philip

90 x 30 cm

Nu: € 45,25

Inlijsten

Toevoegen aan favorietenlijst

Posters

Jungle Growth Chart

Sophie Harding

30 x 122 cm

Nu: € 53,24

Inlijsten

Toevoegen aan favorietenlijst

Posters

Bonaire II

John Douglas

40 x 50 cm

Nu: € 42,59

Inlijsten

Toevoegen aan favorietenlijst

Posters

Sunset Beach II

Keith Mallett

70 x 70 cm

Nu: € 42,40

Inlijsten

Toevoegen aan favorietenlijst

Posters

Sunburst Blossoms

Yvette St. Amant

57 x 99 cm

Nu: € 48,99

Inlijsten

Toevoegen aan favorietenlijst

Posters

Palm Vista

Haibin

106 x 86 cm

Verkrijgbaar in andere afmetingen!

Nu: € 81,70

Inlijsten

Toevoegen aan favorietenlijst

Posters

Baby Tiger

Sophie Harding

20 x 25 cm

Nu: € 11,98

Inlijsten

Toevoegen aan favorietenlijst

Posters

Still Waters II

Williams

90 x 60 cm

Nu: € 66,55

Inlijsten

Toevoegen aan favorietenlijst

Posters

Villa Antiqua II

Joel Giovanni

81 x 60 cm

Nu: € 66,55

Inlijsten

Toevoegen aan favorietenlijst

Posters

Vistas al Hoyo

Didier Lourenço

81 x 69 cm

Verkrijgbaar in andere afmetingen!

Nu: € 45,39

Inlijsten

Toevoegen aan favorietenlijst

Posters

Wealth of Flowers II

Willem Haenraets

70 x 70 cm

Verkrijgbaar in andere afmetingen!

Normaal: € 40,57

Nu: € 34,49

Inlijsten

Toevoegen aan favorietenlijst

Posters

Barques de pêche...

Jean-Claude Quilici

80 x 60 cm

Verkrijgbaar in andere afmetingen!

Nu: € 30,52

Inlijsten

Toevoegen aan favorietenlijst

Posters

Equatorial Breeze I

Toby Sandland

25 x 55 cm

Nu: € 23,87

Inlijsten

Toevoegen aan favorietenlijst

Posters

Interior of the P...

Karl Blechen

70 x 70 cm

Nu: € 53,24

Inlijsten

Toevoegen aan favorietenlijst

Posters

Bolsa con Palos

Didier Lourenço

81 x 69 cm

Verkrijgbaar in andere afmetingen!

Nu: € 45,39

Inlijsten

Toevoegen aan favorietenlijst

Posters

Island Hopping

Dan Mackin

147 x 60 cm

Verkrijgbaar in andere afmetingen!

Nu: € 83,41

Inlijsten

Toevoegen aan favorietenlijst

Posters

Raratonga I

Peter Adams

70 x 50 cm

Nu: € 42,59

Inlijsten

Toevoegen aan favorietenlijst

Posters

Nice

E. De Hey

40 x 50 cm

Verkrijgbaar in andere afmetingen!

Nu: € 33,28

Inlijsten

Toevoegen aan favorietenlijst

Pagina 1 van 5

volgende pagina »

1 • 2 • 3 • 4 • 5

Producten per pagina: 12 24 48 100

	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` = '/posters/bloemen-planten/tropisch' AND `language` = '1'	1	0 ms
7	SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/posters/bloemen-planten/tropisch' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
8	SELECT `id` as `Configuration.Id`, `value` as `Configuration.Value` FROM `configurations` AS `Configuration`	15	0 ms
9	DELETE FROM `discount_codes` WHERE `valid_till` < 1765391628	0	0 ms
10	SELECT `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `id` = '31' ORDER BY `category_name` ASC LIMIT 1	1	0 ms
11	SELECT `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `id` = '31' ORDER BY `category_name` ASC LIMIT 1	1	0 ms
12	DESCRIBE `product_categories`	4	0.01 ms
13	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` = '31' ORDER BY `category_name` ASC LIMIT 1	1	0 ms
14	SELECT `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` WHERE `product_type_id` = '1' ORDER BY `menu_order` ASC LIMIT 1	1	0.02 ms
15	SELECT `id` as `Translation.Id`, `value` as `Translation.Value` FROM `translations` AS `Translation` WHERE `language` = '1'	32	0.11 ms
16	SELECT `reference` as `ProductLimitedEdition.Reference`, `circulation` as `ProductLimitedEdition.Circulation` FROM `product_limited_editions` AS `ProductLimitedEdition`	208	0 ms
17	SELECT `id` as `ProductCategory.Id`, `id` as `ProductCategory.Id` FROM `product_categories` AS `ProductCategory` WHERE `parent` = '31'	0	0 ms
18	SELECT `product` as `ProductInCategory.Product`, `category` as `ProductInCategory.Category`, `product` as `ProductInCategory.Product` FROM `products_in_categories` AS `ProductInCategory` WHERE `category` IN(31,-1)	368	0.01 ms
19	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `id` IN(1219,1220,1221,1222,1302,1303,1352,1353,1396,1397,1475,1476,1676,1677,1755,1756,2029,2030,2057,2117,2145,2179,2183,2184,2185,2277,2304,2319,2387,2388,2429,2430,2431,2432,2622,2831,2832,2859,2860,2891,2892,2893,2894,3538,3544,3560,3562,3828,3830,3832,3954,3993,3994,3995,3996,3997,3998,3999,4000,4001,4002,4003,4004,4005,4006,4007,4008,4010,5491,5492,5791,6124,6190,6218,6417,6517,6518,6550,6632,6633,6675,6677,6741,6888,6894,6900,6908,6910,6912,6915,6916,6919,6920,6923,6924,6928,6932,6953,6956,6959,6960,6961,6962,6974,6975,6982,6983,7110,7111,7112,7113,11812,11845,11846,11852,11854,12070,12167,16197,16208,16340,16341,16398,16426,16427,18061,18262,20945,20985,21055,21056,21124,21160,21161,21162,21163,21433,21435,21436,21449,21450,21489,22959,23340,23341,23342,23729,23730,23731,23732,23903,24071,24242,24429,24430,24786,24787,24965,25020,25043,25073,25076,25125,25196,25197,25219,25333,25472,25492,25493,25675,25727,25731,25770,25771,25791,25871,25905,26149,26178,26179,26186,26187,26440,26515,26530,26558,26559,26574,26575,26598,26599,26600,26601,26632,26633,26698,26699,26758,26759,26778,26779,26787,26792,26793,26813,26814,26825,26826,26950,26951,26966,26967,26982,27040,27041,27051,27052,27077,27078,27102,27103,27108,27109,27114,27115,27146,27172,27194,27195,27208,27209,27231,27232,27234,30919,30922,30940,30941,31251,31252,31276,31311,31312,31313,31331,31332,31457,31458,31540,31605,31656,31657,31663,31664,31677,31752,31753,31876,31975,31979,32003,32093,35843,35865,35928,36978,37113,37138,37237,37297,37298,37312,37425,37426,37427,37428,37478,40393,41969,42026,42027,42073,42074,42081,42082,42173,42174,42176,42369,42414,42436,42437,43261,43285,43340,43366,43367,43502,43784,43802,43803,43826,44012,45198,45403,45409,45410,45413,45435,45436,46492,46493,46494,46605,46633,46635,46654,46686,46726,46763,46833,46857,46940,46943,46968,47017,47036,47051,47052,47091,51399,51714,51962,52127,52129,52154,52177,52411,52412,52548,52647,52845,53074,53156,53207,53303,53308,53323,53390,53391,53457,54052,54088,54092,54190,54191,54208,54216,55508,55900,91072,91378,91784,94183,98429,225513,343558) AND `deleted` = 0 AND `tagged` = 1 AND `file_exists` = 1	1	0.1 ms
20	SELECT `id` as `ProductCategory.Id`, `id` as `ProductCategory.Id` FROM `product_categories` AS `ProductCategory` WHERE `parent` = '31'	0	0 ms
21	SELECT `product` as `ProductInCategory.Product`, `category` as `ProductInCategory.Category`, `product` as `ProductInCategory.Product` FROM `products_in_categories` AS `ProductInCategory` WHERE `category` IN(31,-1)	368	0.01 ms
22	DESCRIBE `products`	33	0.01 ms
23	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(1219,1220,1221,1222,1302,1303,1352,1353,1396,1397,1475,1476,1676,1677,1755,1756,2029,2030,2057,2117,2145,2179,2183,2184,2185,2277,2304,2319,2387,2388,2429,2430,2431,2432,2622,2831,2832,2859,2860,2891,2892,2893,2894,3538,3544,3560,3562,3828,3830,3832,3954,3993,3994,3995,3996,3997,3998,3999,4000,4001,4002,4003,4004,4005,4006,4007,4008,4010,5491,5492,5791,6124,6190,6218,6417,6517,6518,6550,6632,6633,6675,6677,6741,6888,6894,6900,6908,6910,6912,6915,6916,6919,6920,6923,6924,6928,6932,6953,6956,6959,6960,6961,6962,6974,6975,6982,6983,7110,7111,7112,7113,11812,11845,11846,11852,11854,12070,12167,16197,16208,16340,16341,16398,16426,16427,18061,18262,20945,20985,21055,21056,21124,21160,21161,21162,21163,21433,21435,21436,21449,21450,21489,22959,23340,23341,23342,23729,23730,23731,23732,23903,24071,24242,24429,24430,24786,24787,24965,25020,25043,25073,25076,25125,25196,25197,25219,25333,25472,25492,25493,25675,25727,25731,25770,25771,25791,25871,25905,26149,26178,26179,26186,26187,26440,26515,26530,26558,26559,26574,26575,26598,26599,26600,26601,26632,26633,26698,26699,26758,26759,26778,26779,26787,26792,26793,26813,26814,26825,26826,26950,26951,26966,26967,26982,27040,27041,27051,27052,27077,27078,27102,27103,27108,27109,27114,27115,27146,27172,27194,27195,27208,27209,27231,27232,27234,30919,30922,30940,30941,31251,31252,31276,31311,31312,31313,31331,31332,31457,31458,31540,31605,31656,31657,31663,31664,31677,31752,31753,31876,31975,31979,32003,32093,35843,35865,35928,36978,37113,37138,37237,37297,37298,37312,37425,37426,37427,37428,37478,40393,41969,42026,42027,42073,42074,42081,42082,42173,42174,42176,42369,42414,42436,42437,43261,43285,43340,43366,43367,43502,43784,43802,43803,43826,44012,45198,45403,45409,45410,45413,45435,45436,46492,46493,46494,46605,46633,46635,46654,46686,46726,46763,46833,46857,46940,46943,46968,47017,47036,47051,47052,47091,51399,51714,51962,52127,52129,52154,52177,52411,52412,52548,52647,52845,53074,53156,53207,53303,53308,53323,53390,53391,53457,54052,54088,54092,54190,54191,54208,54216,55508,55900,91072,91378,91784,94183,98429,225513,343558) AND `deleted` = 0 AND `tagged` = 1 AND `file_exists` = 1 ORDER BY `order` ASC LIMIT 0, 48	48	0.11 ms
24	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
25	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
26	SELECT `id` as `ProductOn.Id`, `value` as `ProductOn.Value` FROM `product_on` AS `ProductOn`	15	0 ms
27	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = ' Keith' AND `artist_last` = 'Mallett' AND `deleted` = '0' AND `title` = 'Decoratief& Still Life Nine Patch'	1	0.01 ms
28	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Gary' AND `artist_last` = 'Whinn' AND `deleted` = '0' AND `title` = 'Teardrop By The Ocean'	1	0 ms
29	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Chris' AND `artist_last` = 'Simpson' AND `deleted` = '0' AND `title` = 'Island Breeze'	1	0.01 ms
30	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Mel' AND `artist_last` = 'Patrick' AND `deleted` = '0' AND `title` = 'Palm Trees II'	1	0.01 ms
31	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Tom' AND `artist_last` = 'Mackie' AND `deleted` = '0' AND `title` = 'Beach and Jetty with Boat'	1	0.01 ms
32	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Anne-Marie' AND `artist_last` = 'Grossi' AND `deleted` = '0' AND `title` = 'Les terrasses d\'Ajaccio'	1	0.01 ms
33	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Laurent' AND `artist_last` = 'Pinsard' AND `deleted` = '0' AND `title` = 'Palmiers'	1	0.02 ms
34	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = ' Bill' AND `artist_last` = 'Saunders' AND `deleted` = '0' AND `title` = 'Caribbean Comfort'	1	0.01 ms
35	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Adolphe' AND `artist_last` = 'Balfourier' AND `deleted` = '0' AND `title` = 'Moorish Buildings At Elche, Spain'	1	0.01 ms
36	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Veronique' AND `artist_last` = 'Vadon' AND `deleted` = '0' AND `title` = 'Sentier maritime'	1	0.01 ms
37	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Jen' AND `artist_last` = 'Kirstein' AND `deleted` = '0' AND `title` = 'Paradisimo II'	1	0.01 ms
38	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Roger' AND `artist_last` = 'Keiflin' AND `deleted` = '0' AND `title` = 'Mer d\'huile'	1	0.01 ms
39	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Didier' AND `artist_last` = 'Louren�o' AND `deleted` = '0' AND `title` = 'Tres Barcas'	1	0.01 ms
40	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'John' AND `artist_last` = 'Douglas' AND `deleted` = '0' AND `title` = 'Tahitian Sunset I'	1	0.01 ms
41	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Sophie' AND `artist_last` = 'Harding' AND `deleted` = '0' AND `title` = 'Baby Elephant'	1	0.01 ms
42	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = '' AND `artist_last` = 'Marthe' AND `deleted` = '0' AND `title` = 'Olivier V'	1	0.02 ms
43	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = ' Mary Anne' AND `artist_last` = 'James' AND `deleted` = '0' AND `title` = 'Hollywood'	1	0.01 ms
44	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'John' AND `artist_last` = 'Douglas' AND `deleted` = '0' AND `title` = 'Tahitian Sunset II'	1	0 ms
45	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Katsumi' AND `artist_last` = 'Sugita' AND `deleted` = '0' AND `title` = 'Bamboo\'s Calm'	1	0.01 ms
46	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Mark' AND `artist_last` = 'Pulliam' AND `deleted` = '0' AND `title` = 'Tall Palms I'	1	0.01 ms
47	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Joel' AND `artist_last` = 'Giovanni' AND `deleted` = '0' AND `title` = 'Villa Antiqua I'	1	0 ms
48	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Clair' AND `artist_last` = 'Kelly' AND `deleted` = '0' AND `title` = 'Banana Leaves'	1	0.02 ms
49	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Sarah' AND `artist_last` = 'Caswell' AND `deleted` = '0' AND `title` = 'Raw Perfume'	1	0.02 ms
50	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = '' AND `artist_last` = 'Anonymous' AND `deleted` = '0' AND `title` = 'Livistona Australis'	1	0.01 ms
51	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Liz' AND `artist_last` = 'Jardine' AND `deleted` = '0' AND `title` = 'Neon Palm I'	1	0.01 ms
52	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = ' Bill' AND `artist_last` = 'Saunders' AND `deleted` = '0' AND `title` = 'Seabreeze'	1	0 ms
53	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Veronique' AND `artist_last` = 'Vadon' AND `deleted` = '0' AND `title` = 'A l\'ombre des pins'	1	0 ms
54	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Jose Luis' AND `artist_last` = 'Castrillo' AND `deleted` = '0' AND `title` = 'Fuentes y Jardines'	1	0.01 ms
55	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = ' Don' AND `artist_last` = 'Li-Leger' AND `deleted` = '0' AND `title` = 'Modern Bamboo I'	1	0.01 ms
56	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'John' AND `artist_last` = 'Douglas' AND `deleted` = '0' AND `title` = 'Tropical Isle II'	1	0.01 ms
57	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Bill' AND `artist_last` = 'Philip' AND `deleted` = '0' AND `title` = 'Palm Frond Triptych II'	1	0.01 ms
58	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Sophie' AND `artist_last` = 'Harding' AND `deleted` = '0' AND `title` = 'Jungle Growth Chart'	1	0 ms
59	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'John' AND `artist_last` = 'Douglas' AND `deleted` = '0' AND `title` = 'Bonaire II'	1	0 ms
60	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Keith' AND `artist_last` = 'Mallett' AND `deleted` = '0' AND `title` = 'Sunset Beach II'	1	0 ms
61	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = ' Yvette' AND `artist_last` = 'St. Amant' AND `deleted` = '0' AND `title` = 'Sunburst Blossoms'	1	0.01 ms
62	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = '' AND `artist_last` = 'Haibin' AND `deleted` = '0' AND `title` = 'Palm Vista'	1	0.01 ms
63	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Sophie' AND `artist_last` = 'Harding' AND `deleted` = '0' AND `title` = 'Baby Tiger'	1	0 ms
64	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = '' AND `artist_last` = 'Williams' AND `deleted` = '0' AND `title` = 'Still Waters II'	1	0.01 ms
65	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Joel' AND `artist_last` = 'Giovanni' AND `deleted` = '0' AND `title` = 'Villa Antiqua II'	1	0 ms
66	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Didier' AND `artist_last` = 'Louren�o' AND `deleted` = '0' AND `title` = 'Vistas al Hoyo '	1	0 ms
67	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Willem' AND `artist_last` = 'Haenraets' AND `deleted` = '0' AND `title` = 'Wealth of Flowers II'	1	0.01 ms
68	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Jean-Claude' AND `artist_last` = 'Quilici' AND `deleted` = '0' AND `title` = 'Barques de pêcheurs dans le port d\'Ajaccio'	1	0.01 ms
69	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Toby' AND `artist_last` = 'Sandland' AND `deleted` = '0' AND `title` = 'Equatorial Breeze I'	1	0.01 ms
70	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Karl' AND `artist_last` = 'Blechen' AND `deleted` = '0' AND `title` = 'Interior of the Palm House at Potsdam II'	1	0.01 ms
71	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Didier' AND `artist_last` = 'Louren�o' AND `deleted` = '0' AND `title` = 'Bolsa con Palos'	1	0 ms
72	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Dan' AND `artist_last` = 'Mackin' AND `deleted` = '0' AND `title` = 'Island Hopping'	1	0.01 ms
73	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'Peter' AND `artist_last` = 'Adams' AND `deleted` = '0' AND `title` = 'Raratonga I'	1	0.01 ms
74	SELECT COUNT(*) AS `Product.Findcount` FROM `products` AS `Product` WHERE `artist_first` = 'E.' AND `artist_last` = 'De Hey' AND `deleted` = '0' AND `title` = 'Nice'	1	0.01 ms
75	SELECT COUNT(*) AS `WebshopCart.Findcount` FROM `webshop_carts` AS `WebshopCart` WHERE `ip` = '216.73.216.35'	1	0.93 ms
76	DESCRIBE `webshop_carts`	14	0.01 ms
77	DESCRIBE `frame_static`	12	0.01 ms
78	DESCRIBE `lj_frame_static`	21	0.01 ms
79	DESCRIBE `frame_borders`	15	0.01 ms
80	DESCRIBE `frame_glasses`	9	0.01 ms
81	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'	85	0.44 ms
82	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/search/advanced' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
83	SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/posters/bloemen-planten/tropisch' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
84	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/ Keith/Mallett' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
85	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/41969' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.03 ms
86	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Gary/Whinn' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
87	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/25492' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
88	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Chris/Simpson' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
89	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/24071' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
90	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Mel/Patrick' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
91	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/27109' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
92	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Tom/Mackie' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
93	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/52127' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
94	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Anne-Marie/Grossi' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
95	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/31332' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
96	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Laurent/Pinsard' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
97	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/37425' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
98	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/ Bill/Saunders' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
99	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/1222' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
100	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Adolphe/Balfourier' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
101	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/22959' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
102	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Veronique/Vadon' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
103	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/31657' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
104	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Jen/Kirstein' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
105	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/26967' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
106	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Roger/Keiflin' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
107	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/31753' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
108	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Didier/Louren�o' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
109	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6928' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
110	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/John/Douglas' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
111	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/26598' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
112	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Sophie/Harding' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
113	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/23731' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
114	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/-/Marthe' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
115	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/5492' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
116	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/ Mary Anne/James' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
117	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/1755' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.18 ms
118	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/26599' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.04 ms
119	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Katsumi/Sugita' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
120	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6417' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
121	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Mark/Pulliam' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.02 ms
122	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6974' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
123	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Joel/Giovanni' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
124	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/26950' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
125	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Clair/Kelly' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
126	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6919' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.1 ms
127	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Sarah/Caswell' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
128	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/47091' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
129	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/-/Anonymous' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
130	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/25675' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
131	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Liz/Jardine' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
132	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6908' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
133	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/1397' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
134	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/31656' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
135	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Jose Luis/Castrillo' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
136	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6632' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
137	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/ Don/Li-Leger' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
138	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/2145' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.05 ms
139	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/27078' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
140	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Bill/Philip' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
141	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/25196' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
142	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/47036' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
143	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/26759' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
144	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Keith/Mallett' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
145	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/31252' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
146	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/ Yvette/St. Amant' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
147	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/1303' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
148	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/-/Haibin' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
149	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/53303' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
150	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/23729' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
151	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/-/Williams' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
152	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/27195' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
153	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/26951' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
154	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/7110' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
155	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Willem/Haenraets' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
156	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/36978' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
157	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Jean-Claude/Quilici' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
158	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/31677' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
159	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Toby/Sandland' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
160	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6550' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
161	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Karl/Blechen' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
162	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/47052' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
163	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/7111' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
164	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Dan/Mackin' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
165	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/6956' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
166	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/Peter/Adams' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
167	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/26178' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
168	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/show/E./De Hey' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
169	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_moreinfo/25727' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
170	SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/posters/bloemen-planten/tropisch' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
171	SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/posters/bloemen-planten/tropisch' ORDER BY `route` DESC LIMIT 1	1	0 ms
172	DESCRIBE `routes`	4	0.01 ms
173	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` = '/page/product_category/31' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
174	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` = '/page/product_category/31' AND `language` = '3' ORDER BY `route` DESC LIMIT 1	1	0 ms
175	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` = '/page/product_category/31' AND `language` = '2' ORDER BY `route` DESC LIMIT 1	1	0.01 ms
176	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
177	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
178	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
179	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.33 ms
180	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.01 ms
181	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
182	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
183	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
184	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
185	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
186	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
187	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
188	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
189	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
190	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
191	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '0'	1	0 ms
192	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
193	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3'	1	0 ms
194	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
195	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3'	1	0 ms
196	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
197	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
198	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '26'	1	0 ms
199	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
200	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '26'	1	0 ms
201	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '24'	1	0 ms
202	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
203	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '24'	1	0 ms
204	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '118'	1	0 ms
205	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
206	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '118'	1	0 ms
207	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '25'	1	0 ms
208	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
209	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '25'	1	0 ms
210	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '1'	1	0 ms
211	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
212	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '1'	1	0 ms
213	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '598'	1	0 ms
214	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
215	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '598'	1	0 ms
216	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134'	1	0 ms
217	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
218	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134'	1	0 ms
219	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
220	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '154'	1	0 ms
221	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
222	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '154'	1	0 ms
223	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '156'	1	0 ms
224	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
225	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '156'	1	0 ms
226	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '155'	1	0 ms
227	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
228	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '155'	1	0 ms
229	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '5'	1	0 ms
230	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
231	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '5'	1	0 ms
232	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4'	1	0 ms
233	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
234	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4'	1	0 ms
235	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
236	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
237	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '711'	1	0 ms
238	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
239	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '711'	1	0 ms
240	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '27'	1	0 ms
241	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
242	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '27'	1	0 ms
243	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '28'	1	0 ms
244	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
245	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '28'	1	0 ms
246	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '119'	1	0 ms
247	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
248	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '119'	1	0 ms
249	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135'	1	0 ms
250	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
251	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135'	1	0 ms
252	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
253	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
254	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '222'	1	0 ms
255	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
256	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '222'	1	0 ms
257	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '235'	1	0 ms
258	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
259	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '235'	1	0 ms
260	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2'	1	0 ms
261	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
262	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2'	1	0 ms
263	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
264	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
265	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '595'	1	0 ms
266	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
267	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '595'	1	0 ms
268	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '30'	1	0 ms
269	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
270	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '30'	1	0 ms
271	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '32'	1	0 ms
272	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
273	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '32'	1	0 ms
274	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '600'	1	0 ms
275	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
276	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '600'	1	0 ms
277	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '29'	1	0 ms
278	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
279	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '29'	1	0 ms
280	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '36'	1	0 ms
281	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
282	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '36'	1	0 ms
283	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '717'	1	0 ms
284	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
285	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '717'	1	0 ms
286	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '597'	1	0 ms
287	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
288	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '597'	1	0 ms
289	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '34'	1	0 ms
290	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
291	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '34'	1	0 ms
292	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '35'	1	0 ms
293	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
294	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '35'	1	0 ms
295	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '596'	1	0 ms
296	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
297	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '596'	1	0 ms
298	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '31'	1	0 ms
299	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
300	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '31'	1	0 ms
301	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '603'	1	0 ms
302	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
303	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '603'	1	0 ms
304	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '33'	1	0 ms
305	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
306	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '33'	1	0 ms
307	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '726'	1	0 ms
308	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
309	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '726'	1	0 ms
310	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7'	1	0 ms
311	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
312	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7'	1	0 ms
313	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
314	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
315	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '593'	1	0 ms
316	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
317	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '593'	1	0 ms
318	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '592'	1	0 ms
319	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
320	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '592'	1	0 ms
321	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '594'	1	0 ms
322	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
323	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '594'	1	0 ms
324	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138'	1	0 ms
325	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
326	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138'	1	0 ms
327	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
328	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
329	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '244'	1	0 ms
330	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.04 ms
331	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '244'	1	0 ms
332	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '160'	1	0 ms
333	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
334	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '160'	1	0 ms
335	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '161'	1	0 ms
336	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.01 ms
337	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '161'	1	0.01 ms
338	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6'	1	0 ms
339	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
340	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6'	1	0 ms
341	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
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` = '6' ORDER BY `category_name` ASC	17	0 ms
343	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '43'	1	0 ms
344	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
345	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '43'	1	0 ms
346	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '253'	1	0 ms
347	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
348	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '253'	1	0 ms
349	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '234'	1	0.01 ms
350	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
351	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '234'	1	0 ms
352	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '262'	1	0 ms
353	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.02 ms
354	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '262'	1	0 ms
355	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '609'	1	0 ms
356	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
357	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '609'	1	0.01 ms
358	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '40'	1	0 ms
359	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
360	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '40'	1	0 ms
361	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '38'	1	0 ms
362	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
363	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '38'	1	0 ms
364	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '41'	1	0 ms
365	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
366	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '41'	1	0 ms
367	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '44'	1	0.01 ms
368	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
369	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '44'	1	0 ms
370	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '39'	1	0 ms
371	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
372	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '39'	1	0 ms
373	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '263'	1	0 ms
374	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
375	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '263'	1	0 ms
376	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '37'	1	0 ms
377	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
378	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '37'	1	0 ms
379	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '629'	1	0 ms
380	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
381	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '629'	1	0 ms
382	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '610'	1	0 ms
383	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
384	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '610'	1	0 ms
385	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '42'	1	0 ms
386	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
387	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '42'	1	0 ms
388	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '257'	1	0 ms
389	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
390	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '257'	1	0 ms
391	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '712'	1	0 ms
392	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
393	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '712'	1	0 ms
394	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139'	1	0 ms
395	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
396	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139'	1	0 ms
397	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
398	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
399	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '308'	1	0 ms
400	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
401	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '308'	1	0 ms
402	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '247'	1	0 ms
403	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
404	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '247'	1	0 ms
405	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8'	1	0 ms
406	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
407	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8'	1	0 ms
408	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
409	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
410	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '49'	1	0 ms
411	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
412	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '49'	1	0 ms
413	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '51'	1	0.01 ms
414	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
415	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '51'	1	0 ms
416	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '50'	1	0 ms
417	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
418	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '50'	1	0 ms
419	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9'	1	0 ms
420	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
421	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9'	1	0 ms
422	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
423	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
424	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '54'	1	0 ms
425	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
426	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '54'	1	0 ms
427	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '57'	1	0 ms
428	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
429	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '57'	1	0 ms
430	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '140'	1	0 ms
431	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
432	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '140'	1	0 ms
433	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '55'	1	0 ms
434	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
435	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '55'	1	0 ms
436	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '727'	1	0 ms
437	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
438	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '727'	1	0 ms
439	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '56'	1	0 ms
440	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
441	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '56'	1	0 ms
442	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '53'	1	0 ms
443	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
444	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '53'	1	0 ms
445	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '599'	1	0 ms
446	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
447	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '599'	1	0 ms
448	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10'	1	0 ms
449	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
450	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10'	1	0 ms
451	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
452	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
453	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '59'	1	0 ms
454	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
455	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '59'	1	0 ms
456	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '58'	1	0 ms
457	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
458	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '58'	1	0 ms
459	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141'	1	0 ms
460	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
461	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141'	1	0 ms
462	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
463	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
464	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '718'	1	0 ms
465	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
466	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '718'	1	0 ms
467	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11'	1	0 ms
468	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
469	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11'	1	0 ms
470	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
471	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
472	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '239'	1	0 ms
473	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
474	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '239'	1	0 ms
475	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '63'	1	0 ms
476	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
477	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '63'	1	0 ms
478	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '255'	1	0 ms
479	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
480	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '255'	1	0 ms
481	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '265'	1	0 ms
482	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
483	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '265'	1	0 ms
484	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '314'	1	0 ms
485	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
486	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '314'	1	0 ms
487	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '719'	1	0 ms
488	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
489	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '719'	1	0 ms
490	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '62'	1	0 ms
491	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
492	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '62'	1	0 ms
493	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '178'	1	0 ms
494	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
495	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '178'	1	0 ms
496	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '61'	1	0 ms
497	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
498	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '61'	1	0 ms
499	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '728'	1	0 ms
500	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
501	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '728'	1	0 ms
502	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '725'	1	0 ms
503	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
504	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '725'	1	0 ms
505	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '705'	1	0 ms
506	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
507	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '705'	1	0 ms
508	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '252'	1	0 ms
509	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
510	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '252'	1	0 ms
511	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '60'	1	0 ms
512	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
513	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '60'	1	0 ms
514	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '412'	1	0 ms
515	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
516	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '412'	1	0 ms
517	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '460'	1	0 ms
518	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.01 ms
519	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '460'	1	0 ms
520	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '242'	1	0 ms
521	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
522	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '242'	1	0 ms
523	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '180'	1	0.01 ms
524	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
525	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '180'	1	0 ms
526	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '706'	1	0 ms
527	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
528	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '706'	1	0 ms
529	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142'	1	0 ms
530	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
531	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142'	1	0 ms
532	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
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` = '142' ORDER BY `category_name` ASC	11	0 ms
534	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '306'	1	0 ms
535	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
536	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '306'	1	0 ms
537	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '246'	1	0.01 ms
538	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
539	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '246'	1	0 ms
540	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '325'	1	0 ms
541	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
542	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '325'	1	0 ms
543	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '302'	1	0 ms
544	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
545	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '302'	1	0 ms
546	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '237'	1	0 ms
547	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
548	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '237'	1	0 ms
549	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '254'	1	0 ms
550	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
551	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '254'	1	0 ms
552	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '232'	1	0 ms
553	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
554	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '232'	1	0 ms
555	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '241'	1	0 ms
556	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
557	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '241'	1	0 ms
558	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '236'	1	0 ms
559	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
560	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '236'	1	0 ms
561	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '301'	1	0 ms
562	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
563	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '301'	1	0 ms
564	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '300'	1	0 ms
565	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
566	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '300'	1	0 ms
567	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12'	1	0 ms
568	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
569	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12'	1	0.01 ms
570	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
571	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
572	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '133'	1	0 ms
573	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
574	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '133'	1	0 ms
575	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '66'	1	0 ms
576	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
577	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '66'	1	0 ms
578	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '259'	1	0.01 ms
579	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
580	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '259'	1	0 ms
581	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '163'	1	0 ms
582	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
583	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '163'	1	0 ms
584	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '130'	1	0 ms
585	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
586	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '130'	1	0 ms
587	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '65'	1	0 ms
588	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
589	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '65'	1	0 ms
590	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '120'	1	0 ms
591	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
592	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '120'	1	0 ms
593	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '164'	1	0 ms
594	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
595	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '164'	1	0 ms
596	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '131'	1	0 ms
597	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
598	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '131'	1	0 ms
599	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '129'	1	0 ms
600	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
601	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '129'	1	0 ms
602	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '128'	1	0 ms
603	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
604	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '128'	1	0 ms
605	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '165'	1	0 ms
606	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
607	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '165'	1	0 ms
608	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '64'	1	0 ms
609	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
610	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '64'	1	0 ms
611	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13'	1	0 ms
612	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
613	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13'	1	0 ms
614	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
615	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
616	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '168'	1	0 ms
617	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
618	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '168'	1	0 ms
619	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '352'	1	0 ms
620	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
621	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '352'	1	0 ms
622	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '307'	1	0.01 ms
623	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
624	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '307'	1	0 ms
625	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '67'	1	0 ms
626	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.01 ms
627	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '67'	1	0 ms
628	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '167'	1	0 ms
629	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
630	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '167'	1	0 ms
631	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '303'	1	0 ms
632	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
633	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '303'	1	0 ms
634	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '249'	1	0 ms
635	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
636	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '249'	1	0 ms
637	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '330'	1	0 ms
638	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
639	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '330'	1	0 ms
640	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '68'	1	0 ms
641	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
642	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '68'	1	0.01 ms
643	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '630'	1	0 ms
644	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
645	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '630'	1	0 ms
646	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '631'	1	0 ms
647	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.01 ms
648	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '631'	1	0 ms
649	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '309'	1	0 ms
650	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
651	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '309'	1	0 ms
652	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '231'	1	0 ms
653	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
654	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '231'	1	0 ms
655	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '296'	1	0 ms
656	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
657	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '296'	1	0 ms
658	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604'	1	0 ms
659	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
660	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604'	1	0 ms
661	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
662	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
663	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '606'	1	0 ms
664	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
665	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '606'	1	0 ms
666	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '632'	1	0 ms
667	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
668	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '632'	1	0 ms
669	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '605'	1	0 ms
670	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
671	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '605'	1	0 ms
672	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '607'	1	0 ms
673	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
674	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '607'	1	0 ms
675	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '710'	1	0 ms
676	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
677	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '710'	1	0 ms
678	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14'	1	0.01 ms
679	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
680	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14'	1	0 ms
681	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.09 ms
682	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.05 ms
683	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '602'	1	0.01 ms
684	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
685	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '602'	1	0.01 ms
686	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '378'	1	0 ms
687	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
688	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '378'	1	0 ms
689	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '132'	1	0 ms
690	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
691	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '132'	1	0 ms
692	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '72'	1	0 ms
693	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
694	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '72'	1	0 ms
695	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '70'	1	0 ms
696	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
697	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '70'	1	0 ms
698	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '121'	1	0 ms
699	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
700	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '121'	1	0 ms
701	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '73'	1	0 ms
702	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
703	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '73'	1	0 ms
704	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '601'	1	0 ms
705	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
706	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '601'	1	0 ms
707	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '71'	1	0 ms
708	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
709	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '71'	1	0 ms
710	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407'	1	0 ms
711	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
712	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407'	1	0 ms
713	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
714	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
715	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '447'	1	0 ms
716	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
717	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '447'	1	0 ms
718	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16'	1	0 ms
719	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
720	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16'	1	0 ms
721	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
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` = '16' ORDER BY `category_name` ASC	14	0 ms
723	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '297'	1	0 ms
724	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
725	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '297'	1	0 ms
726	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '389'	1	0.01 ms
727	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
728	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '389'	1	0.01 ms
729	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '81'	1	0 ms
730	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
731	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '81'	1	0 ms
732	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '79'	1	0 ms
733	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
734	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '79'	1	0 ms
735	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '80'	1	0 ms
736	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
737	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '80'	1	0 ms
738	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '267'	1	0 ms
739	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
740	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '267'	1	0 ms
741	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '298'	1	0 ms
742	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
743	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '298'	1	0.03 ms
744	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '83'	1	0 ms
745	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
746	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '83'	1	0 ms
747	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '417'	1	0 ms
748	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.01 ms
749	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '417'	1	0.01 ms
750	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '77'	1	0 ms
751	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
752	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '77'	1	0 ms
753	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '76'	1	0 ms
754	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
755	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '76'	1	0 ms
756	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '78'	1	0 ms
757	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
758	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '78'	1	0 ms
759	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '82'	1	0 ms
760	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.01 ms
761	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '82'	1	0.02 ms
762	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '396'	1	0 ms
763	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
764	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '396'	1	0 ms
765	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15'	1	0 ms
766	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
767	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15'	1	0 ms
768	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
769	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
770	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '74'	1	0 ms
771	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
772	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '74'	1	0 ms
773	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '75'	1	0.02 ms
774	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
775	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '75'	1	0 ms
776	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '233'	1	0 ms
777	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
778	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '233'	1	0 ms
779	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '153'	1	0 ms
780	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
781	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '153'	1	0 ms
782	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17'	1	0 ms
783	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
784	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17'	1	0 ms
785	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
786	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
787	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '85'	1	0 ms
788	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
789	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '85'	1	0 ms
790	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '88'	1	0 ms
791	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
792	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '88'	1	0 ms
793	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21'	1	0 ms
794	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
795	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21'	1	0 ms
796	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
797	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
798	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '98'	1	0 ms
799	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
800	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '98'	1	0 ms
801	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '96'	1	0 ms
802	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
803	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '96'	1	0 ms
804	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '146'	1	0 ms
805	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
806	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '146'	1	0 ms
807	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '101'	1	0 ms
808	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
809	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '101'	1	0 ms
810	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '100'	1	0 ms
811	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
812	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '100'	1	0 ms
813	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '97'	1	0 ms
814	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
815	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '97'	1	0 ms
816	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152'	1	0 ms
817	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
818	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152'	1	0 ms
819	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
820	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
821	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '387'	1	0 ms
822	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
823	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '387'	1	0 ms
824	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '245'	1	0 ms
825	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
826	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '245'	1	0 ms
827	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '388'	1	0 ms
828	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
829	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '388'	1	0 ms
830	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19'	1	0 ms
831	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
832	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19'	1	0 ms
833	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
834	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
835	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '124'	1	0 ms
836	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
837	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '124'	1	0 ms
838	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '127'	1	0 ms
839	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
840	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '127'	1	0 ms
841	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '126'	1	0 ms
842	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
843	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '126'	1	0 ms
844	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '125'	1	0 ms
845	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
846	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '125'	1	0 ms
847	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18'	1	0 ms
848	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
849	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18'	1	0 ms
850	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
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` = '1' AND `parent` = '18' ORDER BY `category_name` ASC	7	0 ms
852	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '89'	1	0 ms
853	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
854	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '89'	1	0 ms
855	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '91'	1	0 ms
856	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
857	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '91'	1	0 ms
858	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '90'	1	0 ms
859	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
860	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '90'	1	0 ms
861	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '709'	1	0 ms
862	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
863	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '709'	1	0 ms
864	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '707'	1	0 ms
865	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
866	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '707'	1	0 ms
867	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '724'	1	0 ms
868	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
869	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '724'	1	0 ms
870	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '92'	1	0 ms
871	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
872	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '92'	1	0 ms
873	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713'	1	0 ms
874	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
875	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713'	1	0 ms
876	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
877	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '715'	1	0 ms
878	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
879	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '715'	1	0 ms
880	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '714'	1	0 ms
881	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
882	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '714'	1	0 ms
883	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23'	1	0 ms
884	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
885	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23'	1	0 ms
886	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
887	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
888	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '114'	1	0 ms
889	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
890	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '114'	1	0 ms
891	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '113'	1	0 ms
892	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
893	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '113'	1	0 ms
894	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '716'	1	0 ms
895	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
896	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '716'	1	0 ms
897	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '708'	1	0 ms
898	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 ms
899	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '708'	1	0.04 ms
900	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.09 ms
901	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '0'	1	0 ms
902	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.01 ms
903	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637'	1	0 ms
904	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
905	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637'	1	0 ms
906	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.01 ms
907	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '649'	1	0 ms
908	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
909	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '649'	1	0 ms
910	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '652'	1	0 ms
911	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
912	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '652'	1	0 ms
913	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '650'	1	0 ms
914	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
915	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '650'	1	0 ms
916	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '938'	1	0 ms
917	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
918	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '938'	1	0 ms
919	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702'	1	0 ms
920	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 ms
921	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702'	1	0 ms
922	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
923	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '703'	1	0 ms
924	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
925	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '703'	1	0 ms
926	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '704'	1	0 ms
927	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
928	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '704'	1	0.02 ms
929	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638'	1	0 ms
930	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
931	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638'	1	0 ms
932	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
933	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '919'	1	0 ms
934	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
935	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '919'	1	0 ms
936	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '653'	1	0 ms
937	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
938	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '653'	1	0.02 ms
939	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '651'	1	0 ms
940	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
941	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '651'	1	0 ms
942	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '654'	1	0 ms
943	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
944	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '654'	1	0 ms
945	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '916'	1	0 ms
946	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
947	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '916'	1	0 ms
948	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '915'	1	0 ms
949	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
950	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '915'	1	0 ms
951	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648'	1	0 ms
952	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
953	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648'	1	0 ms
954	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
955	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '655'	1	0 ms
956	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
957	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '655'	1	0 ms
958	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '656'	1	0 ms
959	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
960	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '656'	1	0 ms
961	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '657'	1	0 ms
962	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
963	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '657'	1	0 ms
964	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641'	1	0 ms
965	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
966	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641'	1	0 ms
967	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
968	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '659'	1	0 ms
969	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
970	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '659'	1	0 ms
971	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '660'	1	0 ms
972	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
973	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '660'	1	0 ms
974	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '658'	1	0 ms
975	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
976	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '658'	1	0 ms
977	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903'	1	0 ms
978	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
979	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903'	1	0 ms
980	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
981	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '926'	1	0 ms
982	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
983	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '926'	1	0.01 ms
984	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647'	1	0 ms
985	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
986	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647'	1	0 ms
987	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
988	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '663'	1	0 ms
989	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.01 ms
990	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '663'	1	0 ms
991	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '662'	1	0.01 ms
992	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
993	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '662'	1	0 ms
994	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '664'	1	0 ms
995	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
996	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '664'	1	0 ms
997	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902'	1	0 ms
998	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
999	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902'	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` = '902' ORDER BY `category_name` ASC	2	0 ms
1001	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '921'	1	0 ms
1002	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
1003	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '921'	1	0 ms
1004	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '922'	1	0 ms
1005	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
1006	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '922'	1	0 ms
1007	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640'	1	0 ms
1008	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
1009	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640'	1	0 ms
1010	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
1011	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '667'	1	0 ms
1012	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
1013	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '667'	1	0 ms
1014	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '884'	1	0 ms
1015	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
1016	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '884'	1	0 ms
1017	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '666'	1	0 ms
1018	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
1019	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '666'	1	0 ms
1020	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '665'	1	0 ms
1021	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
1022	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '665'	1	0 ms
1023	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '917'	1	0 ms
1024	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
1025	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '917'	1	0.01 ms
1026	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673'	1	0 ms
1027	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
1028	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673'	1	0 ms
1029	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
1030	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '677'	1	0 ms
1031	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
1032	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '677'	1	0 ms
1033	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '680'	1	0 ms
1034	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
1035	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '680'	1	0 ms
1036	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '676'	1	0 ms
1037	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
1038	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '676'	1	0 ms
1039	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '674'	1	0 ms
1040	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
1041	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '674'	1	0 ms
1042	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '675'	1	0 ms
1043	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
1044	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '675'	1	0 ms
1045	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '923'	1	0 ms
1046	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
1047	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '923'	1	0 ms
1048	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '678'	1	0 ms
1049	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
1050	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '678'	1	0 ms
1051	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '965'	1	0.01 ms
1052	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
1053	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '965'	1	0 ms
1054	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '967'	1	0 ms
1055	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
1056	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '967'	1	0.01 ms
1057	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '969'	1	0 ms
1058	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
1059	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '969'	1	0 ms
1060	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '966'	1	0 ms
1061	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
1062	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '966'	1	0 ms
1063	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '968'	1	0 ms
1064	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
1065	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '968'	1	0 ms
1066	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '970'	1	0 ms
1067	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
1068	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '970'	1	0 ms
1069	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '971'	1	0 ms
1070	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
1071	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '971'	1	0 ms
1072	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '972'	1	0.01 ms
1073	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
1074	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '972'	1	0 ms
1075	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '973'	1	0 ms
1076	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
1077	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '973'	1	0 ms
1078	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '974'	1	0 ms
1079	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
1080	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '974'	1	0 ms
1081	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '975'	1	0.01 ms
1082	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
1083	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '975'	1	0 ms
1084	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693'	1	0 ms
1085	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
1086	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693'	1	0.01 ms
1087	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
1088	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '695'	1	0 ms
1089	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
1090	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '695'	1	0 ms
1091	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '694'	1	0 ms
1092	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
1093	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '694'	1	0 ms
1094	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '936'	1	0 ms
1095	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
1096	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '936'	1	0 ms
1097	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698'	1	0 ms
1098	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
1099	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698'	1	0.01 ms
1100	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
1101	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '701'	1	0 ms
1102	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
1103	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '701'	1	0 ms
1104	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642'	1	0 ms
1105	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
1106	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642'	1	0 ms
1107	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
1108	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '671'	1	0 ms
1109	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
1110	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '671'	1	0.03 ms
1111	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '670'	1	0 ms
1112	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
1113	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '670'	1	0 ms
1114	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '669'	1	0 ms
1115	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
1116	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '669'	1	0 ms
1117	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '668'	1	0 ms
1118	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
1119	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '668'	1	0 ms
1120	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '672'	1	0 ms
1121	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
1122	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '672'	1	0 ms
1123	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '944'	1	0 ms
1124	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
1125	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '944'	1	0 ms
1126	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681'	1	0 ms
1127	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
1128	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681'	1	0 ms
1129	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
1130	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '683'	1	0 ms
1131	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
1132	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '683'	1	0 ms
1133	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '682'	1	0 ms
1134	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
1135	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '682'	1	0 ms
1136	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '684'	1	0 ms
1137	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
1138	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '684'	1	0 ms
1139	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '883'	1	0 ms
1140	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
1141	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '883'	1	0 ms
1142	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '901'	1	0 ms
1143	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
1144	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '901'	1	0 ms
1145	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '952'	1	0 ms
1146	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
1147	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '952'	1	0 ms
1148	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720'	1	0 ms
1149	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
1150	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720'	1	0 ms
1151	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
1152	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '900'	1	0 ms
1153	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
1154	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '900'	1	0 ms
1155	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '882'	1	0 ms
1156	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
1157	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '882'	1	0 ms
1158	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '722'	1	0 ms
1159	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
1160	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '722'	1	0 ms
1161	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '943'	1	0 ms
1162	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
1163	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '943'	1	0 ms
1164	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906'	1	0 ms
1165	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
1166	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906'	1	0 ms
1167	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
1168	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '928'	1	0 ms
1169	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
1170	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '928'	1	0 ms
1171	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '929'	1	0 ms
1172	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
1173	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '929'	1	0 ms
1174	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '930'	1	0 ms
1175	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
1176	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '930'	1	0 ms
1177	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '927'	1	0 ms
1178	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
1179	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '927'	1	0 ms
1180	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '931'	1	0 ms
1181	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
1182	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '931'	1	0 ms
1183	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696'	1	0 ms
1184	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
1185	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696'	1	0 ms
1186	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.01 ms
1187	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '697'	1	0 ms
1188	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
1189	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '697'	1	0 ms
1190	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '723'	1	0 ms
1191	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
1192	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '723'	1	0 ms
1193	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '933'	1	0 ms
1194	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
1195	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '933'	1	0 ms
1196	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646'	1	0 ms
1197	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
1198	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646'	1	0 ms
1199	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
1200	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '679'	1	0 ms
1201	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
1202	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '679'	1	0 ms
1203	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '899'	1	0 ms
1204	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
1205	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '899'	1	0 ms
1206	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '685'	1	0 ms
1207	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
1208	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '685'	1	0 ms
1209	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '924'	1	0 ms
1210	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
1211	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '924'	1	0 ms
1212	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643'	1	0 ms
1213	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
1214	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643'	1	0 ms
1215	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
1216	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '686'	1	0 ms
1217	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
1218	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '686'	1	0 ms
1219	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '687'	1	0 ms
1220	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
1221	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '687'	1	0 ms
1222	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '688'	1	0 ms
1223	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
1224	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '688'	1	0 ms
1225	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '918'	1	0 ms
1226	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
1227	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '918'	1	0 ms
1228	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905'	1	0 ms
1229	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
1230	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905'	1	0 ms
1231	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
1232	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '935'	1	0 ms
1233	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
1234	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '935'	1	0 ms
1235	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '934'	1	0 ms
1236	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
1237	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '934'	1	0 ms
1238	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907'	1	0 ms
1239	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
1240	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907'	1	0 ms
1241	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
1242	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '925'	1	0 ms
1243	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
1244	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '925'	1	0 ms
1245	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '937'	1	0 ms
1246	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
1247	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '937'	1	0 ms
1248	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644'	1	0 ms
1249	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
1250	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644'	1	0 ms
1251	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
1252	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '689'	1	0 ms
1253	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
1254	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '689'	1	0 ms
1255	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '700'	1	0 ms
1256	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
1257	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '700'	1	0 ms
1258	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
1259	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '0'	1	0 ms
1260	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
1261	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618'	1	0 ms
1262	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
1263	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618'	1	0 ms
1264	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
1265	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '619'	1	0 ms
1266	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
1267	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '619'	1	0 ms
1268	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '620'	1	0 ms
1269	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
1270	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '620'	1	0 ms
1271	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '621'	1	0 ms
1272	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
1273	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '621'	1	0 ms
1274	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '622'	1	0 ms
1275	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
1276	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '622'	1	0 ms
1277	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '623'	1	0 ms
1278	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
1279	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '623'	1	0 ms
1280	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '624'	1	0 ms
1281	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
1282	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '624'	1	0 ms
1283	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '625'	1	0 ms
1284	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
1285	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '625'	1	0 ms
1286	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '626'	1	0 ms
1287	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
1288	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '626'	1	0 ms
1289	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '627'	1	0 ms
1290	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
1291	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '627'	1	0 ms
1292	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '628'	1	0 ms
1293	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
1294	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '628'	1	0 ms
1295	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '951'	1	0 ms
1296	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
1297	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '951'	1	0 ms
1298	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584'	1	0 ms
1299	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
1300	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584'	1	0 ms
1301	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
1302	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '511'	1	0 ms
1303	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
1304	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '511'	1	0 ms
1305	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '512'	1	0 ms
1306	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
1307	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '512'	1	0 ms
1308	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '513'	1	0 ms
1309	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
1310	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '513'	1	0 ms
1311	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '514'	1	0 ms
1312	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
1313	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '514'	1	0 ms
1314	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '515'	1	0 ms
1315	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
1316	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '515'	1	0 ms
1317	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '516'	1	0 ms
1318	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
1319	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '516'	1	0 ms
1320	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '517'	1	0 ms
1321	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
1322	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '517'	1	0 ms
1323	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '518'	1	0 ms
1324	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
1325	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '518'	1	0 ms
1326	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '519'	1	0 ms
1327	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
1328	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '519'	1	0 ms
1329	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '520'	1	0 ms
1330	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
1331	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '520'	1	0 ms
1332	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '521'	1	0 ms
1333	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
1334	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '521'	1	0 ms
1335	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '522'	1	0 ms
1336	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
1337	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '522'	1	0 ms
1338	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '523'	1	0.01 ms
1339	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
1340	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '523'	1	0 ms
1341	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '524'	1	0 ms
1342	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
1343	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '524'	1	0 ms
1344	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '525'	1	0 ms
1345	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
1346	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '525'	1	0 ms
1347	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '526'	1	0 ms
1348	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
1349	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '526'	1	0 ms
1350	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '527'	1	0 ms
1351	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
1352	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '527'	1	0 ms
1353	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '528'	1	0 ms
1354	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
1355	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '528'	1	0 ms
1356	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '529'	1	0 ms
1357	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
1358	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '529'	1	0 ms
1359	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '950'	1	0 ms
1360	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
1361	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '950'	1	0 ms
1362	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
1363	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '0'	1	0 ms
1364	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
1365	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889'	1	0.01 ms
1366	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
1367	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889'	1	0 ms
1368	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
1369	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '890'	1	0 ms
1370	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
1371	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '890'	1	0 ms
1372	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '891'	1	0 ms
1373	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
1374	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '891'	1	0 ms
1375	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '893'	1	0 ms
1376	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
1377	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '893'	1	0 ms
1378	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '892'	1	0 ms
1379	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
1380	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '892'	1	0.01 ms
1381	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '896'	1	0 ms
1382	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
1383	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '896'	1	0 ms
1384	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '894'	1	0 ms
1385	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
1386	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '894'	1	0 ms
1387	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '898'	1	0 ms
1388	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
1389	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '898'	1	0 ms
1390	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '895'	1	0 ms
1391	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.01 ms
1392	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '895'	1	0 ms
1393	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '897'	1	0 ms
1394	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
1395	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '897'	1	0 ms
1396	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444'	1	0 ms
1397	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
1398	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444'	1	0 ms
1399	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
1400	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '911'	1	0 ms
1401	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
1402	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '911'	1	0 ms
1403	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947'	1	0 ms
1404	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
1405	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947'	1	0 ms
1406	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
1407	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '949'	1	0 ms
1408	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
1409	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '949'	1	0 ms
1410	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611'	1	0 ms
1411	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
1412	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611'	1	0 ms
1413	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
1414	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '613'	1	0 ms
1415	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
1416	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '613'	1	0 ms
1417	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '614'	1	0 ms
1418	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
1419	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '614'	1	0 ms
1420	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '615'	1	0 ms
1421	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
1422	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '615'	1	0 ms
1423	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '617'	1	0 ms
1424	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
1425	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '617'	1	0 ms
1426	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '616'	1	0.01 ms
1427	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
1428	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '616'	1	0 ms
1429	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '446'	1	0 ms
1430	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
1431	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '446'	1	0 ms
1432	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908'	1	0 ms
1433	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
1434	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908'	1	0 ms
1435	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.01 ms
1436	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '910'	1	0 ms
1437	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
1438	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '910'	1	0 ms
1439	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
1440	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '9' AND `parent` = '0'	1	0 ms
1441	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
1442	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '0'	1	0 ms
1443	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
1444	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '497'	1	0 ms
1445	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
1446	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '497'	1	0 ms
1447	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '498'	1	0 ms
1448	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
1449	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '498'	1	0.01 ms
1450	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '499'	1	0 ms
1451	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
1452	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '499'	1	0 ms
1453	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '500'	1	0 ms
1454	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
1455	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '500'	1	0 ms
1456	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '501'	1	0 ms
1457	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
1458	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '501'	1	0 ms
1459	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '502'	1	0 ms
1460	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
1461	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '502'	1	0 ms
1462	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '503'	1	0 ms
1463	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
1464	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '503'	1	0 ms
1465	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '504'	1	0 ms
1466	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
1467	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '504'	1	0 ms
1468	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '505'	1	0 ms
1469	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
1470	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '505'	1	0 ms
1471	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '506'	1	0 ms
1472	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
1473	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '506'	1	0 ms
1474	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '507'	1	0 ms
1475	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
1476	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '507'	1	0 ms
1477	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '608'	1	0 ms
1478	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
1479	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '608'	1	0 ms
1480	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '508'	1	0 ms
1481	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
1482	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '508'	1	0 ms
1483	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '509'	1	0 ms
1484	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
1485	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '509'	1	0 ms
1486	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '510'	1	0 ms
1487	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
1488	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '510'	1	0 ms
1489	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
1490	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '0'	1	0 ms
1491	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
1492	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945'	1	0 ms
1493	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
1494	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945'	1	0 ms
1495	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
1496	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '948'	1	0 ms
1497	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
1498	SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '948'	1	0 ms
1499	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` = '/posters/bloemen-planten/tropisch' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	0	0 ms
1500	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
1501	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
1502	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
1503	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
1504	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
1505	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
1506	SELECT DISTINCT(CONCAT(`artist_first`, `artist_last`)) AS `c` FROM `products` RIGHT JOIN `products_in_categories` ON `products_in_categories`.`product` = `products`.`id` WHERE `category` = '31'	109	0.02 ms
1507	SELECT `` as `ArtistBiography.` FROM `artist_biographies` AS `ArtistBiography` WHERE LENGTH(`artist_first`) > 0 AND LENGTH(`artist_last`) > 0 AND CONCAT(`artist_first`, `artist_last`) IN(' TandiVenter',' BillSaunders',' DonLi-Leger',' YvetteSt. Amant',' DanaRidenour',' MalcolmSurridge',' DavidShort',' Mary AnneJames','Ahava','DonLi-Leger','','KathleenCarr','FredericChurch','Haibin','SusanFriedman','JeffZaruba','RobertDunahay','LindaRoberts','Marthe','EdwardAparicio','LolaAbellán','LizJardine','KatsumiSugita','AndrewLevine','TobySandland','Jose LuisCastrillo','Hali','MontserratMasdeu','JohnCanning','SallyEvans','RickGarcia','ClairKelly','DidierLouren�o','DidierLourenço','DanMackin','LarryMoore','Mindeli','MarkPulliam','RonPeters',' StevenMeyers','','ElenaPanizza','AdolpheBalfourier','SophieHarding','ChrisSimpson','RaoulDufy','TaniaForgione','PeterAdams','BillPhilip','JulianAskins','GaryWhinn','Anonymous','E.De Hey','RogerBroders','Nadja NailaUgo','AlbertGoodwin','LindaWood','TonyKoukos','JillO\'Flannery','DennisCarney','JohnDouglas','RKemp','Daniels','JoelGiovanni','JenKirstein','KarenDupre','MelPatrick','Longo','Williams','LolaAbellàn','KeithMallett','JasonBasil','Moga','Anne-MarieGrossi','Jean-ClaudeQuilici','VeroniqueVadon','RogerKeiflin','LaurentPinsard','Kerfily','JohanMessely','WillemHaenraets','Marso','AmaliaVeralli','Robin ReneeHix','VincentVan Gogh',' KeithMallett','ValerieWilson','YvonnePoelstra-Holzhaus','PaulAllen','KatjaMarzahn','TomFrazier','MarilynRobertson','AdamBrock','KarlBlechen','SarahCaswell','JustinBua','Ute von der Wehl','TomMackie','HarrisGranville','Abellan-Solano','BarbDombrowski','MichaelFerner','ElenaFilatov','JosefBeck','AdrianoGalasso','Brenda K.Bredvik','DonnaYoung','AnneL.Strunk','UweSteger') AND `language` = '1' ORDER BY `artist_last`, `artist_first`
1508	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
1509	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
1510	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/customupload' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
1511	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
1512	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
1513	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
1514	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
1515	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
1516	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
1517	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
1518	SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/customupload' AND `language` = '1' ORDER BY `route` DESC LIMIT 1	1	0 ms
1519	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
1520	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
1521	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
1522	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
1523	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
1524	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
1525	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
1526	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
1527	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
1528	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
1529	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
1530	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
1531	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
1532	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

Page execution time: 0.846 seconds, of which 7.05 ms queries.

Tropisch (posters)

Meld je aan voor onze nieuwsbrief