MySQL server has gone away , query:
SELECT m.*,b.depot_id,b.token token_auth FROM `parts_markup` m
LEFT JOIN billing_shipper b ON m.id_shipper=b.id
Error DB:
MySQL server has gone away , query:
SELECT p.* FROM `parts_markup_pricegrid` p
Error DB:
MySQL server has gone away , query:
SELECT * FROM `parts_markup_add` LIMIT 1
Error DB:
MySQL server has gone away , query: SELECT * FROM `billing_shipper` WHERE `is_delete`=0 AND `id` NOT IN (28,71,24,86)
Error DB:
MySQL server has gone away , query:
SELECT
DISTINCT cpv.*
FROM
(SELECT brand_oem_search,shipper_id FROM `catalog_crosses_vendors` WHERE `brand_other_oem_search`='1883025980' OR brand_oem_search='1883025980') ccv
LEFT JOIN `catalog_parts_vendors` cpv ON (cpv.part_search='1883025980' OR cpv.part_search=ccv.brand_oem_search) AND cpv.shipper_id=ccv.shipper_id
WHERE (cpv.part_search='1883025980' OR cpv.part_search=ccv.brand_oem_search) AND cpv.availble!=''
AND cpv.shipper_id IN (
SELECT id FROM `billing_shipper` WHERE id IN (12,7,10,13,14,15,16,17,18,19,20,21,24,25,26,27,28,29,35,36,37,38,39,41,43,44,2,47,50,53,54,55,56,58,57,59,63,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,82,83,84,85,86) AND `is_delete`=0
) LIMIT 100
Error DB:
MySQL server has gone away , query: SELECT DISTINCT val1,val2 FROM `word_sinonim` WHERE 1=1 AND ( val1 ='1883025980' )
Error DB:
MySQL server has gone away , query: SELECT DISTINCT
p_local.price price_local,
p_local.price_old price_local_old,
c.*,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.`id_good` AND cp.`id_discount_group`=14 ) price_krs_retail,
if( (SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN(2,4,5,10,11,12,14,15,16,17,18,19) ) > 0 , 1, 0) total_availble,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (4,19) ) av_retail_uss_shops,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (19) ) av_retail_komar,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (14) ) av_krs_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (15) ) av_hbr_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (16) ) av_komar_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (17) ) av_vl_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (18) ) av_art_opt,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.id_good AND cp.`id_discount_group`= 5) price_vl_retail,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.id_good AND cp.`id_discount_group`=4 ) price_krs_opt,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.id_good AND cp.`id_discount_group`=4 ) price_hbr_opt,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (2,17) ) av_vl,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (10,15) ) av_hbr,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (11,14) ) av_krs,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (12,18) ) av_art,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN ( SELECT `id` FROM `catalog_shops` WHERE `depot_id`=5 AND `is_retail`=1 ) ) av_uss,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=5 AND `user`='95f1477f42a2cf8cd7415d6a3bb2b9d1' AND `user`!='' ) inbasketuss,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=1 AND `user`='95f1477f42a2cf8cd7415d6a3bb2b9d1' AND `user`!='' ) inbasketvl,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=3 AND `user`='95f1477f42a2cf8cd7415d6a3bb2b9d1' AND `user`!='' ) inbaskethbr,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=4 AND `user`='95f1477f42a2cf8cd7415d6a3bb2b9d1' AND `user`!='' ) inbasketkrs,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=6 AND `user`='95f1477f42a2cf8cd7415d6a3bb2b9d1' AND `user`!='' ) inbasketart,
p_vl.price price_vl,
p_vl.price_old price_vl_old,
IF( c.markingsearch = '1883025980' , 1, 0 ) is_m_equality,
p_krs.price price_krs,
p_krs.price_old price_krs_old,
IF(
(
(
c.markingsearch LIKE '1883025980'
OR c.name='1883025980'
OR (SELECT COUNT(*) FROM catalog_oem WHERE (oemsearch LIKE '1883025980%' OR oem='1883025980' ) AND `id_good`=c.`id` ) > 0
OR c.searchindex LIKE '%1883025980%'
OR ( ( c.name LIKE '%1883025980%') )
OR ( ( CONCAT_WS(' ', c.f_name, c.mark,c.model,c.chassis,c.engine,c.f_body) LIKE '%1883025980%') )
OR ( ( replace(c.`searchindex`,' ','') LIKE '%1883025980%') )
OR ( ( replace(c.`searchindex`,' ','') LIKE '%1883025980%') )
)
),
1,0
) st,
IF(
(
(
c.markingsearch LIKE '1883025980'
OR ( SELECT COUNT(*) FROM catalog_oem WHERE (oemsearch LIKE '1883025980%' OR oem='1883025980' ) AND `id_good`=c.`id` ) > 0
OR ( ( replace(c.searchindex,' ','') LIKE '%1883025980%') )
)
),
1,0
) morf,
b.brand,
cg.name `group_name`,
(SELECT oem FROM catalog_oem WHERE (oemsearch LIKE '1883025980%' OR oem='1883025980' ) AND `id_good`=c.`id` LIMIT 1) oemtarget,
(SELECT GROUP_CONCAT(DISTINCT co.oem ORDER BY co.oem ASC SEPARATOR ', ') FROM catalog_oem co WHERE co.`id_good`=c.`id` ) oem
FROM `catalog` c
LEFT JOIN `brands` b ON c.brand_id=b.id
LEFT JOIN `catalog_groups` cg ON c.id_group=cg.id
LEFT JOIN `catalog_price` p_vl ON c.id=p_vl.id_good AND p_vl.`id_discount_group`= 5
LEFT JOIN `catalog_price` p_local ON c.id=p_local.id_good AND p_local.`id_discount_group`= 5
LEFT JOIN `catalog_price` p_krs ON c.id=p_krs.id_good AND p_krs.`id_discount_group`= 14
WHERE ( p_vl.price>0 OR p_krs.price>0 OR (SELECT COUNT(*) FROM `catalog_future` WHERE id1c = c.id_1c AND datein > NOW())>0) AND
( c.is_delete=0 AND
(c.hideavailble=0 OR (c.hideavailble =1
AND (SELECT SUM(cda.avail) sum FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id`)>0 ) ))
AND (
c.markingsearch LIKE '1883025980%'
OR c.name = '1883025980'
OR c.id IN ( SELECT id_good FROM catalog_oem WHERE oemsearch LIKE '1883025980%' OR oem='1883025980')
OR ( ( c.name LIKE '%1883025980%') )
OR
( ( CONCAT_WS(' ', c.f_name, c.mark,c.model,c.chassis,c.engine,c.f_body) LIKE '%1883025980%') )
)
AND (
(SELECT
COUNT(*) cnt
FROM `catalog_avail` cda
WHERE
cda.`date_in` !=''
AND cda.`date_in` IS NOT NULL
AND cda.`id_good`=c.`id`
AND cda.`id_shop` IN (SELECT `id` FROM `catalog_shops` WHERE 1=1 AND `is_opt`=1 )
)>0
OR (p_vl.`price`>0 OR p_krs.`price`>0 OR (SELECT COUNT(*) FROM `catalog_future` WHERE id1c = c.id_1c AND datein > NOW())>0 ) )
ORDER BY is_m_equality DESC,morf DESC,st DESC,av_vl DESC ,c.id
Error DB:
MySQL server has gone away , query: SELECT * FROM `catalog_depots` WHERE `id`=5
Error DB:
MySQL server has gone away , query: INSERT INTO `search_stat` (term,ip,client_id,is_local,is_1c,is_api)
VALUES ('1-88302-598-0','3628718161',0,0,0,0)
