SELECT url_to, r404
                        FROM pod_redirect
                        WHERE BINARY REPLACE(url_from,&#039;/ru/&#039;,&#039;/&#039;) =  &#039;/kukly/o_3.html?order_dir=asc&amp;pg=2&#039; LIMIT 0,1 [0.00059986114501953 sec]<br>

SELECT cf.metaindex, cf.metafollow FROM pod_set_cat_filter cf
                    INNER JOIN pod_filter f ON cf.filter_value_id = f.id
                    INNER JOIN pod_cat_category c ON cf.cat_id = c.id  
                    WHERE f.url = &#039;o_3&#039;
                    AND c.url = &#039;kukly&#039;
                    AND cf.is_active = 1
                    LIMIT 1 [0.00065112113952637 sec]<br>

SELECT cf.metaindex, cf.metafollow FROM pod_set_cat_subicon cf
                        INNER JOIN pod_sub_icon si ON cf.subicon_id = si.id
                        INNER JOIN pod_cat_category c ON cf.cat_id = c.id  
                        WHERE si.url = &#039;o_3&#039;
                        AND c.url = &#039;kukly&#039;
                        AND cf.is_active = 1
                        LIMIT 1 [0.00061583518981934 sec]<br>

DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
CREATE TEMPORARY TABLE tmp_base_goods (id INT NOT NULL PRIMARY KEY) ENGINE=MEMORY [0.0004570484161377 sec]<br>

INSERT INTO tmp_base_goods (id)
            SELECT DISTINCT g.id FROM pod_cat_good g
            WHERE g.cat_id IN (108) AND g.entry=0 AND g.is_active AND g.is_present_all_mods
            UNION
            SELECT DISTINCT g.id FROM pod_cat_good g
            INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
            WHERE dc.dop_cat_id IN (108) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.0070219039916992 sec]<br>

DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods;
CREATE TEMPORARY TABLE tmp_sub_goods (id INT NOT NULL PRIMARY KEY, entry INT NOT NULL, KEY idx_entry (entry)) ENGINE=MEMORY [0.00047492980957031 sec]<br>

INSERT INTO tmp_sub_goods (id, entry)
            SELECT go.id, go.entry FROM pod_cat_good go
            INNER JOIN tmp_base_goods t ON go.entry = t.id
            WHERE go.is_active AND go.is_present [0.0014820098876953 sec]<br>


CREATE TEMPORARY TABLE temp_brand_counts_6a2ac71b53352 (
    id INT,
    gid INT,
    INDEX idx_id (id),
    INDEX idx_gid (gid)
) [0.00030398368835449 sec]<br>


INSERT INTO temp_brand_counts_6a2ac71b53352 (id, gid)

            SELECT g.brand_id AS id, g.id AS gid -- основні (tmp)
            FROM tmp_base_goods t
            INNER JOIN pod_cat_good g ON t.id = g.id
              INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (265)

            WHERE      g.is_present AND
    g.is_present_all_mods AND g.is_active
            
UNION

            SELECT g.brand_id AS id, g.id AS gid -- підтовари (tmp)
            FROM tmp_sub_goods t
            INNER JOIN pod_cat_good go ON t.id = go.id
            INNER JOIN pod_cat_good g ON t.entry = g.id
              INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (265)

            WHERE     go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
            
 [0.028249979019165 sec]<br>


SELECT b.id, b.name_ua AS name, pc.name_ua AS country, b.country_id, 
       b.image_icon, b.url, b.ordr, pc.code, 
       COALESCE(tc.count, 0) as count
FROM pod_cat_brand b
INNER JOIN (
    SELECT id, COUNT(gid) as count
    FROM temp_brand_counts_6a2ac71b53352
    GROUP BY id
    HAVING COUNT(gid) &gt; 0
) tc ON b.id = tc.id
LEFT JOIN pod_country pc ON (pc.id = b.country_id AND pc.is_active = 1)
WHERE b.is_active = &#039;1&#039;
ORDER BY b.ordr [0.00066208839416504 sec]<br>

DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ac71b53352 [0.00026512145996094 sec]<br>

SELECT g.id, if(g.is_present and g.price &gt;= &#039;139&#039; and g.price &lt;= &#039;983&#039;,least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) min_sort_price 
  , if(g.is_present and g.price &gt;= &#039;139&#039; and g.price &lt;= &#039;983&#039;,greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price 
  FROM pod_cat_good g 
  LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id and pcg.is_present=1 and pcg.is_present=1 and pcg.price &gt;= &#039;139&#039; and pcg.price &lt;= &#039;983&#039;    WHERE g.id in (376109,448036,448106,448119,481215,360795,360807,384407,433895,448111,493187,508325,294053,443757,452554,465492,470136,480948,492638,492825,492853,492914,492938,492951,492969,493043,495686,495706,497544,504703)
  GROUP BY g.id
  ORDER BY g.ordr asc 
  LIMIT 32, 32 [0.012750864028931 sec]<br>