Najem orodja

Array
(
    [0] => MySQL server has gone away
    [1] => MySQL server has gone away
    [2] => MySQL server has gone away
    [3] => MySQL server has gone away
    [4] => MySQL server has gone away
    [5] => MySQL server has gone away
    [6] => MySQL server has gone away
)

Array
(
    [0] => 
			SELECT
				sp.id AS product_id,
				sad.s_attribute_id AS attribute_id,
				sad.name AS attribute_name,
				a.range_slider,
				savd.s_attribute_value_id AS attribute_value_id,
				savd.name AS attribute_value_name,
				savd.value AS attribute_value_value,
				savd.description AS attribute_value_desc,
				sa2sav.id AS sa2sav_id,
				COUNT(sp.id) AS cnt
			FROM s_product sp
				JOIN s_product_desc spdd ON(sp.id = spdd.s_product_id AND spdd.language_id='1')
				JOIN s_product_extras spe ON(sp.id = spe.product_id )
				JOIN s_product_extras2s_attribute2s_attribute_value spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)
				JOIN s_attribute2s_attribute_value sa2sav ON (sa2sav.id = spe2sa2sav.s_attribute2s_attribute_value_id)
				JOIN s_attribute a ON (a.id = sa2sav.attribute_id )
				JOIN s_attribute_desc sad ON (sa2sav.attribute_id = sad.s_attribute_id AND sad.language_id='1')
				JOIN s_attribute_value_desc savd ON (sa2sav.attribute_value_id = savd.s_attribute_value_id AND savd.language_id='1')
			WHERE  sp.active = 1
				
				
			GROUP BY attribute_id, attribute_value_id
			ORDER BY sa2sav.position1, attribute_name ASC, CAST(attribute_value_name AS UNSIGNED), attribute_value_name + 0 ASC, attribute_value_name ASC
		
    [1] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 1464
        
    [2] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id=1464 ORDER BY position
    [3] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
                    FROM s_product AS sp
                    JOIN s_product_extras spe ON(sp.id = spe.product_id)
                    JOIN s_product_pivot AS pivot ON (sp.id=pivot.product_id AND spe.id=pivot.product_extras_id )
                     JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464))
                    JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)

                    WHERE 1=1
                        AND sp.active=1
                        
                        AND IFNULL(sp.hidden,0)=0

                    GROUP BY s_attribute2s_attribute_value_id, spe.product_id
                    
    [4] => SELECT COUNT(distinct sp.id) AS cnt,
                       MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price,
                       MIN(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS min_price
                           
           FROM s_product sp
           JOIN s_product_extras spe ON (sp.id = spe.product_id)
            JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464))WHERE sp.active = 1 AND IFNULL(sp.hidden,0) = 0 
    [5] => SELECT sp.id AS id 
           FROM s_product sp
           JOIN s_product_extras spe ON (sp.id = spe.product_id)
            JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464)) 	LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id=1)
                           LEFT JOIN system_url su ON(su.pkey_value = sp.id AND su.table='s_product')
                           LEFT JOIN system_url_desc sud ON(su.id = sud.system_url_id)
                           
                           LEFT JOIN s_manufacturer sm ON sp.manufacturer_id = sm.id
                           LEFT JOIN s_manufacturer_desc smd ON (sm.id = smd.s_manufacturer_id AND smd.language_id = 1)
           WHERE sp.active = 1 AND IFNULL(sp.hidden,0) = 0  GROUP BY sp.id  ORDER BY sp2sc.position, id ASC LIMIT 0, 100 
    [6] => SELECT
					p.id AS product_id,
					c.quantity AS quantity,
					c.id AS cart_id,
					c.item_data,
					pe.id AS pe_id,
					pe.pic_nr AS pic_nr,
					pe.ean
			    FROM s_cart AS c
					JOIN s_product_extras AS pe ON (pe.id = c.item_id  )
					JOIN s_product AS p ON (pe.product_id = p.id AND p.active = 1)
				AND c.token = 'af7ee9225c3967891815603f2083e3570d8d62c6e9dbab7eca777dfaec67dd204baa22204cd0b5102bcb4e00d34107aa842163cedf19d4db79272eb10d9efae5'
				AND c.item_type='product'
				WHERE 1=1 
				ORDER BY c.id
)

