Elecena SQL log

log.sql

-- bots
SELECT * FROM products WHERE prod_id IN (7205887,7895047,7895046,7989641,9369286,9369287,9369890,9369891,9369895,9369896,9552054,9552055,9557908,9631579,1011753,1035788,1212991,1010860,1010861,1009436,2788153,4583962,1012990,1012987,1012985,1009476,1009477,1009478,1009479,1009480,1009481,1009482,1009484,1009485,1009486,1009488,1009487,1009489,1009483,1010957,1011751,1012979,1012957,1012958,1012959,1009504,1010856,1016005,1010142,1009439,1012944,1009490,1012946,1010141,1010149,1014468,1012963,1012962,1011752,1013029,1010858,1012789,1012971,1012973,1012974,1012975,1012976,1012977,1012978,1014431,1012980,1012948,1010863,1009437,1009438,1010857,1012984,1009741,1010864,1012981,1012982,1009428,1010262,1012992,1010139,1012986,1010305,1010306,1009440,1009442,1009441,1009443,1009444,1012942,1010215,1033572,1012964,1212993,1212994,1009433,1212996,1212995,1212992,1012949,1016007,1016009,1016008,1010169,1031334,1009502,1012956,1012960,1212997,1014286,1010148,1010143,1009422,1009423,1009424,1009425,1009426,1009427,1009431,1009430,1009432,1009434,1009435,1010145,1010146,1009456,1009429,1009455,1009454,1010140,1012995,1010147,1010144,1212999,1016006,1010138,1023017,1029207,1031335,1049756,1049757,1049754,1049755,1212998,1213000,1328334,1347787,1009503,1010855,1699861,2154852,2981465,2981466,2987804,4001308,4100903,4100902,4149674,1012996,4484028,4484027,4570142,4582978,4598193,4599248,4625123,4625122,4625121,4625120,4760934,4791933,4850619,4851080,4866485,4866484,4979400,5003705,5183395,5183393,5183394,5272179,5272659,5272658,5295223,5299417,5312882,5421142,5421141,5630237,5923846,5984259,6027653,6161077,6172681,6217697,6217696)
SELECT prod_id AS id, code FROM products WHERE shop = 99 AND code IN ('6311','3530','2969','1999','9929','9928','7559','7560','7557','7558','7317','8910','9385','1317','4379','6614','7481','1683','8940','4595','7408','6561','9090','9788','655','652','653','654','6532','10485','10483','6873','6874','6875','6876','6877','6878','1985','9304','9305','1833','1834','1835','1836','1837','1838','1839','1850','1840','1841','1842','1844','1843','1845','8859','8572','9301','8571','667','665','5622','7029','8186','6881','6880','6882','6531','6883','6884','2399','2400','2401','1722','4838','4839','3208','6163','6168','6164','6169','6170','8385','8386','445','668','7070','7069','9734','6982','3690','8558','6584','6586','6585','672','4099','4098','6477','4478','4480','4481','4482','4483','4484','4485','5100','9886','1772','2160','4577','5476','5477','8028','7586','9368','3898','8887','7367','7307','588','7112','8874','8873','8872','9512','7701','1832','7992','508','10086','3723','4410','455','1745','5952','8766','1830','1827','3897','8576','9511','8861','1659','3021','8221','10400','9648','5849','10401','9191','6610','6333','6325','10402','10403','10404','10405','8999','9546','10239','9193','9194','10238','6823','7256','8997','6965','6966','7255','6822','7417','9057','816','2484','10468','9403','10469','9016','9015','817','2804','4935','4423','1694','1695','4642','5347','4039','10244','8397','68','7173','8789','6160','6161','8660','8661','5772','9857','866')
SELECT shop_id FROM shops WHERE internal_code = "bujnowicz"
SELECT producer_id FROM producers WHERE name = "SUNON"
-- web
SELECT /* Parameters::newFromCode */ * FROM parameters WHERE code IN ('antyelektrostatyczna') LIMIT 1
SELECT /* Elecena\Models\Product::newFromIds */ prod_id AS id,code,products.name AS name,products.description AS description,producers.producer_id AS producer_id,producers.name AS producer,extra,parameters,url,price AS price_original,price *  currencies.value / (currencies.multiply * 100) AS price,last_price,price_history,products.multiply AS multiply,prices,min_amount,currency,currencies.name AS currency_name,shops.shop_id AS shop_id,shops.internal_code AS shop_code,shops.name AS shop_name,img,img_width,img_height,img_src,added,products.updated AS updated,last_seen FROM products LEFT JOIN shops ON shop_id = shop LEFT JOIN producers ON producer_id = producer LEFT JOIN currencies ON currencies.symbol = currency WHERE prod_id IN ("1698742","2496912","1698743","1698751","5324715","812802","1698745","5057910","5057917","812795","648894","648895","648896","812796","393656","5324713","6411393","173881","5417768","6411392","7534795","872893","2496913","5417774","7534796","7189537","4581921","4427287","4427288","872892","1207402","2960022","1365700","3972178","3952153","693885","2496911","4800578","5151769","5151770","2496910","5135830","5135831","3899945","2100937","2496906","4583832","1005485","8181367","6055352","1324614","10015395") ORDER BY prod_id LIMIT 52
SELECT /* Elecena\Models\Datasheet::newFromIds */ * FROM datasheets WHERE id IN ("221069") ORDER BY code
SELECT /* Elecena\ElecenaHealthcheck::checkBotsQueue */ NOW() - last FROM shops ORDER BY last desc LIMIT 1
SELECT /* Elecena\Models\Datasheet::getOtherCodes */ code FROM datasheets WHERE hash="47ab5eaa016e8954347b7b85963d16ce" AND id <> 145450 LIMIT 30
SELECT /* StatsController::getLastChanges */ prod_id FROM products WHERE prod_id IN ("11181193","11576529","11576532","11576540","11576543","11576546","11576550","11576564","11576576","11576577","11576580","11576581","11576584","11576586","11576591","11576594","11576597","11576605","11576606","11576609","11576613","11576615","11576625","11576628","11576639","11576641","11693923","11693924","11693925","11693926","11693927","11693928","11693929","11693930","11693931","11693932","11693933","11693934","11693935","11693912","11693913","11693914","11693915","11693916","11693917","11693918","11693919","11693920","11693921","11693922","11693894","11693895","11693896","11693897","11693898","11693899","11693900","11693901","11693902","11693903","11693904","11693905","11693906","11693907","11693908","11693909","11693910","11693911","11693862","11693863","11693864","11693865","11693866","11693867","11693868","11693869","11693870","11693871","11693872","11693873","11693874","11693875","11693876","11693877","11693878","11693879","11693880","11693881","11693882","11693883","11693884","11693885","11693886","11693887","11693888","11693889","11693890","11693891","11693892","11693893","11693861","10660660","10843675","11270062","11270063","11270064","10328350","11576304","11576307","11576314","11576317","11576413","11576417","11576429","11576430","11576433","11576446","11576449","11576454","11576455","11576461","11576465","11576466","11576472","11576479","11576488","11576490","11576496","11576498","11576504","11576506","11576507","11576508","11576509","11576510","11693850","11693851","11693852","11693853","11693854","11693855","11693856","11693857","11693858","11693859","11693860","11693831","11693832","11693833","11693834","11693835","11693836","11693837","11693838","11693839","11693840","11693841","11693842","11693843","11693844","11693845","11693846","11693847","11693848","11693849","9745713","9745714","9745715","9745716","9745717","9745718","9745719","9745720","9745721","9745722","9745723","9745724","9745725","9745726","9745727","9745728","9745729","9745730","9745731","9745732","9745733","9745734","9745735","9745736","9745749","9745750","11693830","10959039","10959045","10959046","10959047","10959048","10959049","10959054","10959055","10959056","10959057","10959058","10959059","10959060","10959061","9369644","9369645","9369646","9369647","9369648","9369649","9369650","9369651","9369652","9369653","9369654","9369655","9369656","9369657","9369658","9369659","9369660","9369661","9369662","9369663","9369664","9369665","9369813","9369814","9369815","9369816","9369817","9369818","9369819","9664000","9664101","11181090","11181094","11181099","11181106","11181108","11181111","11181112","11181117","11181118","11181119","11181122","11181124","11181129","11181134","11181135","11181142","11181143","11181150","11181153","11181162","11181165","11181167","11181174","11181175","11181176","11181178","11181182","11181187","11181189","11576260","11576261","11576262")
SELECT /* Parameters::exists */ 1 FROM parameters WHERE code="ncp1207a" LIMIT 1
SELECT /* DatasheetsUpdateScript::checkIfExists */ code FROM datasheets WHERE code="ATSAML22G18A" AND hash="7f7467251afab979d69e5401fca2551b" LIMIT 1
SELECT /* PanelController::index */ shops.shop_id AS shop_id,shops.name AS name,internal_code,last,crawl_ip,crawl_start,crawl_time,count,count_last_seen,shops_stats.name as entry,shops_stats.value as value FROM shops LEFT JOIN shops_stats ON shops.shop_id = shops_stats.shop_id ORDER BY last desc
SELECT /* Elecena\Models\Shop::newFromDB */ shop_id AS id,internal_code AS code,name,site,since,attrs,description,count,views,mid,address,cords FROM shops LEFT JOIN shops_map ON shop_id = shop WHERE count > 0 ORDER BY shop_id
SELECT /* ImageBot::getImagesToFetch */ prod_id,img_src,name,shop FROM products WHERE img = "" AND img_src != "" LIMIT 250
SELECT /* Elecena\Services\Sphinx::getSuggestions */ keyword FROM suggest WHERE keyword LIKE "btb12%" ORDER BY freq DESC LIMIT 7
SELECT /* Indexer::run */ prod_id FROM products WHERE prod_id > "11693935" AND last_seen > NOW() - INTERVAL 3 MONTH ORDER BY prod_id LIMIT 5000
SELECT /* ShopsUpdateScript::run */ * FROM products WHERE shop="196" LIMIT 1
SELECT /* currency.php */ * FROM currencies WHERE symbol="XDR" LIMIT 1
SELECT /* ProductController::getIdsBatch */ prod_id AS id FROM products WHERE prod_id > 11666933 AND last_seen > NOW() - INTERVAL 3 MONTH ORDER BY prod_id LIMIT 500
SELECT /* Parameters::newFromTop */ * FROM parameters WHERE cnt > 2 ORDER BY cnt DESC LIMIT 100 OFFSET 32400
SELECT /* DatasheetController::onSitemapGetLinks */ * FROM datasheets GROUP BY hash ORDER BY size DESC LIMIT 75000