motoenvena Posted August 12, 2013 Share Posted August 12, 2013 Hello everyone, I checked the web and there are two particularly slow queries. I point these two queries if you can give me some advice: " Parse Time: 12.822s Current Parse Time: 12.823 s with 459 queries QUERY DEBUG: Array ( [QUERIES] => Array (  => select value from sessions where sesskey = '88d2b2c52b144df681f7b8437b138038' and expiry > '1376319442'  => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies  => select languages_id, name, code, image, directory from languages order by sort_order  => delete from whos_online where time_last_click < '1376318542'  => select count(*) as count from whos_online where session_id = '88d2b2c52b144df681f7b8437b138038'  => update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '184.108.40.206', time_last_click = '1376319442', last_page_url = '/' etc etc etc....  => select distinct products_car_make, products_car_model, products_car_year_bof, products_car_year_eof from products_ymm where products_car_make != '' and products_car_model != '' and products_car_year_bof !=0 and products_car_year_eof != 0 order by products_car_make, products_car_model, products_car_year_bof, products_car_year_eof etc etc etc....  => SELECT cd.categories_alt_imagen, p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name FROM products p LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = '3' LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories_description cd ON p2c.categories_id = cd.categories_id LEFT JOIN featured f ON p.products_id = f.products_id WHERE cd.categories_id = p2c.categories_id and cd.language_id = '3' and p.products_status = '1' AND f.status = '1' order by rand(692469238) DESC limit 9 etc etc etc.... ) [TIME] => Array (  => 0.005322  => 0.001707  => 0.002025  => 0.002469  => 0.002716  => 0.003216 etc etc etc....  => 5.927031 etc etc etc....  => 1.116730 ) ) " Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.