DEVELOPMENT MODE
Previous
Next




SQL Execution Summary (Longest Time to Shortest)

Execution time SQL Chunk
0.001286 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2368 AND m.active=1 AND m.site_id = s.site_id Show
0.000843 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.000417 seconds SELECT sum(quantity) as qty, SUM(actual_price * quantity) as total FROM cart_items WHERE cart_id='ja29p1nc2j61l78rrfsef2fa33' Show
0.000416 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.000395 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.000464 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.000389 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.000368 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.000285 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.000395 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3078 AND m.active=1 AND m.site_id = s.site_id Show
0.000258 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.000338 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2370 AND m.active=1 AND m.site_id = s.site_id Show
0.000331 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3079 AND m.active=1 AND m.site_id = s.site_id Show
0.000206 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.000265 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.000265 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.000250 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.000268 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.000270 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.000295 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.000000 seconds update pure_sessions set session_data ='current_catalog|i:0;language_id|i:1;currency_id|i:1;', session_expiration = '1265872878', user_id =null , si Show
0.000202 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.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.000205 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.000890 seconds SHOW TABLES Show
0.000205 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.000203 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.000218 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.000204 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.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.000206 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.000206 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.000207 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.000203 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.000203 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.000206 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.000206 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.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.000295 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.000216 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.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.000219 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1391 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000264 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.000278 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.000216 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.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.000272 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.000213 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.000273 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.000282 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.000208 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.000209 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.000204 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.000435 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.000203 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.000263 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.000208 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.000208 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.000251 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.000209 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.000251 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.000207 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.000250 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.000260 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.000257 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.000197 seconds SELECT DISTINCT currency_id, currency_name FROM cat_lang_dump WHERE catalog_id = 0 Show
0.000197 seconds SELECT DISTINCT language_id, language_name FROM cat_lang_dump WHERE catalog_id = 0 Show
0.000191 seconds SELECT 1 FROM cat_lang_dump WHERE language_id = 1 AND currency_id = 1 Show
0.000197 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.000198 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.000197 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.000199 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