Košarica

Prijava

Array
(
    [0] => MySQL server has gone away
    [1] => MySQL server has gone away
    [2] => MySQL server has gone away
    [3] => MySQL server has gone away
    [4] => MySQL server has gone away
    [5] => MySQL server has gone away
    [6] => MySQL server has gone away
    [7] => MySQL server has gone away
)

Array
(
    [0] => 
			SELECT
				sp.id AS product_id,
				sad.s_attribute_id AS attribute_id,
				sad.name AS attribute_name,
				a.range_slider,
				savd.s_attribute_value_id AS attribute_value_id,
				savd.name AS attribute_value_name,
				savd.value AS attribute_value_value,
				savd.description AS attribute_value_desc,
				sa2sav.id AS sa2sav_id,
				COUNT(sp.id) AS cnt
			FROM s_product sp
				JOIN s_product_desc spdd ON(sp.id = spdd.s_product_id AND spdd.language_id='1')
				JOIN s_product_extras spe ON(sp.id = spe.product_id )
				JOIN s_product_extras2s_attribute2s_attribute_value spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)
				JOIN s_attribute2s_attribute_value sa2sav ON (sa2sav.id = spe2sa2sav.s_attribute2s_attribute_value_id)
				JOIN s_attribute a ON (a.id = sa2sav.attribute_id )
				JOIN s_attribute_desc sad ON (sa2sav.attribute_id = sad.s_attribute_id AND sad.language_id='1')
				JOIN s_attribute_value_desc savd ON (sa2sav.attribute_value_id = savd.s_attribute_value_id AND savd.language_id='1')
			WHERE  sp.active = 1
				
				
			GROUP BY attribute_id, attribute_value_id
			ORDER BY sa2sav.position1, attribute_name ASC, CAST(attribute_value_name AS UNSIGNED), attribute_value_name + 0 ASC, attribute_value_name ASC
		
    [1] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 1464
        
    [2] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id=1464 ORDER BY position
    [3] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
                    FROM s_product AS sp
                    JOIN s_product_extras spe ON(sp.id = spe.product_id)
                    JOIN s_product_pivot AS pivot ON (sp.id=pivot.product_id AND spe.id=pivot.product_extras_id )
                     JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464))
                    JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)

                    WHERE 1=1
                        AND sp.active=1
                        
                        AND IFNULL(sp.hidden,0)=0

                    GROUP BY s_attribute2s_attribute_value_id, spe.product_id
                    
    [4] => SELECT COUNT(distinct sp.id) AS cnt,
                       MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price,
                       MIN(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS min_price
                           
           FROM s_product sp
           JOIN s_product_extras spe ON (sp.id = spe.product_id)
            JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464))WHERE sp.active = 1 AND IFNULL(sp.hidden,0) = 0 
    [5] => SELECT sp.id AS id 
           FROM s_product sp
           JOIN s_product_extras spe ON (sp.id = spe.product_id)
            JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464)) 	LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id=1)
                           LEFT JOIN system_url su ON(su.pkey_value = sp.id AND su.table='s_product')
                           LEFT JOIN system_url_desc sud ON(su.id = sud.system_url_id)
                           
                           LEFT JOIN s_manufacturer sm ON sp.manufacturer_id = sm.id
                           LEFT JOIN s_manufacturer_desc smd ON (sm.id = smd.s_manufacturer_id AND smd.language_id = 1)
           WHERE sp.active = 1 AND IFNULL(sp.hidden,0) = 0  GROUP BY sp.id  ORDER BY sp2sc.position, id ASC LIMIT 0, 100 
    [6] => SELECT
					p.id AS product_id,
					c.quantity AS quantity,
					c.id AS cart_id,
					c.item_data,
					pe.id AS pe_id,
					pe.pic_nr AS pic_nr,
					pe.ean
			    FROM s_cart AS c
					JOIN s_product_extras AS pe ON (pe.id = c.item_id  )
					JOIN s_product AS p ON (pe.product_id = p.id AND p.active = 1)
				AND c.token = 'af7ee9225c3967891815603f2083e3570d8d62c6e9dbab7eca777dfaec67dd204baa22204cd0b5102bcb4e00d34107aa842163cedf19d4db79272eb10d9efae5'
				AND c.item_type='product'
				WHERE 1=1 
				ORDER BY c.id
    [7] => SELECT
					p.id AS product_id,
					c.quantity AS quantity,
					c.id AS cart_id,
					c.item_data,
					pe.id AS pe_id,
					pe.pic_nr AS pic_nr,
					pe.ean
			    FROM s_cart AS c
					JOIN s_product_extras AS pe ON (pe.id = c.item_id  )
					JOIN s_product AS p ON (pe.product_id = p.id AND p.active = 1)
				AND c.token = 'af7ee9225c3967891815603f2083e3570d8d62c6e9dbab7eca777dfaec67dd204baa22204cd0b5102bcb4e00d34107aa842163cedf19d4db79272eb10d9efae5'
				AND c.item_type='product'
				WHERE 1=1 
				ORDER BY c.id
)

