SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002719s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=228&page=73&srecordnum=10000' [ RunTime:0.003179s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002693s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000725s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001889s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.004614s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001520s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002474s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.007688s ]
UPDATE `stock_search` SET `count` = 1953 , `updatetime` = '2026-06-12 09:04:58' WHERE `partno` = '228' [ RunTime:0.005421s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000290s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.007572s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002374s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.232353s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1440,20 [ RunTime:0.107024s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32925375','32925374','32925373','32925372','32925371','32925370','32925369','32925368','32925367','32925366','32925365','32925364','32925363','32925362','32925361','32925360','32925359','32925358','32925357','32925356') ORDER BY FIELD(s.id, 32925375,32925374,32925373,32925372,32925371,32925370,32925369,32925368,32925367,32925366,32925365,32925364,32925363,32925362,32925361,32925360,32925359,32925358,32925357,32925356) [ RunTime:0.030239s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925375 LIMIT 4 [ RunTime:0.005642s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925375 ORDER BY `minOrder` ASC [ RunTime:0.026393s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925375 ORDER BY `unit` DESC [ RunTime:0.052434s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925375 LIMIT 2 [ RunTime:0.019274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925375 ORDER BY `minOrder` ASC [ RunTime:0.012509s ]
select * from pdf where partno='228CDVAAWFFAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.020765s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFFAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.077149s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925375 AND `partno` = '228CDVAAWFFAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925374 LIMIT 4 [ RunTime:0.029437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925374 ORDER BY `minOrder` ASC [ RunTime:0.077761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925374 ORDER BY `unit` DESC [ RunTime:0.033164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925374 LIMIT 2 [ RunTime:0.005369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925374 ORDER BY `minOrder` ASC [ RunTime:0.006448s ]
select * from pdf where partno='228CDVARGBFFAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFFAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013084s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925374 AND `partno` = '228CDVARGBFFAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449717 [ RunTime:0.011623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925373 LIMIT 4 [ RunTime:0.030230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925373 ORDER BY `minOrder` ASC [ RunTime:0.034876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925373 ORDER BY `unit` DESC [ RunTime:0.033911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925373 LIMIT 2 [ RunTime:0.041370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925373 ORDER BY `minOrder` ASC [ RunTime:0.024676s ]
select * from pdf where partno='228CDVAAWFDMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFDMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027358s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925373 AND `partno` = '228CDVAAWFDMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366438 [ RunTime:0.006418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925372 LIMIT 4 [ RunTime:0.015547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925372 ORDER BY `minOrder` ASC [ RunTime:0.010195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925372 ORDER BY `unit` DESC [ RunTime:0.011187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925372 LIMIT 2 [ RunTime:0.059285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925372 ORDER BY `minOrder` ASC [ RunTime:0.019340s ]
select * from pdf where partno='228CDVAGFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.032786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028174s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925372 AND `partno` = '228CDVAGFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.038531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449716 [ RunTime:0.020043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925371 LIMIT 4 [ RunTime:0.019043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925371 ORDER BY `minOrder` ASC [ RunTime:0.040963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925371 ORDER BY `unit` DESC [ RunTime:0.018031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925371 LIMIT 2 [ RunTime:0.014376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925371 ORDER BY `minOrder` ASC [ RunTime:0.008976s ]
select * from pdf where partno='228CDVAYFFMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.035626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007703s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925371 AND `partno` = '228CDVAYFFMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366437 [ RunTime:0.032312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925370 LIMIT 4 [ RunTime:0.031743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925370 ORDER BY `minOrder` ASC [ RunTime:0.064983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925370 ORDER BY `unit` DESC [ RunTime:0.048489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925370 LIMIT 2 [ RunTime:0.051179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925370 ORDER BY `minOrder` ASC [ RunTime:0.039022s ]
select * from pdf where partno='228CDVAYFEAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFEAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019072s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925370 AND `partno` = '228CDVAYFEAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366436 [ RunTime:0.042956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925369 LIMIT 4 [ RunTime:0.005979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925369 ORDER BY `minOrder` ASC [ RunTime:0.030503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925369 ORDER BY `unit` DESC [ RunTime:0.017925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925369 LIMIT 2 [ RunTime:0.031893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925369 ORDER BY `minOrder` ASC [ RunTime:0.016865s ]
select * from pdf where partno='228CDVAYFEMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFEMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027595s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925369 AND `partno` = '228CDVAYFEMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366435 [ RunTime:0.010807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925368 LIMIT 4 [ RunTime:0.016492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925368 ORDER BY `minOrder` ASC [ RunTime:0.005691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925368 ORDER BY `unit` DESC [ RunTime:0.019611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925368 LIMIT 2 [ RunTime:0.023196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925368 ORDER BY `minOrder` ASC [ RunTime:0.008786s ]
select * from pdf where partno='228CDVABFAAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVABFAAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018743s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925368 AND `partno` = '228CDVABFAAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449715 [ RunTime:0.032757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925367 LIMIT 4 [ RunTime:0.008560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925367 ORDER BY `minOrder` ASC [ RunTime:0.004360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925367 ORDER BY `unit` DESC [ RunTime:0.002583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925367 LIMIT 2 [ RunTime:0.029509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925367 ORDER BY `minOrder` ASC [ RunTime:0.014668s ]
select * from pdf where partno='228CDVARAFDMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFDMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017694s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925367 AND `partno` = '228CDVARAFDMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.040463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449714 [ RunTime:0.004930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925366 LIMIT 4 [ RunTime:0.020839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925366 ORDER BY `minOrder` ASC [ RunTime:0.030374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925366 ORDER BY `unit` DESC [ RunTime:0.015322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925366 LIMIT 2 [ RunTime:0.030665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925366 ORDER BY `minOrder` ASC [ RunTime:0.008158s ]
select * from pdf where partno='228CDVARGFFWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010829s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925366 AND `partno` = '228CDVARGFFWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366434 [ RunTime:0.041659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925365 LIMIT 4 [ RunTime:0.028003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925365 ORDER BY `minOrder` ASC [ RunTime:0.015344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925365 ORDER BY `unit` DESC [ RunTime:0.009953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925365 LIMIT 2 [ RunTime:0.008944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925365 ORDER BY `minOrder` ASC [ RunTime:0.004641s ]
select * from pdf where partno='228CDVARFARC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFARC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.035298s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925365 AND `partno` = '228CDVARFARC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366433 [ RunTime:0.028828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925364 LIMIT 4 [ RunTime:0.011176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925364 ORDER BY `minOrder` ASC [ RunTime:0.012464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925364 ORDER BY `unit` DESC [ RunTime:0.004612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925364 LIMIT 2 [ RunTime:0.020169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925364 ORDER BY `minOrder` ASC [ RunTime:0.011629s ]
select * from pdf where partno='228CDVARGFDMSA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFDMSA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013066s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925364 AND `partno` = '228CDVARGFDMSA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366432 [ RunTime:0.008668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925363 LIMIT 4 [ RunTime:0.056533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925363 ORDER BY `minOrder` ASC [ RunTime:0.024859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925363 ORDER BY `unit` DESC [ RunTime:0.007455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925363 LIMIT 2 [ RunTime:0.002297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925363 ORDER BY `minOrder` ASC [ RunTime:0.020152s ]
select * from pdf where partno='228CDVARGBFBBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFBBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015989s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925363 AND `partno` = '228CDVARGBFBBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366431 [ RunTime:0.064557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925362 LIMIT 4 [ RunTime:0.027534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925362 ORDER BY `minOrder` ASC [ RunTime:0.061090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925362 ORDER BY `unit` DESC [ RunTime:0.051115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925362 LIMIT 2 [ RunTime:0.016673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925362 ORDER BY `minOrder` ASC [ RunTime:0.066334s ]
select * from pdf where partno='228CDVAYFEMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFEMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036125s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925362 AND `partno` = '228CDVAYFEMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925361 LIMIT 4 [ RunTime:0.050740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925361 ORDER BY `minOrder` ASC [ RunTime:0.050798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925361 ORDER BY `unit` DESC [ RunTime:0.050762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925361 LIMIT 2 [ RunTime:0.050739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925361 ORDER BY `minOrder` ASC [ RunTime:0.050823s ]
select * from pdf where partno='228CDVAWFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.073552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.111900s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925361 AND `partno` = '228CDVAWFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925360 LIMIT 4 [ RunTime:0.021601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925360 ORDER BY `minOrder` ASC [ RunTime:0.030650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925360 ORDER BY `unit` DESC [ RunTime:0.067770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925360 LIMIT 2 [ RunTime:0.089932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925360 ORDER BY `minOrder` ASC [ RunTime:0.074717s ]
select * from pdf where partno='228CDVARGBFDRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.090475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFDRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.111737s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925360 AND `partno` = '228CDVARGBFDRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925359 LIMIT 4 [ RunTime:0.100043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925359 ORDER BY `minOrder` ASC [ RunTime:0.049390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925359 ORDER BY `unit` DESC [ RunTime:0.005857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925359 LIMIT 2 [ RunTime:0.124480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925359 ORDER BY `minOrder` ASC [ RunTime:0.045149s ]
select * from pdf where partno='228CDVAGFDMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.045343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFDMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025106s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925359 AND `partno` = '228CDVAGFDMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.028503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366430 [ RunTime:0.023604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925358 LIMIT 4 [ RunTime:0.026750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925358 ORDER BY `minOrder` ASC [ RunTime:0.009550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925358 ORDER BY `unit` DESC [ RunTime:0.005360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925358 LIMIT 2 [ RunTime:0.012720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925358 ORDER BY `minOrder` ASC [ RunTime:0.001996s ]
select * from pdf where partno='228CDVAWFAMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFAMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010632s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925358 AND `partno` = '228CDVAWFAMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366429 [ RunTime:0.002039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925357 LIMIT 4 [ RunTime:0.001919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925357 ORDER BY `minOrder` ASC [ RunTime:0.004724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925357 ORDER BY `unit` DESC [ RunTime:0.003360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925357 LIMIT 2 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925357 ORDER BY `minOrder` ASC [ RunTime:0.006025s ]
select * from pdf where partno='228CDVARFAMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004714s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925357 AND `partno` = '228CDVARFAMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449713 [ RunTime:0.001131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925356 LIMIT 4 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925356 ORDER BY `minOrder` ASC [ RunTime:0.000918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925356 ORDER BY `unit` DESC [ RunTime:0.002337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925356 LIMIT 2 [ RunTime:0.006039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925356 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
select * from pdf where partno='228CDVARBFFWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARBFFWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005508s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925356 AND `partno` = '228CDVARBFFWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004622s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.079522s ]