DEVELOPMENT MODE
Previous
Next




SQL Execution Summary (Longest Time to Shortest)

Execution time SQL Chunk
0.003793 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.003338 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.002776 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.001972 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.001911 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.002321 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.002120 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.001975 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.001514 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.000548 seconds SELECT sum(quantity) as qty, SUM(actual_price * quantity) as total FROM cart_items WHERE cart_id='0f00hervo7v99s4pm85giff5e7' Show
0.000531 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=77 AND c.content_id = cs.content_id AND cs.assoc_type='spec Show
0.000601 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.000436 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2382 AND m.active=1 AND m.site_id = s.site_id Show
0.000559 seconds SELECT SQL_CALC_FOUND_ROWS c.content_id,c.content_type,c.locked,cd.modify_date,cd.created_date,cd.approved FROM pure_content c, pure_site_content sc , Show
0.000469 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2379 AND m.active=1 AND m.site_id = s.site_id Show
0.000500 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=77 AND c.content_id = cs.content_id AND cs.language_id = 1 Show
0.000369 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2380 AND m.active=1 AND m.site_id = s.site_id Show
0.000348 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2381 AND m.active=1 AND m.site_id = s.site_id Show
0.000415 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=4074 AND m.active=1 AND m.site_id = s.site_id Show
0.000478 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.000428 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=4076 AND m.active=1 AND m.site_id = s.site_id Show
0.000766 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.000270 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2379 AND m.active=1 AND m.site_id = s.site_id Show
0.000464 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.000390 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 * 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.001120 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.000358 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.000285 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1805 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000311 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.000355 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.000373 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.000255 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.000455 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.000000 seconds update pure_sessions set session_data ='current_catalog|i:0;language_id|i:1;currency_id|i:1;', session_expiration = '1269437461', user_id =null , si Show
0.000286 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.000401 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.000232 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.000422 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.000594 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.000425 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.000302 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.000511 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.000425 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.000392 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.000315 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.000282 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.000264 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.000387 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.000394 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.000306 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.000304 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.000315 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.000489 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.000305 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.000493 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.000296 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.000305 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 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.000341 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.000360 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.000509 seconds SELECT DISTINCT currency_id, currency_name FROM cat_lang_dump WHERE catalog_id = 0 Show
0.000438 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.000315 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.000377 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.000313 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.000320 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.000279 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.000304 seconds SELECT currency_id, language_id FROM cat_lang_dump WHERE catalog_id = 0 AND default_language = 1 Show
0.000321 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.000250 seconds SELECT 1 FROM cat_lang_dump WHERE language_id = 1 AND currency_id = 1 Show
0.000225 seconds SELECT DISTINCT language_id, language_name FROM cat_lang_dump WHERE catalog_id = 0 Show