"Әлемдегі №1 партиялық ойынмен танысыңыз - сөз тыңшылық ойыны Code Names. Бұл ми үшін тамаша жаттығу. Сонымен қатар талғампаз және оңай, жұмбақ және сонымен бірге қарапайым - достарыңызбен көптеген қызықты ойындарды қамтамасыз етеді. , отбасылық және жай ғана кездейсоқ таныстар! Егер сіз әрқашан партияның патшасы және барлаушылардың басшысы ретінде сезінгіңіз келсе және барлау қызметінің басшыларына екіұшты тұсқағаздар бергіңіз келсе, сіздің уақытыңыз келді. Кез келген екі немесе одан да көп компанияға арналған Code Names үстел ойыны сіздің жүйкеңізді бұзады!"
"Әлемдегі №1 партиялық ойынмен танысыңыз - сөз тыңшылық ойыны Code Names. Бұл ми үшін тамаша жаттығу. Сонымен қатар талғампаз және оңай, жұмбақ және сонымен бірге қарапайым - достарыңызбен көптеген қызықты ойындарды қамтамасыз етеді. , отбасылық және жай ғана кездейсоқ таныстар! Егер сіз әрқашан партияның патшасы және барлаушылардың басшысы ретінде сезінгіңіз келсе және барлау қызметінің басшыларына екіұшты тұсқағаздар бергіңіз келсе, сіздің уақытыңыз келді. Кез келген екі немесе одан да көп компанияға арналған Code Names үстел ойыны сіздің жүйкеңізді бұзады!"
DEBUG enable Num SQL queries:56 Num fetched rows:164 including array rows:14 Time of script run:0.17629313468933 Time of SQL queries:0.16314315795898 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.0024с Счетчик "ModIshopGood Good statistic", время выполнения - 0с Счетчик "ModIshopGood bread", время выполнения - 0.0008с Счетчик "ModIshopGood photos", время выполнения - 0.0013с Счетчик "ModIshopGood main data", время выполнения - 0.0026с Счетчик "ModIshopGood params", время выполнения - 0.0074с Счетчик "ModIshopGood Nalichie", время выполнения - 0.151с Счетчик "ModIshopGood mklass", время выполнения - 0.0001с Счетчик "Start GetDeliveryList", время выполнения - 0с Счетчик "Get DeliveryList from cache", время выполнения - 0.0001с Счетчик "DeliveryList transforms", время выполнения - 0.0001с Счетчик "ModIshopGood delivery", время выполнения - 0с Счетчик "Module=ishop", время выполнения - 0.1638с Счетчик "Block=stat", время выполнения - 0с Счетчик "Block=cssstylescard", время выполнения - 0с Счетчик "Block=headcardjs", время выполнения - 0с Счетчик "Block=header", время выполнения - 0.0001с Счетчик "Block=catalogtree", время выполнения - 0.0005с Счетчик "Block=retailrocketblocks", время выполнения - 0.0001с Счетчик "Block=footer", время выполнения - 0.0002с Счетчик "Block=appdownload", время выполнения - 0.0001с Счетчик "Block=footercardjs", время выполнения - 0.0001с Счетчик "Block=ganalitics", время выполнения - 0.0001с Счетчик "Block=metrika", время выполнения - 0.0001с Счетчик "Block=jivosite", время выполнения - 0.0001с Счетчик "Block=statmailru", время выполнения - 0.0001с
SELECT * FROM leo_clients_unregistered WHERE register_code='cb76e1ed41eb2ba670a70d9bd11a122a65640be9' # Num rows 1Run time:Time of run:0.00035619735717773
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/good_33982937532/" AND active = 1 # Num rows 0Run time:Time of run:0.00018215179443359
SELECT geo_city FROM leo_clients_unregistered WHERE client_id=567301897 LIMIT 1; # Num rows 1Run time:Time of run:0.00014495849609375
SELECT id_city,path,name,ishop_id,ishop_name,kladr_id,country_id,utc,largest_dep_id,final_sale FROM leo_city WHERE id_city=0 # Num rows 0Run time:Time of run:0.00017404556274414
SELECT id_city FROM leo_city_preffered WHERE city='Astana' ORDER BY `lock` DESC,countEnt DESC LIMIT 1; # Num rows -1Run time:Time of run:0.0001828670501709
SELECT id_city,path,name,ishop_id,ishop_name,kladr_id,country_id,utc,largest_dep_id,final_sale FROM leo_city WHERE path='astana'; # Num rows 1Run time:Time of run:0.00017094612121582
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=0 AND alias
LIKE 'ishop' LIMIT 1; # Num rows 1Run time:Time of run:0.00017714500427246
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'good_33982937532' LIMIT 1; # Num rows 0Run time:Time of run:0.00016617774963379
SELECT IFNULL(NULLIF(lil.title,""), li.title) as title,li.template_id,li.content,li.domen,li.index_id
FROM leonardo_kz_ru.leo_index AS li LEFT JOIN leonardo_kz_ru.leo_index_lang AS lil ON li.index_id=lil.index_id AND lil.lang="kz" WHERE li.index_id=2; # Num rows 1Run time:Time of run:0.0002140998840332
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00020098686218262
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00013589859008789
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = 567301897 # Num rows 1Run time:Time of run:0.00012993812561035
SELECT t2.id_detail,t2.id_good,CONCAT_WS(' ',t4.f_tree_fullname,t1.goodname,t2.detailname) AS f1,CONCAT_WS('\n\n',t1.gooddescr,t6.detaildescr) AS f2, 0 AS none ,t1.id_tree,t1.dimension,t1.price, NULL, t1.f_tree_id
FROM leonardo_kz.leo_details AS t2
LEFT JOIN leonardo_kz.leo_goods AS t1 ON t2.id_good=t1.id_good
LEFT JOIN leonardo_kz.leo_tistree AS t4 ON t4.f_tree_id=t1.f_tree_id
LEFT JOIN leo_detail_desc AS t6 ON t2.id_detail=t6.id_detail
WHERE t2.id_detail=33982937532 ORDER BY f1; # Num rows 1Run time:Time of run:0.00030303001403809
SELECT
t1.id_tree,IFNULL(NULLIF(lt1.treename,""),t1.treename) as treename,
t2.id_tree,IFNULL(NULLIF(lt2.treename,""),t2.treename) as treename,
t3.id_tree,IFNULL(NULLIF(lt3.treename,""),t3.treename) as treename,
t4.id_tree,IFNULL(NULLIF(lt4.treename,""),t4.treename) as treename,
t5.id_tree,IFNULL(NULLIF(lt5.treename,""),t5.treename) as treename
FROM leo_tree_goods AS tn
LEFT JOIN leo_tree AS t1 ON tn.id_tree=t1.id_tree
LEFT JOIN leo_tree AS t2 ON t1.shop_tree_id=t2.id_tree
LEFT JOIN leo_tree AS t3 ON t2.shop_tree_id=t3.id_tree
LEFT JOIN leo_tree AS t4 ON t3.shop_tree_id=t4.id_tree
LEFT JOIN leo_tree AS t5 ON t4.shop_tree_id=t5.id_tree
LEFT JOIN leo_tree_lang AS lt1 ON t1.id_tree=lt1.id_tree AND lt1.lang = "kz"
LEFT JOIN leo_tree_lang AS lt2 ON t2.id_tree=lt2.id_tree AND lt2.lang = "kz"
LEFT JOIN leo_tree_lang AS lt3 ON t3.id_tree=lt3.id_tree AND lt3.lang = "kz"
LEFT JOIN leo_tree_lang AS lt4 ON t1.id_tree=lt4.id_tree AND lt4.lang = "kz"
LEFT JOIN leo_tree_lang AS lt5 ON t1.id_tree=lt5.id_tree AND lt5.lang = "kz"
WHERE tn.id_good=33982936172 # Num rows 1Run time:Time of run:0.00044012069702148
SELECT t1.id,t1.discount_id,t1.discount_value,t1.discountprice_value,t1.discount_from,t1.discountcode,t1.discount_start,t2.discount_description,t2.discount_type FROM leo_clients_discounts_unregistered AS t1 LEFT JOIN leo_discounts AS t2 ON t1.discount_id=t2.discount_id WHERE t1.client_id=567301897 AND t1.discount_start<NOW() AND t1.discount_end>NOW(); # Num rows 0Run time:Time of run:0.00025320053100586
SELECT t2.FileName FROM images.detail_photo AS t2 WHERE DetailId=33982937532 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 1Run time:Time of run:0.00026583671569824
SELECT FileName FROM images.goods_photo WHERE GoodId=33982936172 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 0Run time:Time of run:0.00024104118347168
SELECT videolink,preview FROM images.goods_video WHERE GoodId=33982936172 AND (DetailId=0 OR DetailId=33982937532) # Num rows 0Run time:Time of run:0.00018095970153809
SELECT * FROM leo_goods_params AS t1,leo_actions AS t2 WHERE t1.id_good=33982936172 AND t1.id_param=-5 AND t1.value=t2.tisname AND t2.typeid > 0 AND t2.visible = 1 AND startaction<NOW() AND endaction>NOW() AND (t2.region=0 || t2.region=3) # Num rows 0Run time:Time of run:0.0018110275268555
SELECT count(*) FROM `leo_details` AS t1, leo_goods_params AS t2 WHERE t1.`id_good`=t2.id_good AND t1.`id_detail` = 33982937532 AND t2.id_param=72250129794 # Num rows 1Run time:Time of run:0.00026893615722656
SELECT t2.id_detail,t2.detailname,t2.colorcode, t3.goodname
FROM leonardo_kz.leo_details AS t2
LEFT JOIN leonardo_kz.leo_goods AS t3 ON t2.id_good=t3.id_good
WHERE t2.id_good=33982936172 GROUP BY t2.id_detail
ORDER BY t2.detailname ASC # Num rows 1Run time:Time of run:0.00024294853210449
SELECT t2.name,t1.value,t1.id_param
FROM leonardo_kz.leo_goods_params AS t1
LEFT JOIN leonardo_kz.params AS t2 ON t1.id_param=t2.id_param
WHERE t1.id_good=33982936172 AND t1.id_param!=-5 ORDER BY t2.name,t1.value; # Num rows 20Run time:Time of run:0.00035715103149414
SELECT t2.name,t1.value, t1.id_param
FROM leonardo_kz.leo_details_params AS t1
LEFT JOIN leonardo_kz.paramsd AS t2 ON t1.id_param=t2.id_param
WHERE t1.id_detail=33982937532 ORDER BY t2.name,t1.value; # Num rows 3Run time:Time of run:0.00022101402282715
SELECT t2.filename, t2.id_purpose, t2.id_good, t2.id_detail, t2.filetype FROM images.goodfiles AS t2 WHERE (id_good = 33982936172 OR id_detail = 33982937532) AND t2.filename LIKE "%.pdf%" ORDER BY t2.filename # Num rows 0Run time:Time of run:0.00024199485778809
SELECT t1.count,t2.price,t4.goodname,t3.detailname,t1.id_detail,t5.f_tree_fullname,t2.sizes,tz.sizes,t4.discount,t4.dimension,t3.id_good,t1.market_source,t1.market_type,t1.market_id, t4.nds,t1.waited FROM leo_cart_unregistered AS t1 LEFT JOIN tis_dep AS t2 ON t1.id_detail=t2.code AND t2.dep_id=401 LEFT JOIN tis_dep AS tz ON t1.id_detail=tz.code AND tz.dep_id=1 LEFT JOIN leo_details AS t3 ON t1.id_detail=t3.id_detail LEFT JOIN leo_goods AS t4 ON t3.id_good=t4.id_good LEFT JOIN leo_tistree AS t5 ON t4.f_tree_id=t5.f_tree_id WHERE t1.client_id=567301897; # Num rows 0Run time:Time of run:0.0003199577331543
SELECT * FROM leo_actions AS t1 WHERE t1.visible=1 AND t1.startaction<NOW() AND t1.endaction>NOW() AND (t1.region=0 || t1.region=3) # Num rows 4Run time:Time of run:0.0005488395690918
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Распродажа декупажной бумаги 2024" # Num rows 4Run time:Time of run:0.0039970874786377
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Семь дней выгоды" # Num rows 85Run time:Time of run:0.00030088424682617
SELECT t1.id,t1.discount_id,t1.discount_value,t1.discountprice_value,t1.discount_from,t1.discountcode,t1.discount_start,t2.discount_description FROM leo_clients_discounts_unregistered AS t1 LEFT JOIN leo_discounts AS t2 ON t1.discount_id=t2.discount_id WHERE t1.client_id=567301897 AND t1.discount_start<NOW() AND t1.discount_end>NOW() AND t1.discount_from<=0 ORDER BY t1.id DESC LIMIT 1; # Num rows 0Run time:Time of run:0.000244140625
SELECT * FROM images.good_links WHERE id_good=33982936172 # Num rows 1Run time:Time of run:0.00016212463378906
SELECT * FROM images.good_links WHERE id_good=33982936172 # Num rows 1Run time:Time of run:0.00014996528625488
SELECT * FROM images.goodlinks WHERE id_goodlink = 33982936172 OR id_good=33982936172 # Num rows 2Run time:Time of run:0.040438890457153
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=33982936172 AND id_goodlink!=33982936172 AND linktype=3110748592 GROUP BY `id_goodlink`
UNION ALL
SELECT id_good AS id_goods,id_detail FROM images.goodlinks WHERE id_good!=33982936172 AND id_goodlink=33982936172 AND linktype=3110748592 GROUP BY `id_good`
)T GROUP BY id_goods # Num rows 2Run time:Time of run:0.10541081428528
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=50699065392 LIMIT 1; # Num rows 1Run time:Time of run:0.00048398971557617
SELECT count(*) FROM leo_goods_params WHERE `id_good` = 50699065392 AND id_param=65531636804 # Num rows 1Run time:Time of run:0.00022697448730469
SELECT SQL_NO_CACHE id_good,detailname,id_detail,prepic,detailsrating FROM leo_details WHERE id_good=50699065392 LIMIT 1; # Num rows 1Run time:Time of run:0.00017809867858887
SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leo_details_price WHERE id_detail=50699073122 AND id_city=46 # Num rows 1Run time:Time of run:0.00016593933105469
SELECT value FROM leo_reviews_onpages_details WHERE id_detail=50699073122; # Num rows -1Run time:Time of run:0.00013208389282227
SELECT `rating` FROM `leo_reviews` WHERE `detail_id` = 50699073122 AND `status` = 1 # Num rows 0Run time:Time of run:0.00019097328186035
SELECT UNIX_TIMESTAMP(newtime) FROM leo_newdetails WHERE detail_id = 50699073122 # Num rows 1Run time:Time of run:0.00014996528625488
SELECT value FROM leo_reviews_onpages WHERE id_good=50699065392; # Num rows 1Run time:Time of run:0.00013399124145508
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 50699065392 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013208389282227
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=54892780292 LIMIT 1; # Num rows 1Run time:Time of run:0.00022006034851074
SELECT count(*) FROM leo_goods_params WHERE `id_good` = 54892780292 AND id_param=65531636804 # Num rows 1Run time:Time of run:0.00016403198242188
SELECT SQL_NO_CACHE id_good,detailname,id_detail,prepic,detailsrating FROM leo_details WHERE id_good=54892780292 LIMIT 1; # Num rows 1Run time:Time of run:0.00014805793762207
SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leo_details_price WHERE id_detail=54892780612 AND id_city=46 # Num rows 1Run time:Time of run:0.00017118453979492
SELECT value FROM leo_reviews_onpages_details WHERE id_detail=54892780612; # Num rows -1Run time:Time of run:0.00013518333435059
SELECT `rating` FROM `leo_reviews` WHERE `detail_id` = 54892780612 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013184547424316
SELECT UNIX_TIMESTAMP(newtime) FROM leo_newdetails WHERE detail_id = 54892780612 # Num rows 1Run time:Time of run:0.00013494491577148
SELECT value FROM leo_reviews_onpages WHERE id_good=54892780292; # Num rows 1Run time:Time of run:0.00017690658569336
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 54892780292 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013399124145508
SELECT * FROM images.goodlinks WHERE id_good=33982936172 # Num rows 1Run time:Time of run:0.00014305114746094
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=33982936172 AND id_goodlink!=33982936172 AND linktype=105 GROUP BY `id_goodlink`
)T GROUP BY id_goods # Num rows 0Run time:Time of run:0.0002131462097168
SELECT leo_mclasses.* FROM leo_mclasses,leo_mclasses_goods,leo_details WHERE visible=1 AND leo_mclasses.id=leo_mclasses_goods.id_mclasses AND (leo_mclasses_goods.id_detail=33982937532 OR leo_mclasses_goods.id_good=leo_details.id_good) AND leo_details.id_detail=33982937532 GROUP BY leo_mclasses.id ORDER BY leo_mclasses.id DESC LIMIT 5; # Num rows 0Run time:Time of run:0.00049996376037598
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=21 # Num rows 1Run time:Time of run:0.0001678466796875
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/good_33982937532/" AND active = 1 # Num rows 0Run time:Time of run:0.00017094612121582