DEVELOPMENT MODE

Polaroid Studio

Polaroid Studio





SQL Execution Summary (Longest Time to Shortest)

Execution time SQL Chunk
0.004188 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1394 AND c.content_id = cs.content_id AND cs.language_id = Show
0.003668 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1392 AND c.content_id = cs.content_id AND cs.language_id = Show
0.003030 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1409 AND c.content_id = cs.content_id AND cs.language_id = Show
0.001627 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND sc Show
0.000678 seconds SELECT SQL_CALC_FOUND_ROWS c.content_id,c.content_type,c.locked,cd.modify_date,cd.created_date,cd.approved,cd.header,cd.image_1,cd.custom_string_1,sc. Show
0.000608 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1417 AND c.content_id = cs.content_id AND cs.assoc_type='sp Show
0.000552 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2383 AND m.active=1 AND m.site_id = s.site_id Show
0.000386 seconds SELECT sum(quantity) as qty, SUM(actual_price * quantity) as total FROM cart_items WHERE cart_id='3ssu4f7q9c6kn11dr1mmbkhna5' Show
0.000371 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3099 AND m.active=1 AND m.site_id = s.site_id Show
0.000354 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2384 AND m.active=1 AND m.site_id = s.site_id Show
0.000326 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000322 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000501 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3096 AND m.active=1 AND m.site_id = s.site_id Show
0.000327 seconds SELECT c.assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_key1, c.cat_key2, c.cat_key3, c.ca Show
0.000251 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1409 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000327 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000324 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000345 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000287 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1806 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000304 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3098 AND m.active=1 AND m.site_id = s.site_id Show
0.000244 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1807 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000247 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=3000 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000273 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3097 AND m.active=1 AND m.site_id = s.site_id Show
0.000309 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000243 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1830 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000000 seconds update pure_sessions set session_data ='current_catalog|i:0;language_id|i:1;currency_id|i:1;', session_expiration = '1268503919', user_id =null , si Show
0.000317 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000280 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000215 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3095 AND m.active=1 AND m.site_id = s.site_id Show
0.000293 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000203 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1387 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000215 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1419 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000330 seconds SELECT sr.*, menu1.header as menu1_cat1, menu1.header as menu1_cat1, menu1.custom_string_1 as menu1_cat2, menu1.custom_string_2 as menu1_cat3, menu1. Show
0.000213 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3094 AND m.active=1 AND m.site_id = s.site_id Show
0.000212 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1393 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000289 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000214 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1390 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000258 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1389 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000214 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3093 AND m.active=1 AND m.site_id = s.site_id Show
0.000323 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000344 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=4340 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000318 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1851 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000248 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=4332 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000207 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1804 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000329 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000508 seconds SELECT SQL_CALC_FOUND_ROWS c.content_id,c.content_type,c.locked,cd.modify_date,cd.created_date,cd.approved,cd.header,cd.custom_string_1,cd.custom_stri Show
0.000257 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1839 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000352 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000255 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1838 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000313 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000249 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1406 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000247 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1405 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000255 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1409 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000413 seconds SELECT c.catalog_id, c.assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_key1, c.cat_key2, c. Show
0.000221 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000218 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000226 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000236 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000234 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000214 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000211 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000214 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000218 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000164 seconds SELECT DISTINCT currency_id, currency_name FROM cat_lang_dump WHERE catalog_id = 0 Show
0.000206 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_8' AND cd.heade Show
0.000163 seconds SELECT 1 FROM cat_lang_dump WHERE language_id = 1 AND currency_id = 1 Show
0.000167 seconds SELECT currency_id, language_id FROM cat_lang_dump WHERE catalog_id = 0 AND default_language = 1 Show
0.000205 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_4' AND cd.heade Show
0.000201 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_4' AND cd.heade Show
0.000213 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_3' AND cd.heade Show