رفتن به مطلب

seo.nik.shop

عضو انجمن
  • تعداد ارسال ها

    1
  • تاریخ عضویت

  • آخرین بازدید

پست ها ارسال شده توسط seo.nik.shop

  1. سلام.

    من مشکل باقی ماندن کئری های دیتابیس سایت برای مدت طولانی در حافظه رو دارم.

    نمونه از لاگ های یک کوئری در حافظه مانده به صورت زیر میباشد :

     

     9898641    atlanti1_user@localhost/atlanti1_arsh    Query    53840    Sending data
    ┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄
    SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ps1767_product p LEFT JOIN ps1767_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps1767_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps1767_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps1767_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps1767_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps1767_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps1767_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps1767_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps1767_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps1767_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value=36894)) AND ((fp_1.id_feature_value=36889)) AND ((fp_2.id_feature_value=36900)) AND p.visibility IN ('both', 'catalog') AND c.nleft>=13 AND c.nright<=14 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps1767_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps1767_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps1767_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN ps1767_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=14)) AND ((fp_1.id_feature_value=36894)) AND ((fp_2.id_feature_value=36889)) AND ((fp_3.id_feature_value=36900)) GROUP BY fp.id_feature_value
×
×
  • اضافه کردن...