DEVELOPMENT MODE

Photo Books & Prints

Photo Books & Prints





SQL Execution Summary (Longest Time to Shortest)

Execution time SQL Chunk
0.007094 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.002487 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.001588 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.000908 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.000577 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.000590 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.000630 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.000386 seconds SELECT sum(quantity) as qty, SUM(actual_price * quantity) as total FROM cart_items WHERE cart_id='3ssu4f7q9c6kn11dr1mmbkhna5' Show
0.000385 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.000397 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.000377 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.000572 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.000443 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.000369 seconds SELECT 0 as assoc_key, 0 as cat_level, 0 as cat_rank, '' as cat_name1, '' as cat_name2, '' as cat_name3, '' as cat_name4, '' as cat_name5, 0 as cat_ke Show
0.000330 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.000527 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.000502 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.000397 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.000370 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.000398 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.000247 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.000288 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.000381 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.000403 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.000459 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.000333 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.000217 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.000496 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.000378 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.000539 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.000360 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.000416 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.000431 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.000000 seconds update pure_sessions set session_data ='current_catalog|i:0;language_id|i:1;currency_id|i:1;', session_expiration = '1268503945', user_id =null , si Show
0.000374 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.000481 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.000547 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.000494 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.000451 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.000380 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.000367 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.000363 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1852 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000498 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.000434 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.000475 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1411 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000333 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.000366 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.000360 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.000361 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.000418 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.000487 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.000629 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
0.000389 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.000413 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.000286 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.000266 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.000476 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_6' AND cd.heade Show
0.000252 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.000253 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.000351 seconds SELECT DISTINCT currency_id, currency_name FROM cat_lang_dump WHERE catalog_id = 0 Show
0.000256 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.000364 seconds SELECT currency_id, language_id FROM cat_lang_dump WHERE catalog_id = 0 AND default_language = 1 Show
0.000379 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.000248 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.000254 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.000374 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.000276 seconds SELECT 1 FROM cat_lang_dump WHERE language_id = 1 AND currency_id = 1 Show