Aller au contenu Aller au menu Aller à la recherche Politique d'accessibilité

Nombre de requêtes executées : 48

0.0691678524017s : UPDATE objects_lang SET Views=Views+1 WHERE ObjectId=3502 AND Lang='en'
0.0118470191956s : SELECT O.ObjectId,O.CompanyId, Price, ABS(Price - 479.00) as Difference FROM skipass.gm_prices GP, skipass.gm_object O,skipass.objects_lang OL WHERE GP.ObjectId=O.ObjectId AND GP.Currency='fr' AND O.ObjectId = OL.ObjectId AND OL.Visible = 1 AND NOT EXISTS ( SELECT NULL FROM skipass.objects_keywords WHERE objects_keywords.ObjectId=O.ObjectId) AND O.FamilyId=1 AND O.CompanyId NOT IN( 439, 380) AND O.CatId=5 AND O.Season=2007 AND O.ObjectId NOT IN(3502, 3569) ORDER BY Difference ASC LIMIT 1
0.0117089748383s : SELECT O.ObjectId,O.CompanyId, Price, ABS(Price - 479.00) as Difference FROM skipass.gm_prices GP, skipass.gm_object O,skipass.objects_lang OL WHERE GP.ObjectId=O.ObjectId AND GP.Currency='fr' AND O.ObjectId = OL.ObjectId AND OL.Visible = 1 AND NOT EXISTS ( SELECT NULL FROM skipass.objects_keywords WHERE objects_keywords.ObjectId=O.ObjectId) AND O.FamilyId=1 AND O.CompanyId NOT IN( 439, 380, 424) AND O.CatId=5 AND O.Season=2007 AND O.ObjectId NOT IN(3502, 3569, 3646) ORDER BY Difference ASC LIMIT 1
0.0107429027557s : SELECT O.ObjectId,O.CompanyId, Price, ABS(Price - 479.00) as Difference FROM skipass.gm_prices GP, skipass.gm_object O,skipass.objects_lang OL WHERE GP.ObjectId=O.ObjectId AND GP.Currency='fr' AND O.ObjectId = OL.ObjectId AND OL.Visible = 1 AND NOT EXISTS ( SELECT NULL FROM skipass.objects_keywords WHERE objects_keywords.ObjectId=O.ObjectId) AND O.FamilyId=1 AND O.CompanyId NOT IN( 439) AND O.CatId=5 AND O.Season=2007 AND O.ObjectId NOT IN(3502) ORDER BY Difference ASC LIMIT 1
0.00689220428467s : SELECT C.CompanyUrl as CompanyUrl, OL.Url as Url FROM skipass.objects_lang OL, skipass.gm_object MO, common.companies C WHERE MO.ObjectId=OL.ObjectId AND OL.Lang='en' AND OL.Visible=1 AND C.CompanyId=MO.CompanyId AND MO.CatId=5 AND MO.Season='2007' AND MO.FamilyId='1' AND MO.ObjectId > 3502 ORDER BY MO.ObjectId ASC LIMIT 1
0.00539994239807s : UPDATE skipass.gm_object SET suggestions_cache='a:2:{s:7:\"expires\";i:1231317715;s:11:\"suggestions\";a:3:{i:0;O:11:\"gearProduct\":66:{s:21:\"\0gearProduct\0nb_tests\";i:0;s:21:\"\0gearProduct\0objectId\";N;s:20:\"\0gearProduct\0company\";O:11:\"gearCompany\":9:{s:23:\"\0gearCompany\0company_id\";s:3:\"380\";s:17:\"\0gearCompany\0name\";s:4:\"Head\";s:30:\"\0gearCompany\0short_description\";s:0:\"\";s:16:\"\0gearCompany\0Url\";s:4:\"head\";s:23:\"\0gearCompany\0folder_url\";N;s:23:\"\0gearCompany\0categories\";N;s:26:\"\0gearCompany\0family_season\";O:16:\"gearFamilySeason\":16:{s:24:\"\0gearFamilySeason\0season\";s:4:\"2007\";s:27:\"\0gearFamilySeason\0family_id\";s:1:\"1\";s:29:\"\0gearFamilySeason\0description\";N;s:30:\"\0gearFamilySeason\0family_title\";s:4:\"skis\";s:28:\"\0gearFamilySeason\0family_url\";s:3:\"ski\";s:35:\"\0gearFamilySeason\0family_season_url\";s:20:\"/gearguide/ski/2007/\";s:25:\"\0gearFamilySeason\0libelle\";s:23:\"all about the 2007 skis\";s:27:\"\0gearFamilySeason\0cat_links\";N;s:28:\"\0gearFamilySeason\0categories\";N;s:27:\"\0gearFamilySeason\0companies\";N;s:30:\"\0gearFamilySeason\0zoom_product\";N;s:28:\"\0gearFamilySeason\0last_tests\";N;s:23:\"\0gearFamilySeason\0tests\";N;s:31:\"\0gearFamilySeason\0last_comments\";N;s:26:\"\0gearFamilySeason\0nb_tests\";i:0;s:36:\"\0gearFamilySeason\0nb_products_tested\";i:0;}s:30:\"\0gearProductContainer\0products\";N;s:37:\"\0gearProductContainer\0products_groups\";N;}s:17:\"\0gearProduct\0tags\";a:0:{}s:23:\"\0gearProduct\0criterions\";N;s:21:\"\0gearProduct\0prev_Url\";N;s:21:\"\0gearProduct\0next_Url\";N;s:19:\"\0gearProduct\0levels\";N;s:24:\"\0gearProduct\0suggestions\";N;s:26:\"\0gearProduct\0family_season\";r:14;s:21:\"\0gearProduct\0category\";O:12:\"gearCategory\":13:{s:25:\"\0gearCategory\0category_id\";s:1:\"5\";s:18:\"\0gearCategory\0name\";s:8:\"Allround\";s:17:\"\0gearCategory\0Url\";s:8:\"allround\";s:25:\"\0gearCategory\0description\";s:0:\"\";s:31:\"\0gearCategory\0short_description\";s:22:\"Versatility is the key\";s:27:\"\0gearCategory\0family_season\";r:14;s:23:\"\0gearCategory\0companies\";N;s:23:\"\0gearCategory\0photo_url\";N;s:25:\"\0gearCategory\0photo_width\";N;s:26:\"\0gearCategory\0photo_height\";N;s:24:\"\0gearCategory\0last_tests\";N;s:30:\"\0gearProductContainer\0products\";N;s:37:\"\0gearProductContainer\0products_groups\";N;}s:26:\"\0gearProduct\0product_tests\";N;s:28:\"\0gearProduct\0photo_front_url\";N;s:30:\"\0gearProduct\0photo_front_width\";N;s:31:\"\0gearProduct\0photo_front_height\";N;s:27:\"\0gearProduct\0photo_back_url\";N;s:29:\"\0gearProduct\0photo_back_width\";N;s:30:\"\0gearProduct\0photo_back_height\";N;s:28:\"\0gearProduct\0photo_thumb_url\";N;s:30:\"\0gearProduct\0photo_thumb_width\";N;s:31:\"\0gearProduct\0photo_thumb_height\";N;s:32:\"\0gearProduct\0photo_backthumb_url\";N;s:34:\"\0gearProduct\0photo_backthumb_width\";N;s:35:\"\0gearProduct\0photo_backthumb_height\";N;s:20:\"\0gearProduct\0meta_id\";s:4:\"1279\";s:24:\"\0gearProduct\0meta_linked\";N;s:11:\"\0*\0ObjectId\";i:3569;s:10:\"\0*\0OwnerId\";N;s:11:\"\0*\0ParentId\";i:0;s:6:\"\0*\0Url\";s:13:\"Wild-Thang-RF\";s:13:\"\0*\0parent_url\";N;s:15:\"\0*\0complete_url\";N;s:7:\"\0*\0icon\";a:3:{s:4:\"Icon\";N;s:9:\"IconWidth\";N;s:10:\"IconHeight\";N;}s:9:\"\0*\0header\";a:3:{s:11:\"HeaderImage\";N;s:11:\"HeaderWidth\";N;s:12:\"HeaderHeight\";N;}s:8:\"\0*\0Title\";s:14:\"Wild Thang RF\";s:14:\"\0*\0Description\";s:0:\"\";s:7:\"\0*\0Body\";s:0:\"\";s:11:\"\0*\0BodyHTML\";N;s:11:\"\0*\0BodyType\";s:1:\"4\";s:5:\"owner\";N;s:7:\"\0*\0Type\";s:5:\"matos\";s:7:\"\0*\0Link\";N;s:10:\"\0*\0Visible\";s:1:\"1\";s:7:\"\0*\0Home\";s:1:\"0\";s:10:\"\0*\0Updated\";s:19:\"0000-00-00 00:00:00\";s:10:\"\0*\0Created\";s:19:\"2006-05-29 18:56:28\";s:8:\"\0*\0Views\";s:3:\"418\";s:12:\"\0*\0Published\";s:1:\"1\";s:18:\"\0*\0CounterComments\";s:1:\"0\";s:19:\"\0cObject\0objectType\";s:5:\"matos\";s:12:\"\0*\0portfolio\";N;s:14:\"\0*\0commentList\";N;s:16:\"keywords_manager\";N;s:17:\"\0*\0photos_manager\";N;s:11:\"\0*\0geopoint\";N;s:16:\"\0*\0comments_list\";N;s:16:\"\0*\0prefixe_table\";s:8:\"skipass.\";s:14:\"\0*\0is_favorite\";N;s:22:\"\0cObject\0partner_links\";N;s:9:\"object_id\";i:3569;s:6:\"Locked\";N;s:4:\"Lang\";s:2:\"en\";s:14:\"ParentObjectId\";s:1:\"0\";s:15:\"ObjectTimestamp\";s:10:\"1148921788\";s:6:\"Childs\";s:1:\"0\";s:6:\"Rating\";s:3:\"0.0\";}i:1;O:11:\"gearProduct\":66:{s:21:\"\0gearProduct\0nb_tests\";i:0;s:21:\"\0gearProduct\0objectId\";N;s:20:\"\0gearProduct\0company\";O:11:\"gearCompany\":9:{s:23:\"\0gearCompany\0company_id\";s:3:\"424\";s:17:\"\0gearCompany\0name\";s:8:\"Movement\";s:30:\"\0gearCompany\0short_description\";s:0:\"\";s:16:\"\0gearCompany\0Url\";s:8:\"movement\";s:23:\"\0gearCompany\0folder_url\";N;s:23:\"\0gearCompany\0categories\";N;s:26:\"\0gearCompany\0family_season\";r:14;s:30:\"\0gearProductContainer\0products\";N;s:37:\"\0gearProductContainer\0products_groups\";N;}s:17:\"\0gearProduct\0tags\";a:0:{}s:23:\"\0gearProduct\0criterions\";N;s:21:\"\0gearProduct\0prev_Url\";N;s:21:\"\0gearProduct\0next_Url\";N;s:19:\"\0gearProduct\0levels\";N;s:24:\"\0gearProduct\0suggestions\";N;s:26:\"\0gearProduct\0family_season\";r:14;s:21:\"\0gearProduct\0category\";O:12:\"gearCategory\":13:{s:25:\"\0gearCategory\0category_id\";s:1:\"5\";s:18:\"\0gearCategory\0name\";s:8:\"Allround\";s:17:\"\0gearCategory\0Url\";s:8:\"allround\";s:25:\"\0gearCategory\0description\";s:0:\"\";s:31:\"\0gearCategory\0short_description\";s:22:\"Versatility is the key\";s:27:\"\0gearCategory\0family_season\";r:14;s:23:\"\0gearCategory\0companies\";N;s:23:\"\0gearCategory\0photo_url\";N;s:25:\"\0gearCategory\0photo_width\";N;s:26:\"\0gearCategory\0photo_height\";N;s:24:\"\0gearCategory\0last_tests\";N;s:30:\"\0gearProductContainer\0products\";N;s:37:\"\0gearProductContainer\0products_groups\";N;}s:26:\"\0gearProduct\0product_tests\";N;s:28:\"\0gearProduct\0photo_front_url\";N;s:30:\"\0gearProduct\0photo_front_width\";N;s:31:\"\0gearProduct\0photo_front_height\";N;s:27:\"\0gearProduct\0photo_back_url\";N;s:29:\"\0gearProduct\0photo_back_width\";N;s:30:\"\0gearProduct\0photo_back_height\";N;s:28:\"\0gearProduct\0photo_thumb_url\";N;s:30:\"\0gearProduct\0photo_thumb_width\";N;s:31:\"\0gearProduct\0photo_thumb_height\";N;s:32:\"\0gearProduct\0photo_backthumb_url\";N;s:34:\"\0gearProduct\0photo_backthumb_width\";N;s:35:\"\0gearProduct\0photo_backthumb_height\";N;s:20:\"\0gearProduct\0meta_id\";s:4:\"1353\";s:24:\"\0gearProduct\0meta_linked\";N;s:11:\"\0*\0ObjectId\";i:3646;s:10:\"\0*\0OwnerId\";N;s:11:\"\0*\0ParentId\";i:0;s:6:\"\0*\0Url\";s:5:\"Flame\";s:13:\"\0*\0parent_url\";N;s:15:\"\0*\0complete_url\";N;s:7:\"\0*\0icon\";a:3:{s:4:\"Icon\";N;s:9:\"IconWidth\";N;s:10:\"IconHeight\";N;}s:9:\"\0*\0header\";a:3:{s:11:\"HeaderImage\";N;s:11:\"HeaderWidth\";N;s:12:\"HeaderHeight\";N;}s:8:\"\0*\0Title\";s:5:\"Flame\";s:14:\"\0*\0Description\";s:391:\"We want our customers to be happy, their ski dreams fulfilled. So here is the new Flame, a blend of comfort and performance to guide you through the most demanding terrain. Fluidity and versatility, in the air, in powder, on piste, to make you the happiest and most motivated skier on the mountain. A razor in a velvet glove, a weapon for every hand: the Flame could be your dream come true.\";s:7:\"\0*\0Body\";s:391:\"We want our customers to be happy, their ski dreams fulfilled. So here is the new Flame, a blend of comfort and performance to guide you through the most demanding terrain. Fluidity and versatility, in the air, in powder, on piste, to make you the happiest and most motivated skier on the mountain. A razor in a velvet glove, a weapon for every hand: the Flame could be your dream come true.\";s:11:\"\0*\0BodyHTML\";N;s:11:\"\0*\0BodyType\";s:1:\"4\";s:5:\"owner\";N;s:7:\"\0*\0Type\";s:5:\"matos\";s:7:\"\0*\0Link\";N;s:10:\"\0*\0Visible\";s:1:\"1\";s:7:\"\0*\0Home\";s:1:\"0\";s:10:\"\0*\0Updated\";s:19:\"0000-00-00 00:00:00\";s:10:\"\0*\0Created\";s:19:\"2006-05-29 19:00:38\";s:8:\"\0*\0Views\";s:4:\"1503\";s:12:\"\0*\0Published\";s:1:\"1\";s:18:\"\0*\0CounterComments\";s:1:\"0\";s:19:\"\0cObject\0objectType\";s:5:\"matos\";s:12:\"\0*\0portfolio\";N;s:14:\"\0*\0commentList\";N;s:16:\"keywords_manager\";N;s:17:\"\0*\0photos_manager\";N;s:11:\"\0*\0geopoint\";N;s:16:\"\0*\0comments_list\";N;s:16:\"\0*\0prefixe_table\";s:8:\"skipass.\";s:14:\"\0*\0is_favorite\";N;s:22:\"\0cObject\0partner_links\";N;s:9:\"object_id\";i:3646;s:6:\"Locked\";N;s:4:\"Lang\";s:2:\"en\";s:14:\"ParentObjectId\";s:1:\"0\";s:15:\"ObjectTimestamp\";s:10:\"1148922038\";s:6:\"Childs\";s:1:\"0\";s:6:\"Rating\";s:3:\"0.0\";}i:2;O:11:\"gearProduct\":66:{s:21:\"\0gearProduct\0nb_tests\";i:0;s:21:\"\0gearProduct\0objectId\";N;s:20:\"\0gearProduct\0company\";O:11:\"gearCompany\":9:{s:23:\"\0gearCompany\0company_id\";s:3:\"421\";s:17:\"\0gearCompany\0name\";s:7:\"Nordica\";s:30:\"\0gearCompany\0short_description\";s:0:\"\";s:16:\"\0gearCompany\0Url\";s:7:\"nordica\";s:23:\"\0gearCompany\0folder_url\";N;s:23:\"\0gearCompany\0categories\";N;s:26:\"\0gearCompany\0family_season\";r:14;s:30:\"\0gearProductContainer\0products\";N;s:37:\"\0gearProductContainer\0products_groups\";N;}s:17:\"\0gearProduct\0tags\";a:0:{}s:23:\"\0gearProduct\0criterions\";N;s:21:\"\0gearProduct\0prev_Url\";N;s:21:\"\0gearProduct\0next_Url\";N;s:19:\"\0gearProduct\0levels\";N;s:24:\"\0gearProduct\0suggestions\";N;s:26:\"\0gearProduct\0family_season\";r:14;s:21:\"\0gearProduct\0category\";O:12:\"gearCategory\":13:{s:25:\"\0gearCategory\0category_id\";s:1:\"5\";s:18:\"\0gearCategory\0name\";s:8:\"Allround\";s:17:\"\0gearCategory\0Url\";s:8:\"allround\";s:25:\"\0gearCategory\0description\";s:0:\"\";s:31:\"\0gearCategory\0short_description\";s:22:\"Versatility is the key\";s:27:\"\0gearCategory\0family_season\";r:14;s:23:\"\0gearCategory\0companies\";N;s:23:\"\0gearCategory\0photo_url\";N;s:25:\"\0gearCategory\0photo_width\";N;s:26:\"\0gearCategory\0photo_height\";N;s:24:\"\0gearCategory\0last_tests\";N;s:30:\"\0gearProductContainer\0products\";N;s:37:\"\0gearProductContainer\0products_groups\";N;}s:26:\"\0gearProduct\0product_tests\";N;s:28:\"\0gearProduct\0photo_front_url\";N;s:30:\"\0gearProduct\0photo_front_width\";N;s:31:\"\0gearProduct\0photo_front_height\";N;s:27:\"\0gearProduct\0photo_back_url\";N;s:29:\"\0gearProduct\0photo_back_width\";N;s:30:\"\0gearProduct\0photo_back_height\";N;s:28:\"\0gearProduct\0photo_thumb_url\";N;s:30:\"\0gearProduct\0photo_thumb_width\";N;s:31:\"\0gearProduct\0photo_thumb_height\";N;s:32:\"\0gearProduct\0photo_backthumb_url\";N;s:34:\"\0gearProduct\0photo_backthumb_width\";N;s:35:\"\0gearProduct\0photo_backthumb_height\";N;s:20:\"\0gearProduct\0meta_id\";s:4:\"1385\";s:24:\"\0gearProduct\0meta_linked\";N;s:11:\"\0*\0ObjectId\";i:3678;s:10:\"\0*\0OwnerId\";N;s:11:\"\0*\0ParentId\";i:0;s:6:\"\0*\0Url\";s:21:\"hot-rod-eliminatorxbs\";s:13:\"\0*\0parent_url\";N;s:15:\"\0*\0complete_url\";N;s:7:\"\0*\0icon\";a:3:{s:4:\"Icon\";N;s:9:\"IconWidth\";N;s:10:\"IconHeight\";N;}s:9:\"\0*\0header\";a:3:{s:11:\"HeaderImage\";N;s:11:\"HeaderWidth\";N;s:12:\"HeaderHeight\";N;}s:8:\"\0*\0Title\";s:21:\"hot rod eliminatorxbs\";s:14:\"\0*\0Description\";s:0:\"\";s:7:\"\0*\0Body\";s:0:\"\";s:11:\"\0*\0BodyHTML\";N;s:11:\"\0*\0BodyType\";s:1:\"4\";s:5:\"owner\";N;s:7:\"\0*\0Type\";s:5:\"matos\";s:7:\"\0*\0Link\";N;s:10:\"\0*\0Visible\";s:1:\"1\";s:7:\"\0*\0Home\";s:1:\"0\";s:10:\"\0*\0Updated\";s:19:\"0000-00-00 00:00:00\";s:10:\"\0*\0Created\";s:19:\"2006-05-29 20:44:31\";s:8:\"\0*\0Views\";s:3:\"591\";s:12:\"\0*\0Published\";s:1:\"1\";s:18:\"\0*\0CounterComments\";s:1:\"0\";s:19:\"\0cObject\0objectType\";s:5:\"matos\";s:12:\"\0*\0portfolio\";N;s:14:\"\0*\0commentList\";N;s:16:\"keywords_manager\";N;s:17:\"\0*\0photos_manager\";N;s:11:\"\0*\0geopoint\";N;s:16:\"\0*\0comments_list\";N;s:16:\"\0*\0prefixe_table\";s:8:\"skipass.\";s:14:\"\0*\0is_favorite\";N;s:22:\"\0cObject\0partner_links\";N;s:9:\"object_id\";i:3678;s:6:\"Locked\";N;s:4:\"Lang\";s:2:\"en\";s:14:\"ParentObjectId\";s:1:\"0\";s:15:\"ObjectTimestamp\";s:10:\"1148928271\";s:6:\"Childs\";s:1:\"0\";s:6:\"Rating\";s:3:\"0.0\";}}}' WHERE ObjectId=3502
0.00276589393616s : SELECT OL.*, OL.Views, MO.CompanyId as CompanyId, MO.CatId as CategoryId, MO.FamilyId, MO.Season, MO.MetaId, MO.suggestions_cache, GMTC.NbTests FROM ( skipass.objects_lang OL, skipass.gm_object MO ) LEFT JOIN skipass.gm_tests_counters GMTC ON GMTC.Lang=OL.Lang AND GMTC.ObjectId=OL.ObjectId AND GMTC.SiteId=2 WHERE MO.ObjectId=OL.ObjectId AND OL.Lang='en' AND MO.ObjectId = 3569
0.00160503387451s : SELECT OL.*, OL.Views, MO.SizeRef, MO.CompanyId as CompanyId, MO.CatId as CategoryId, OL.objectId as objectId, MO.FamilyId, MO.Season, MO.MetaId, MO.suggestions_cache, GMTC.NbTests FROM ( skipass.objects_lang OL, skipass.gm_object MO, common.companies C ) LEFT JOIN skipass.gm_tests_counters GMTC ON GMTC.Lang=OL.Lang AND GMTC.ObjectId=OL.ObjectId AND GMTC.SiteId=2 WHERE MO.ObjectId=OL.ObjectId AND OL.Url='Crossbow' AND OL.Lang='en' AND MO.CompanyId=C.CompanyId LIMIT 1
0.000916004180908s : SELECT LL.libelle,L.LevelId FROM skipass.gm_levels L,skipass.gm_levels_lang LL, skipass.gm_object O WHERE L.FamilyId=1 AND L.LevelId=LL.LevelId AND LL.Lang='en' AND ( (O.MinLevel=L.LevelId) OR (O.MaxLevel=L.LevelId) ) AND O.ObjectId=3502 ORDER BY LevelOrder
0.000827074050903s : SELECT C.CompanyUrl as CompanyUrl, OL.Url as Url FROM skipass.objects_lang OL, skipass.gm_object MO, common.companies C WHERE MO.ObjectId=OL.ObjectId AND OL.Lang='en' AND OL.Visible=1 AND C.CompanyId=MO.CompanyId AND MO.CatId=5 AND MO.Season='2007' AND MO.FamilyId='1' AND MO.ObjectId < 3502 ORDER BY MO.ObjectId DESC LIMIT 1
0.00078010559082s : SELECT OL.*, OL.Views, MO.CompanyId as CompanyId, MO.CatId as CategoryId, MO.FamilyId, MO.Season, MO.MetaId, MO.suggestions_cache, GMTC.NbTests FROM ( skipass.objects_lang OL, skipass.gm_object MO ) LEFT JOIN skipass.gm_tests_counters GMTC ON GMTC.Lang=OL.Lang AND GMTC.ObjectId=OL.ObjectId AND GMTC.SiteId=2 WHERE MO.ObjectId=OL.ObjectId AND OL.Lang='en' AND MO.ObjectId = 3646
0.000617980957031s : SELECT C.CritId as id, CL.Libelle, V.value, CL.Unit, VL.Text, VL.Lang FROM skipass.gm_criteres C, skipass.gm_criteres_lang CL LEFT OUTER JOIN skipass.gm_criteres_values V ON V.CritId = CL.CritId AND V.ObjectId =3502 LEFT OUTER JOIN skipass.gm_criteres_values_lang VL ON CL.CritID = VL.critID AND VL.ObjectId =3502 AND VL.Lang = CL.Lang WHERE C.FamilyId=1 AND C.CritId = CL.CritId AND CL.Lang = 'en' ORDER BY CL.Lang,C.CritOrder
0.00060510635376s : SELECT GO.ObjectId FROM skipass.gm_object GO, objects_lang OL WHERE GO.ObjectId=OL.ObjectId AND OL.Lang='en' AND OL.Visible=1 AND MetaId=1212 AND GO.ObjectId !=3502 ORDER BY Season ASC
0.000568866729736s : SELECT OL.*, OL.Views, MO.CompanyId as CompanyId, MO.CatId as CategoryId, MO.FamilyId, MO.Season, MO.MetaId, MO.suggestions_cache, GMTC.NbTests FROM ( skipass.objects_lang OL, skipass.gm_object MO ) LEFT JOIN skipass.gm_tests_counters GMTC ON GMTC.Lang=OL.Lang AND GMTC.ObjectId=OL.ObjectId AND GMTC.SiteId=2 WHERE MO.ObjectId=OL.ObjectId AND OL.Lang='en' AND MO.ObjectId = 3678
0.000447988510132s : SELECT T.* FROM skipass.gm_tests T WHERE T.ObjectId=3502 AND T.Lang='en' AND T.SiteId = '2' ORDER BY T.Created DESC
0.000445127487183s : SELECT skipass.photos_lang. * , skipass.photos. * FROM skipass.photos LEFT JOIN skipass.photos_lang ON photos.PhotoId = photos_lang.PhotoId AND photos_lang.Lang = 'en' WHERE photos.ObjectId = 3678 ORDER BY photos.PhotoId
0.000403165817261s : SELECT skipass.photos_lang.*, skipass.photos.* FROM skipass.photos LEFT JOIN skipass.photos_lang on photos.PhotoId=photos_lang.PhotoId and photos_lang.Lang='en' WHERE photos.ObjectId=3502 ORDER BY photos.PhotoId
0.000365972518921s : SELECT RT.* , U.UserName, U.user_id, U.user_url FROM skipass.ratings_texts RT LEFT JOIN common.users U ON RT.UserId=U.UserId WHERE RT.Lang='en' AND RT.Visible = 1 AND ObjectId=3502 AND RT.SiteId=2 ORDER BY DATE ASC LIMIT 0, 40
0.000324010848999s : SELECT P.Currency, P.Price FROM skipass.gm_prices P WHERE P.ObjectId=3502
0.000291109085083s : INSERT INTO objects_stats SET ObjectId=3502, Lang='en', Date=NOW(), Views=1 ON DUPLICATE KEY UPDATE Views=Views+1
0.00028395652771s : SELECT FT.Intro as Intro,FL.Url as familyURL, FL.Libelle as Libelle, C.NbTests, C.NbProducts FROM ( skipass.gm_family_texts FT, skipass.gm_family_lang FL ) LEFT JOIN skipass.gm_tests_counters_details C ON C.FamilyId=FL.FamilyId AND C.SiteId=FL.SiteId AND C.Lang=FL.Lang AND C.Season=2007 WHERE FT.FamilyId=FL.FamilyId AND FL.SiteId=2 AND FT.Lang=FL.Lang AND FT.Lang='en' AND FT.FamilyId=1 AND FT.Season=2007 AND FT.SiteId=2
0.000278949737549s : SELECT COUNT(*) as nb, UNIX_TIMESTAMP() AS CurrentTime FROM common.sessions_online WHERE SiteId=2
0.000262975692749s : SELECT skipass.photos_lang. * , skipass.photos. * FROM skipass.photos LEFT JOIN skipass.photos_lang ON photos.PhotoId = photos_lang.PhotoId AND photos_lang.Lang = 'en' WHERE photos.ObjectId = 3569 ORDER BY photos.PhotoId
0.000238180160522s : SELECT COUNT(*) as CounterComments, SUM(Feeling) as RatingsSum FROM skipass.ratings_texts as RT WHERE RT.Lang='en' AND RT.Visible = 1 AND RT.ObjectId=3502 AND RT.SiteId=2
0.000230073928833s : SELECT * FROM ratings_config LEFT JOIN ratings_config_texts ON ratings_config.ObjectType = ratings_config_texts.ObjectType AND Lang='en' WHERE ratings_config.ObjectType='matos'
0.000217914581299s : SELECT S.Size FROM skipass.gm_sizes S WHERE S.ObjectId=3502
0.000185012817383s : SELECT skipass.photos_lang.*, skipass.photos.* FROM skipass.photos LEFT JOIN skipass.photos_lang on photos.PhotoId=photos_lang.PhotoId and photos_lang.Lang='en' WHERE photos.ObjectId=3502 ORDER BY photos.PhotoId
0.000176906585693s : SELECT skipass.photos_lang. * , skipass.photos. * FROM skipass.photos LEFT JOIN skipass.photos_lang ON photos.PhotoId = photos_lang.PhotoId AND photos_lang.Lang = 'en' WHERE photos.ObjectId = 3646 ORDER BY photos.PhotoId
0.000146865844727s : SELECT CL.* FROM skipass.gm_cats_lang CL,skipass.gm_familyCats FC WHERE CL.CatId=5 AND FC.FamilyId=1 AND FC.CatId=CL.CatId AND CL.Lang='en' AND CL.SiteId=2 LIMIT 1
0.000144004821777s : SELECT CL.* FROM skipass.gm_cats_lang CL,skipass.gm_familyCats FC WHERE CL.CatId=5 AND FC.FamilyId=1 AND FC.CatId=CL.CatId AND CL.Lang='en' AND CL.SiteId=2 LIMIT 1
0.000136137008667s : SELECT cKeyword.KeywordId,cKeyword.Keyword,cKeyword.KeywordUrl as Url FROM common.keywords_lang cKeyword, skipass.objects_keywords OK WHERE cKeyword.Lang='en' AND cKeyword.KeywordId=OK.key_id AND OK.ObjectId=3569
0.000131130218506s : SELECT CompanyUrl,Company,Description FROM common.companies WHERE CompanyId=380 LIMIT 1
0.000127792358398s : SELECT CL.* FROM skipass.gm_cats_lang CL,skipass.gm_familyCats FC WHERE CL.CatId=5 AND FC.FamilyId=1 AND FC.CatId=CL.CatId AND CL.Lang='en' AND CL.SiteId=2 LIMIT 1
0.000127077102661s : SELECT CL.* FROM skipass.gm_cats_lang CL,skipass.gm_familyCats FC WHERE CL.CatId=5 AND FC.FamilyId=1 AND FC.CatId=CL.CatId AND CL.Lang='en' AND CL.SiteId=2 LIMIT 1
0.000125885009766s : SELECT cKeyword.KeywordId,cKeyword.Keyword,cKeyword.KeywordUrl as Url FROM common.keywords_lang cKeyword, skipass.objects_keywords OK WHERE cKeyword.Lang='en' AND cKeyword.KeywordId=OK.key_id AND OK.ObjectId=3502
0.000124931335449s : SELECT CompanyUrl,Company,Description FROM common.companies WHERE CompanyId=439 LIMIT 1
0.000123977661133s : SELECT DISTINCT FT.Season,FT.FamilyId FROM skipass.gm_family_texts FT, skipass.gm_family_lang FL WHERE FT.Lang='en' AND FL.FamilyId = FT.FamilyId AND FL.Url = 'ski' AND FL.SiteId=2 AND FT.Season = 2007 AND FT.SiteId=2 ORDER BY FT.FamilyId, FT.Season DESC
0.0001220703125s : SELECT CompanyUrl,Company,Description FROM common.companies WHERE CompanyId=424 LIMIT 1
0.000121116638184s : SELECT cKeyword.KeywordId,cKeyword.Keyword,cKeyword.KeywordUrl as Url FROM common.keywords_lang cKeyword, skipass.objects_keywords OK WHERE cKeyword.Lang='en' AND cKeyword.KeywordId=OK.key_id AND OK.ObjectId=3646
0.000120878219604s : SELECT CompanyUrl,Company,Description FROM common.companies WHERE CompanyId=421 LIMIT 1
0.000120162963867s : SELECT zoneid, banner_zone_id FROM gm_adzones WHERE Season = 2007 AND Lang='en' AND FamilyId = '1' AND CatId IN (0,'5' ) AND CompanyId = '439' ORDER BY CatId DESC
0.000119209289551s : SELECT cKeyword.KeywordId,cKeyword.Keyword,cKeyword.KeywordUrl as Url FROM common.keywords_lang cKeyword, skipass.objects_keywords OK WHERE cKeyword.Lang='en' AND cKeyword.KeywordId=OK.key_id AND OK.ObjectId=3678
0.000118970870972s : SELECT DISTINCT FT.Season,FT.FamilyId FROM skipass.gm_family_texts FT WHERE FT.Lang='en' AND FT.FamilyId = 1 AND FT.SiteId=2 ORDER BY FT.FamilyId, FT.Season DESC
0.000118017196655s : SET character_set_results = latin1
0.000118017196655s : SELECT zoneid, banner_zone_id FROM gm_adzones WHERE Season = '2007' AND Lang='en' AND FamilyId = '1' AND CatId IN (0,'5' ) AND CompanyId = 0 ORDER BY CatId DESC
0.000114917755127s : SELECT NULL FROM common.site_modules WHERE SiteId='2' AND module='classifieds'
0.000110149383545s : SET character_set_client = latin1
0.000108957290649s : SET character_set_connection = latin1