Košarica

Array
(
    [0] => MySQL server has gone away
    [1] => MySQL server has gone away
    [2] => MySQL server has gone away
    [3] => MySQL server has gone away
    [4] => MySQL server has gone away
    [5] => MySQL server has gone away
    [6] => MySQL server has gone away
    [7] => MySQL server has gone away
    [8] => MySQL server has gone away
    [9] => MySQL server has gone away
)

Array
(
    [0] => 
			SELECT
				sp.id AS product_id,
				sad.s_attribute_id AS attribute_id,
				sad.name AS attribute_name,
				a.range_slider,
				savd.s_attribute_value_id AS attribute_value_id,
				savd.name AS attribute_value_name,
				savd.value AS attribute_value_value,
				savd.description AS attribute_value_desc,
				sa2sav.id AS sa2sav_id,
				COUNT(sp.id) AS cnt
			FROM s_product sp
				JOIN s_product_desc spdd ON(sp.id = spdd.s_product_id AND spdd.language_id='1')
				JOIN s_product_extras spe ON(sp.id = spe.product_id )
				JOIN s_product_extras2s_attribute2s_attribute_value spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)
				JOIN s_attribute2s_attribute_value sa2sav ON (sa2sav.id = spe2sa2sav.s_attribute2s_attribute_value_id)
				JOIN s_attribute a ON (a.id = sa2sav.attribute_id )
				JOIN s_attribute_desc sad ON (sa2sav.attribute_id = sad.s_attribute_id AND sad.language_id='1')
				JOIN s_attribute_value_desc savd ON (sa2sav.attribute_value_id = savd.s_attribute_value_id AND savd.language_id='1')
			WHERE  sp.active = 1
				
				
			GROUP BY attribute_id, attribute_value_id
			ORDER BY sa2sav.position1, attribute_name ASC, CAST(attribute_value_name AS UNSIGNED), attribute_value_name + 0 ASC, attribute_value_name ASC
		
    [1] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 1464
        
    [2] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id=1464 ORDER BY position
    [3] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
                    FROM s_product AS sp
                    JOIN s_product_extras spe ON(sp.id = spe.product_id)
                    JOIN s_product_pivot AS pivot ON (sp.id=pivot.product_id AND spe.id=pivot.product_extras_id )
                     JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464))
                    JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)

                    WHERE 1=1
                        AND sp.active=1
                        
                        AND IFNULL(sp.hidden,0)=0

                    GROUP BY s_attribute2s_attribute_value_id, spe.product_id
                    
    [4] => SELECT COUNT(distinct sp.id) AS cnt,
                       MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price,
                       MIN(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS min_price
                           
           FROM s_product sp
           JOIN s_product_extras spe ON (sp.id = spe.product_id)
            JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464))WHERE sp.active = 1 AND IFNULL(sp.hidden,0) = 0 
    [5] => SELECT sp.id AS id 
           FROM s_product sp
           JOIN s_product_extras spe ON (sp.id = spe.product_id)
            JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN (1464)) 	LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id=1)
                           LEFT JOIN system_url su ON(su.pkey_value = sp.id AND su.table='s_product')
                           LEFT JOIN system_url_desc sud ON(su.id = sud.system_url_id)
                           
                           LEFT JOIN s_manufacturer sm ON sp.manufacturer_id = sm.id
                           LEFT JOIN s_manufacturer_desc smd ON (sm.id = smd.s_manufacturer_id AND smd.language_id = 1)
           WHERE sp.active = 1 AND IFNULL(sp.hidden,0) = 0  GROUP BY sp.id  ORDER BY sp2sc.position, id ASC LIMIT 0, 100 
    [6] => SELECT
					p.id AS product_id,
					c.quantity AS quantity,
					c.id AS cart_id,
					c.item_data,
					pe.id AS pe_id,
					pe.pic_nr AS pic_nr,
					pe.ean
			    FROM s_cart AS c
					JOIN s_product_extras AS pe ON (pe.id = c.item_id  )
					JOIN s_product AS p ON (pe.product_id = p.id AND p.active = 1)
				AND c.token = 'af7ee9225c3967891815603f2083e3570d8d62c6e9dbab7eca777dfaec67dd204baa22204cd0b5102bcb4e00d34107aa842163cedf19d4db79272eb10d9efae5'
				AND c.item_type='product'
				WHERE 1=1 
				ORDER BY c.id
    [7] => SELECT
					p.id AS product_id,
					c.quantity AS quantity,
					c.id AS cart_id,
					c.item_data,
					pe.id AS pe_id,
					pe.pic_nr AS pic_nr,
					pe.ean
			    FROM s_cart AS c
					JOIN s_product_extras AS pe ON (pe.id = c.item_id  )
					JOIN s_product AS p ON (pe.product_id = p.id AND p.active = 1)
				AND c.token = 'af7ee9225c3967891815603f2083e3570d8d62c6e9dbab7eca777dfaec67dd204baa22204cd0b5102bcb4e00d34107aa842163cedf19d4db79272eb10d9efae5'
				AND c.item_type='product'
				WHERE 1=1 
				ORDER BY c.id
    [8] => SELECT COUNT(*) AS cnt FROM information_schema.TABLES
			 WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'system_user_identity'
    [9] => 
			 SELECT  uf.id as uploader_file_id, uf2x.x_id, uf2x.position, uf2x.x_table, uf2x.type, uf.id, uf.config_id ,uf.filename, uf.fullpath, uf.password, ufd.language_id, ufd.naziv, ufd.opis, uf.hotspots
			 FROM uploader_file2x AS uf2x
			 JOIN uploader_file AS uf ON(uf2x.uploader_file_id = uf.id)
			 LEFT JOIN uploader_file_desc AS ufd ON (uf.id = ufd.uploader_file_id)
			 WHERE uf2x.x_id = '106'
			 AND uf2x.x_table = 'standalone_text'
			 AND uf2x.type = 'pics_standalone'
			 AND (ufd.language_id = 1 OR ufd.language_id IS NULL)
			 ORDER BY uf2x.position
		 
)

Prijava na e-novice

Prijavite se na e-novice in bodite obveščeni o novostih in eksluzivnih ponudbah.

Domov
/ Blagovne znamke
/ Rems
/ Rezanje in posnemanje
/ Elekt. in baterijski rezalci za cevi

Elekt. in baterijski rezalci za cevi

V izbrani kategoriji ni izdelkov.

Vaša nakupovalna košarica

Vaša nakupovalna košarica

Prijava na e-novice

Elekt. in baterijski rezalci za cevi