SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002052s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.194' , `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=HC-1&search=1' [ RunTime:0.002018s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002274s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003868s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002589s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.194' ) [ RunTime:0.001769s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002253s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002261s ]
SELECT * FROM `stock_search` WHERE `partno` = 'HC-1' LIMIT 1 [ RunTime:0.010353s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-03 05:16:39' WHERE `partno` = 'HC-1' [ RunTime:0.001828s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002104s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018486s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11612114 LIMIT 5 [ RunTime:0.001230s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11612114 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11612114 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11612114 LIMIT 2 [ RunTime:0.003263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11612114 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='HC-1.25-4A'limit 1 [ RunTime:0.011672s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-4A' OR `brand` LIKE '国产米色弯针%' ) ) LIMIT 1 [ RunTime:0.008745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4028 LIMIT 5 [ RunTime:0.002730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4028 ORDER BY `minOrder` ASC [ RunTime:0.011282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4028 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4028 LIMIT 2 [ RunTime:0.011229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4028 ORDER BY `minOrder` ASC [ RunTime:0.002482s ]
select * from pdf where partno='HC-1S' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.015744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1S' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.019964s ]
SELECT `id` FROM `stock` WHERE `id` <> 4028 AND `partno` = 'HC-1S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.007690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013597 LIMIT 5 [ RunTime:0.006871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013597 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19013597 ORDER BY `unit` DESC [ RunTime:0.010170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19013597 LIMIT 2 [ RunTime:0.002001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013597 ORDER BY `minOrder` ASC [ RunTime:0.006471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014326 LIMIT 5 [ RunTime:0.006619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014326 ORDER BY `minOrder` ASC [ RunTime:0.016966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19014326 ORDER BY `unit` DESC [ RunTime:0.003863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19014326 LIMIT 2 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014326 ORDER BY `minOrder` ASC [ RunTime:0.001389s ]
select * from pdf where partno='HC-14104' and brandshort='Bud Industries' limit 1 [ RunTime:0.001196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055341 LIMIT 5 [ RunTime:0.002943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055341 ORDER BY `minOrder` ASC [ RunTime:0.016726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17055341 ORDER BY `unit` DESC [ RunTime:0.006791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17055341 LIMIT 2 [ RunTime:0.009313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055341 ORDER BY `minOrder` ASC [ RunTime:0.012214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19015112 LIMIT 5 [ RunTime:0.001718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19015112 ORDER BY `minOrder` ASC [ RunTime:0.018631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19015112 ORDER BY `unit` DESC [ RunTime:0.017872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19015112 LIMIT 2 [ RunTime:0.007522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19015112 ORDER BY `minOrder` ASC [ RunTime:0.007161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19017281 LIMIT 5 [ RunTime:0.004215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19017281 ORDER BY `minOrder` ASC [ RunTime:0.004616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19017281 ORDER BY `unit` DESC [ RunTime:0.010187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19017281 LIMIT 2 [ RunTime:0.003658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19017281 ORDER BY `minOrder` ASC [ RunTime:0.005791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508553 LIMIT 5 [ RunTime:0.005789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508553 ORDER BY `minOrder` ASC [ RunTime:0.003740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19508553 ORDER BY `unit` DESC [ RunTime:0.021920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19508553 LIMIT 2 [ RunTime:0.018256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508553 ORDER BY `minOrder` ASC [ RunTime:0.004618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508494 LIMIT 5 [ RunTime:0.023164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508494 ORDER BY `minOrder` ASC [ RunTime:0.022250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19508494 ORDER BY `unit` DESC [ RunTime:0.004048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19508494 LIMIT 2 [ RunTime:0.016915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508494 ORDER BY `minOrder` ASC [ RunTime:0.008259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19276776 LIMIT 5 [ RunTime:0.011925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19276776 ORDER BY `minOrder` ASC [ RunTime:0.009996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19276776 ORDER BY `unit` DESC [ RunTime:0.010024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19276776 LIMIT 2 [ RunTime:0.005355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19276776 ORDER BY `minOrder` ASC [ RunTime:0.004400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19016593 LIMIT 5 [ RunTime:0.010991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19016593 ORDER BY `minOrder` ASC [ RunTime:0.006729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19016593 ORDER BY `unit` DESC [ RunTime:0.003107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19016593 LIMIT 2 [ RunTime:0.013766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19016593 ORDER BY `minOrder` ASC [ RunTime:0.007330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014790 LIMIT 5 [ RunTime:0.020961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014790 ORDER BY `minOrder` ASC [ RunTime:0.006555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19014790 ORDER BY `unit` DESC [ RunTime:0.007547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19014790 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014790 ORDER BY `minOrder` ASC [ RunTime:0.007142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014715 LIMIT 5 [ RunTime:0.003333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014715 ORDER BY `minOrder` ASC [ RunTime:0.003199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19014715 ORDER BY `unit` DESC [ RunTime:0.005065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19014715 LIMIT 2 [ RunTime:0.006812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014715 ORDER BY `minOrder` ASC [ RunTime:0.002532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014517 LIMIT 5 [ RunTime:0.017729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014517 ORDER BY `minOrder` ASC [ RunTime:0.005711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19014517 ORDER BY `unit` DESC [ RunTime:0.000845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19014517 LIMIT 2 [ RunTime:0.011808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014517 ORDER BY `minOrder` ASC [ RunTime:0.008311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014399 LIMIT 5 [ RunTime:0.019153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014399 ORDER BY `minOrder` ASC [ RunTime:0.030080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19014399 ORDER BY `unit` DESC [ RunTime:0.028971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19014399 LIMIT 2 [ RunTime:0.013936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014399 ORDER BY `minOrder` ASC [ RunTime:0.010697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014270 LIMIT 5 [ RunTime:0.012651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014270 ORDER BY `minOrder` ASC [ RunTime:0.001932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19014270 ORDER BY `unit` DESC [ RunTime:0.021769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19014270 LIMIT 2 [ RunTime:0.022496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19014270 ORDER BY `minOrder` ASC [ RunTime:0.006212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17145397 LIMIT 5 [ RunTime:0.009238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17145397 ORDER BY `minOrder` ASC [ RunTime:0.005868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17145397 ORDER BY `unit` DESC [ RunTime:0.026480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17145397 LIMIT 2 [ RunTime:0.006388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17145397 ORDER BY `minOrder` ASC [ RunTime:0.007692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055653 LIMIT 5 [ RunTime:0.018682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055653 ORDER BY `minOrder` ASC [ RunTime:0.018549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17055653 ORDER BY `unit` DESC [ RunTime:0.007570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17055653 LIMIT 2 [ RunTime:0.015138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055653 ORDER BY `minOrder` ASC [ RunTime:0.014862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055244 LIMIT 5 [ RunTime:0.011344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055244 ORDER BY `minOrder` ASC [ RunTime:0.007712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17055244 ORDER BY `unit` DESC [ RunTime:0.024060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17055244 LIMIT 2 [ RunTime:0.009488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055244 ORDER BY `minOrder` ASC [ RunTime:0.001156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15365360 LIMIT 5 [ RunTime:0.021918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15365360 ORDER BY `minOrder` ASC [ RunTime:0.007096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15365360 ORDER BY `unit` DESC [ RunTime:0.004477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15365360 LIMIT 2 [ RunTime:0.005362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15365360 ORDER BY `minOrder` ASC [ RunTime:0.005114s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218544 LIMIT 5 [ RunTime:0.002512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218544 ORDER BY `minOrder` ASC [ RunTime:0.016132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218544 ORDER BY `unit` DESC [ RunTime:0.008651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218544 LIMIT 2 [ RunTime:0.003277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218544 ORDER BY `minOrder` ASC [ RunTime:0.012341s ]
select * from pdf where partno='hc-14108' and brandshort='bud industries' limit 1 [ RunTime:0.016423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14108' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.004463s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218544 AND `partno` = 'hc-14108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.027087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014715 [ RunTime:0.016012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218502 LIMIT 5 [ RunTime:0.016446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218502 ORDER BY `minOrder` ASC [ RunTime:0.005838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218502 ORDER BY `unit` DESC [ RunTime:0.020808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218502 LIMIT 2 [ RunTime:0.012524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218502 ORDER BY `minOrder` ASC [ RunTime:0.004470s ]
select * from pdf where partno='hc-14103' and brandshort='bud industries' limit 1 [ RunTime:0.030121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14103' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.008549s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218502 AND `partno` = 'hc-14103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.007168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013597 [ RunTime:0.009084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077796 LIMIT 5 [ RunTime:0.006174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077796 ORDER BY `minOrder` ASC [ RunTime:0.008292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077796 ORDER BY `unit` DESC [ RunTime:0.007440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077796 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077796 ORDER BY `minOrder` ASC [ RunTime:0.001774s ]
select * from pdf where partno='hc-14097' and brandshort='bud industries' limit 1 [ RunTime:0.005293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14097' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.002800s ]
SELECT `id` FROM `stock` WHERE `id` <> 51077796 AND `partno` = 'hc-14097' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.010962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19017281 [ RunTime:0.002992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077663 LIMIT 5 [ RunTime:0.003068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077663 ORDER BY `minOrder` ASC [ RunTime:0.009849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077663 ORDER BY `unit` DESC [ RunTime:0.019587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077663 LIMIT 2 [ RunTime:0.013259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077663 ORDER BY `minOrder` ASC [ RunTime:0.013236s ]
select * from pdf where partno='hc-14102' and brandshort='bud industries' limit 1 [ RunTime:0.013666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14102' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.012253s ]
SELECT `id` FROM `stock` WHERE `id` <> 51077663 AND `partno` = 'hc-14102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.023293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014399 [ RunTime:0.007305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218507 LIMIT 5 [ RunTime:0.008803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218507 ORDER BY `minOrder` ASC [ RunTime:0.003184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218507 ORDER BY `unit` DESC [ RunTime:0.004099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218507 LIMIT 2 [ RunTime:0.002035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218507 ORDER BY `minOrder` ASC [ RunTime:0.012843s ]
select * from pdf where partno='hc-14101' and brandshort='bud industries' limit 1 [ RunTime:0.011407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14101' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.016357s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218507 AND `partno` = 'hc-14101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.007308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19016593 [ RunTime:0.004114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077561 LIMIT 5 [ RunTime:0.004494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077561 ORDER BY `minOrder` ASC [ RunTime:0.008287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077561 ORDER BY `unit` DESC [ RunTime:0.010535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077561 LIMIT 2 [ RunTime:0.016533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077561 ORDER BY `minOrder` ASC [ RunTime:0.005793s ]
select * from pdf where partno='hc-14098' and brandshort='bud industries' limit 1 [ RunTime:0.005333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14098' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.019322s ]
SELECT `id` FROM `stock` WHERE `id` <> 51077561 AND `partno` = 'hc-14098' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.006917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055244 [ RunTime:0.015329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218523 LIMIT 5 [ RunTime:0.004717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218523 ORDER BY `minOrder` ASC [ RunTime:0.009629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218523 ORDER BY `unit` DESC [ RunTime:0.009516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218523 LIMIT 2 [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218523 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='hc-14106' and brandshort='bud industries' limit 1 [ RunTime:0.004717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14106' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.011255s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218523 AND `partno` = 'hc-14106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.019173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014517 [ RunTime:0.006465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218508 LIMIT 5 [ RunTime:0.004298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218508 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218508 ORDER BY `unit` DESC [ RunTime:0.010014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218508 LIMIT 2 [ RunTime:0.008505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218508 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='hc-14104' and brandshort='bud industries' limit 1 [ RunTime:0.004521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14104' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.005054s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218508 AND `partno` = 'hc-14104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.023669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014326 [ RunTime:0.016968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218510 LIMIT 5 [ RunTime:0.002616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218510 ORDER BY `minOrder` ASC [ RunTime:0.001303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218510 ORDER BY `unit` DESC [ RunTime:0.009548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218510 LIMIT 2 [ RunTime:0.025629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218510 ORDER BY `minOrder` ASC [ RunTime:0.016051s ]
select * from pdf where partno='hc-14099' and brandshort='bud industries' limit 1 [ RunTime:0.024921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14099' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.036391s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218510 AND `partno` = 'hc-14099' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.010405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055341 [ RunTime:0.001370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218509 LIMIT 5 [ RunTime:0.015729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218509 ORDER BY `minOrder` ASC [ RunTime:0.010250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218509 ORDER BY `unit` DESC [ RunTime:0.010760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218509 LIMIT 2 [ RunTime:0.027876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218509 ORDER BY `minOrder` ASC [ RunTime:0.003554s ]
select * from pdf where partno='hc-14105' and brandshort='bud industries' limit 1 [ RunTime:0.001770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14105' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.019276s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218509 AND `partno` = 'hc-14105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.010625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055653 [ RunTime:0.013299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218524 LIMIT 5 [ RunTime:0.017315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218524 ORDER BY `minOrder` ASC [ RunTime:0.011841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218524 ORDER BY `unit` DESC [ RunTime:0.005875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218524 LIMIT 2 [ RunTime:0.016345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218524 ORDER BY `minOrder` ASC [ RunTime:0.012999s ]
select * from pdf where partno='hc-14107' and brandshort='bud industries' limit 1 [ RunTime:0.032283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hc-14107' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.040846s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218524 AND `partno` = 'hc-14107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.006092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19015112 [ RunTime:0.009513s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56668251 LIMIT 5 [ RunTime:0.019667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668251 ORDER BY `minOrder` ASC [ RunTime:0.013250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56668251 ORDER BY `unit` DESC [ RunTime:0.005923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56668251 LIMIT 2 [ RunTime:0.017696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668251 ORDER BY `minOrder` ASC [ RunTime:0.008844s ]
select * from pdf where partno='HC-14103' and brandshort='Bud Industries' limit 1 [ RunTime:0.013841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14103' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.021008s ]
SELECT `id` FROM `stock` WHERE `id` <> 56668251 AND `partno` = 'HC-14103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.019946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013597 [ RunTime:0.009000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56668295 LIMIT 5 [ RunTime:0.011061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668295 ORDER BY `minOrder` ASC [ RunTime:0.030635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56668295 ORDER BY `unit` DESC [ RunTime:0.016307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56668295 LIMIT 2 [ RunTime:0.010341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668295 ORDER BY `minOrder` ASC [ RunTime:0.007235s ]
select * from pdf where partno='HC-14099' and brandshort='Bud Industries' limit 1 [ RunTime:0.006353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14099' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.011150s ]
SELECT `id` FROM `stock` WHERE `id` <> 56668295 AND `partno` = 'HC-14099' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.008691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055341 [ RunTime:0.004211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56668870 LIMIT 5 [ RunTime:0.006098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668870 ORDER BY `minOrder` ASC [ RunTime:0.033133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56668870 ORDER BY `unit` DESC [ RunTime:0.013606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56668870 LIMIT 2 [ RunTime:0.010956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668870 ORDER BY `minOrder` ASC [ RunTime:0.001606s ]
select * from pdf where partno='HC-14104' and brandshort='Bud Industries' limit 1 [ RunTime:0.004265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14104' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.001905s ]
SELECT `id` FROM `stock` WHERE `id` <> 56668870 AND `partno` = 'HC-14104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.007897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014326 [ RunTime:0.013884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56668798 LIMIT 5 [ RunTime:0.009492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668798 ORDER BY `minOrder` ASC [ RunTime:0.021110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56668798 ORDER BY `unit` DESC [ RunTime:0.014962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56668798 LIMIT 2 [ RunTime:0.009050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668798 ORDER BY `minOrder` ASC [ RunTime:0.003525s ]
select * from pdf where partno='HC-14101' and brandshort='Bud Industries' limit 1 [ RunTime:0.006933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14101' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.014624s ]
SELECT `id` FROM `stock` WHERE `id` <> 56668798 AND `partno` = 'HC-14101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.005973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19016593 [ RunTime:0.003068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56668978 LIMIT 5 [ RunTime:0.001864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668978 ORDER BY `minOrder` ASC [ RunTime:0.006233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56668978 ORDER BY `unit` DESC [ RunTime:0.027049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56668978 LIMIT 2 [ RunTime:0.003595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56668978 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
select * from pdf where partno='HC-14107' and brandshort='Bud Industries' limit 1 [ RunTime:0.012523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14107' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.014193s ]
SELECT `id` FROM `stock` WHERE `id` <> 56668978 AND `partno` = 'HC-14107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.020866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19015112 [ RunTime:0.017113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58339804 LIMIT 5 [ RunTime:0.021283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58339804 ORDER BY `minOrder` ASC [ RunTime:0.008983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58339804 ORDER BY `unit` DESC [ RunTime:0.018727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58339804 LIMIT 2 [ RunTime:0.014821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58339804 ORDER BY `minOrder` ASC [ RunTime:0.008019s ]
select * from pdf where partno='HC-12B' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.030282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-12B' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010460s ]
SELECT `id` FROM `stock` WHERE `id` <> 58339804 AND `partno` = 'HC-12B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.014491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58339387 LIMIT 5 [ RunTime:0.014589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58339387 ORDER BY `minOrder` ASC [ RunTime:0.036079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58339387 ORDER BY `unit` DESC [ RunTime:0.034216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58339387 LIMIT 2 [ RunTime:0.008085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58339387 ORDER BY `minOrder` ASC [ RunTime:0.007308s ]
select * from pdf where partno='HC-12B' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-12B' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.016825s ]
SELECT `id` FROM `stock` WHERE `id` <> 58339387 AND `partno` = 'HC-12B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.002460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11250356 [ RunTime:0.018211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56678631 LIMIT 5 [ RunTime:0.005675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678631 ORDER BY `minOrder` ASC [ RunTime:0.051230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56678631 ORDER BY `unit` DESC [ RunTime:0.005818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56678631 LIMIT 2 [ RunTime:0.011753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678631 ORDER BY `minOrder` ASC [ RunTime:0.013067s ]
select * from pdf where partno='HC-10/60-200' and brandshort='Omega' limit 1 [ RunTime:0.023771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-10/60-200' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.029687s ]
SELECT `id` FROM `stock` WHERE `id` <> 56678631 AND `partno` = 'HC-10/60-200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.006159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508553 [ RunTime:0.007901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56678520 LIMIT 5 [ RunTime:0.003742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678520 ORDER BY `minOrder` ASC [ RunTime:0.017247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56678520 ORDER BY `unit` DESC [ RunTime:0.011980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56678520 LIMIT 2 [ RunTime:0.042231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678520 ORDER BY `minOrder` ASC [ RunTime:0.004013s ]
select * from pdf where partno='HC-10/40-100' and brandshort='Omega' limit 1 [ RunTime:0.018669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-10/40-100' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.016193s ]
SELECT `id` FROM `stock` WHERE `id` <> 56678520 AND `partno` = 'HC-10/40-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.058222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508494 [ RunTime:0.017320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56678508 LIMIT 5 [ RunTime:0.033580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678508 ORDER BY `minOrder` ASC [ RunTime:0.041486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56678508 ORDER BY `unit` DESC [ RunTime:0.031306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56678508 LIMIT 2 [ RunTime:0.024449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56678508 ORDER BY `minOrder` ASC [ RunTime:0.031643s ]
select * from pdf where partno='HC-10/30-125' and brandshort='Omega' limit 1 [ RunTime:0.020612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-10/30-125' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.010067s ]
SELECT `id` FROM `stock` WHERE `id` <> 56678508 AND `partno` = 'HC-10/30-125' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.014736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56670977 LIMIT 5 [ RunTime:0.008408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670977 ORDER BY `minOrder` ASC [ RunTime:0.022466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56670977 ORDER BY `unit` DESC [ RunTime:0.005987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56670977 LIMIT 2 [ RunTime:0.007501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670977 ORDER BY `minOrder` ASC [ RunTime:0.007623s ]
select * from pdf where partno='HC-14109' and brandshort='Bud Industries' limit 1 [ RunTime:0.010317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14109' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.000984s ]
SELECT `id` FROM `stock` WHERE `id` <> 56670977 AND `partno` = 'HC-14109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.006316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014790 [ RunTime:0.009706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56670871 LIMIT 5 [ RunTime:0.005910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670871 ORDER BY `minOrder` ASC [ RunTime:0.008558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56670871 ORDER BY `unit` DESC [ RunTime:0.007695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56670871 LIMIT 2 [ RunTime:0.013658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670871 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='HC-14108' and brandshort='Bud Industries' limit 1 [ RunTime:0.020067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14108' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.037299s ]
SELECT `id` FROM `stock` WHERE `id` <> 56670871 AND `partno` = 'HC-14108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.011948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014715 [ RunTime:0.005709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56670600 LIMIT 5 [ RunTime:0.009252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670600 ORDER BY `minOrder` ASC [ RunTime:0.016324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56670600 ORDER BY `unit` DESC [ RunTime:0.006231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56670600 LIMIT 2 [ RunTime:0.010441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670600 ORDER BY `minOrder` ASC [ RunTime:0.005878s ]
select * from pdf where partno='HC-14106' and brandshort='Bud Industries' limit 1 [ RunTime:0.008867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14106' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.018137s ]
SELECT `id` FROM `stock` WHERE `id` <> 56670600 AND `partno` = 'HC-14106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.013583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014517 [ RunTime:0.002103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56670466 LIMIT 5 [ RunTime:0.003628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670466 ORDER BY `minOrder` ASC [ RunTime:0.017983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56670466 ORDER BY `unit` DESC [ RunTime:0.002617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56670466 LIMIT 2 [ RunTime:0.005448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670466 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
select * from pdf where partno='HC-14102' and brandshort='Bud Industries' limit 1 [ RunTime:0.017082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14102' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.001099s ]
SELECT `id` FROM `stock` WHERE `id` <> 56670466 AND `partno` = 'HC-14102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.007917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014399 [ RunTime:0.008703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56670418 LIMIT 5 [ RunTime:0.003047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670418 ORDER BY `minOrder` ASC [ RunTime:0.003358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56670418 ORDER BY `unit` DESC [ RunTime:0.016418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56670418 LIMIT 2 [ RunTime:0.005543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670418 ORDER BY `minOrder` ASC [ RunTime:0.003725s ]
select * from pdf where partno='HC-14098' and brandshort='Bud Industries' limit 1 [ RunTime:0.009013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14098' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.012743s ]
SELECT `id` FROM `stock` WHERE `id` <> 56670418 AND `partno` = 'HC-14098' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.006057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055244 [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56670396 LIMIT 5 [ RunTime:0.005643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670396 ORDER BY `minOrder` ASC [ RunTime:0.006067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56670396 ORDER BY `unit` DESC [ RunTime:0.004375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56670396 LIMIT 2 [ RunTime:0.010575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56670396 ORDER BY `minOrder` ASC [ RunTime:0.006230s ]
select * from pdf where partno='HC-14100' and brandshort='Bud Industries' limit 1 [ RunTime:0.003677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14100' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.004601s ]
SELECT `id` FROM `stock` WHERE `id` <> 56670396 AND `partno` = 'HC-14100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.019519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19014270 [ RunTime:0.010237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56669207 LIMIT 5 [ RunTime:0.014090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56669207 ORDER BY `minOrder` ASC [ RunTime:0.019101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56669207 ORDER BY `unit` DESC [ RunTime:0.006406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56669207 LIMIT 2 [ RunTime:0.010715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56669207 ORDER BY `minOrder` ASC [ RunTime:0.004395s ]
select * from pdf where partno='HC-14105' and brandshort='Bud Industries' limit 1 [ RunTime:0.003904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14105' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.004697s ]
SELECT `id` FROM `stock` WHERE `id` <> 56669207 AND `partno` = 'HC-14105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.010338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055653 [ RunTime:0.004500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56669089 LIMIT 5 [ RunTime:0.015702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56669089 ORDER BY `minOrder` ASC [ RunTime:0.029420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56669089 ORDER BY `unit` DESC [ RunTime:0.008043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56669089 LIMIT 2 [ RunTime:0.008387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56669089 ORDER BY `minOrder` ASC [ RunTime:0.004728s ]
select * from pdf where partno='HC-14097' and brandshort='Bud Industries' limit 1 [ RunTime:0.009372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-14097' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.010330s ]
SELECT `id` FROM `stock` WHERE `id` <> 56669089 AND `partno` = 'HC-14097' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.015856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19017281 [ RunTime:0.004410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780264 LIMIT 5 [ RunTime:0.003648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780264 ORDER BY `minOrder` ASC [ RunTime:0.020325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780264 ORDER BY `unit` DESC [ RunTime:0.001840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780264 LIMIT 2 [ RunTime:0.013247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780264 ORDER BY `minOrder` ASC [ RunTime:0.013239s ]
select * from pdf where partno='HC-1/115VDC' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1/115VDC' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000793s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780264 AND `partno` = 'HC-1/115VDC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780244 LIMIT 5 [ RunTime:0.007886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780244 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780244 ORDER BY `unit` DESC [ RunTime:0.013364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780244 LIMIT 2 [ RunTime:0.003576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780244 ORDER BY `minOrder` ASC [ RunTime:0.007055s ]
select * from pdf where partno='HC-1/12VDC' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1/12VDC' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005241s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780244 AND `partno` = 'HC-1/12VDC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004539s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004730s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012122s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006117s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014065s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002892s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012175s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018505 LIMIT 5 [ RunTime:0.015851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018505 ORDER BY `minOrder` ASC [ RunTime:0.011300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018505 ORDER BY `unit` DESC [ RunTime:0.001962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018505 LIMIT 2 [ RunTime:0.005285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018505 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
select * from pdf where partno='HC-1.25-2PWT' and brandshort='HCTL' limit 1 [ RunTime:0.008114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-2PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.018346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018531 LIMIT 5 [ RunTime:0.020861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018531 ORDER BY `minOrder` ASC [ RunTime:0.018993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018531 ORDER BY `unit` DESC [ RunTime:0.011131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018531 LIMIT 2 [ RunTime:0.007120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018531 ORDER BY `minOrder` ASC [ RunTime:0.001801s ]
select * from pdf where partno='HC-1.25-2PLT' and brandshort='HCTL' limit 1 [ RunTime:0.003924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-2PLT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.004295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018535 LIMIT 5 [ RunTime:0.004600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018535 ORDER BY `minOrder` ASC [ RunTime:0.003679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018535 ORDER BY `unit` DESC [ RunTime:0.000245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018535 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018535 ORDER BY `minOrder` ASC [ RunTime:0.011741s ]
select * from pdf where partno='HC-1.25-4PLT' and brandshort='HCTL' limit 1 [ RunTime:0.002557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-4PLT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018642 LIMIT 5 [ RunTime:0.001083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018642 ORDER BY `minOrder` ASC [ RunTime:0.007464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018642 ORDER BY `unit` DESC [ RunTime:0.008442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018642 LIMIT 2 [ RunTime:0.006727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018642 ORDER BY `minOrder` ASC [ RunTime:0.004428s ]
select * from pdf where partno='HC-1.25-3PWT' and brandshort='HCTL' limit 1 [ RunTime:0.007250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-3PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.012758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019068 LIMIT 5 [ RunTime:0.001954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019068 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019068 ORDER BY `unit` DESC [ RunTime:0.005858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019068 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019068 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
select * from pdf where partno='HC-1.25-T' and brandshort='HCTL' limit 1 [ RunTime:0.004048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-T' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.021903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018963 LIMIT 5 [ RunTime:0.004104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018963 ORDER BY `minOrder` ASC [ RunTime:0.004977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018963 ORDER BY `unit` DESC [ RunTime:0.003297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018963 LIMIT 2 [ RunTime:0.003165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018963 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='HC-1.0-3PWT' and brandshort='HCTL' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.0-3PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.004085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018676 LIMIT 5 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018676 ORDER BY `minOrder` ASC [ RunTime:0.007346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018676 ORDER BY `unit` DESC [ RunTime:0.013746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018676 LIMIT 2 [ RunTime:0.008106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018676 ORDER BY `minOrder` ASC [ RunTime:0.000901s ]
select * from pdf where partno='HC-1.25-4PWT' and brandshort='HCTL' limit 1 [ RunTime:0.002325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-4PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.011691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019233 LIMIT 5 [ RunTime:0.002457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019233 ORDER BY `minOrder` ASC [ RunTime:0.015064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019233 ORDER BY `unit` DESC [ RunTime:0.009273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019233 LIMIT 2 [ RunTime:0.001863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019233 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='HC-1.0-8PWT' and brandshort='HCTL' limit 1 [ RunTime:0.008623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.0-8PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.010385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018971 LIMIT 5 [ RunTime:0.014334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018971 ORDER BY `minOrder` ASC [ RunTime:0.016535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018971 ORDER BY `unit` DESC [ RunTime:0.011955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018971 LIMIT 2 [ RunTime:0.021546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018971 ORDER BY `minOrder` ASC [ RunTime:0.005022s ]
select * from pdf where partno='HC-1.0-4PWT' and brandshort='HCTL' limit 1 [ RunTime:0.003189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.0-4PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.013570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018713 LIMIT 5 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018713 ORDER BY `minOrder` ASC [ RunTime:0.001029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018713 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018713 LIMIT 2 [ RunTime:0.003499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018713 ORDER BY `minOrder` ASC [ RunTime:0.003416s ]
select * from pdf where partno='HC-1.25-4A' and brandshort='HCTL' limit 1 [ RunTime:0.001101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-4A' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.003723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018730 LIMIT 5 [ RunTime:0.001684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018730 ORDER BY `minOrder` ASC [ RunTime:0.003648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018730 ORDER BY `unit` DESC [ RunTime:0.011041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018730 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018730 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='HC-1.25-3PLT' and brandshort='HCTL' limit 1 [ RunTime:0.004571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-3PLT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.015591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018643 LIMIT 5 [ RunTime:0.014326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018643 ORDER BY `minOrder` ASC [ RunTime:0.012983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018643 ORDER BY `unit` DESC [ RunTime:0.013584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018643 LIMIT 2 [ RunTime:0.024593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018643 ORDER BY `minOrder` ASC [ RunTime:0.003683s ]
select * from pdf where partno='HC-1.0-6PWT' and brandshort='HCTL' limit 1 [ RunTime:0.005330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.0-6PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.007617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018909 LIMIT 5 [ RunTime:0.008270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018909 ORDER BY `minOrder` ASC [ RunTime:0.001115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018909 ORDER BY `unit` DESC [ RunTime:0.007724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018909 LIMIT 2 [ RunTime:0.013322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018909 ORDER BY `minOrder` ASC [ RunTime:0.007409s ]
select * from pdf where partno='HC-1.25-3A' and brandshort='HCTL' limit 1 [ RunTime:0.006079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-3A' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.012698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018815 LIMIT 5 [ RunTime:0.007703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018815 ORDER BY `minOrder` ASC [ RunTime:0.010123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018815 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018815 LIMIT 2 [ RunTime:0.003237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018815 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='HC-1.25-5PWT' and brandshort='HCTL' limit 1 [ RunTime:0.001186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-5PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.007291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018825 LIMIT 5 [ RunTime:0.003594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018825 ORDER BY `minOrder` ASC [ RunTime:0.002313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018825 ORDER BY `unit` DESC [ RunTime:0.001468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018825 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018825 ORDER BY `minOrder` ASC [ RunTime:0.001500s ]
select * from pdf where partno='HC-1.25-6PWT' and brandshort='HCTL' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-6PWT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.005968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018897 LIMIT 5 [ RunTime:0.005538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018897 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018897 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018897 LIMIT 2 [ RunTime:0.003212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018897 ORDER BY `minOrder` ASC [ RunTime:0.003666s ]
select * from pdf where partno='HC-1.25-2A' and brandshort='HCTL' limit 1 [ RunTime:0.001003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-2A' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.008529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018957 LIMIT 5 [ RunTime:0.004127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018957 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018957 ORDER BY `unit` DESC [ RunTime:0.006305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018957 LIMIT 2 [ RunTime:0.005611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018957 ORDER BY `minOrder` ASC [ RunTime:0.002014s ]
select * from pdf where partno='HC-1.25-7A' and brandshort='HCTL' limit 1 [ RunTime:0.001041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-7A' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.014137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018844 LIMIT 5 [ RunTime:0.015929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018844 ORDER BY `minOrder` ASC [ RunTime:0.004602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018844 ORDER BY `unit` DESC [ RunTime:0.001268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018844 LIMIT 2 [ RunTime:0.019080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018844 ORDER BY `minOrder` ASC [ RunTime:0.004850s ]
select * from pdf where partno='HC-1.25-8PLT' and brandshort='HCTL' limit 1 [ RunTime:0.036497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-8PLT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.057485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018838 LIMIT 5 [ RunTime:0.005966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018838 ORDER BY `minOrder` ASC [ RunTime:0.013867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018838 ORDER BY `unit` DESC [ RunTime:0.014481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018838 LIMIT 2 [ RunTime:0.005889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018838 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='HC-1.25-6PLT' and brandshort='HCTL' limit 1 [ RunTime:0.000796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-6PLT' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.003875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018921 LIMIT 5 [ RunTime:0.001810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018921 ORDER BY `minOrder` ASC [ RunTime:0.001609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018921 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018921 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018921 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='HC-1.25-4AW' and brandshort='HCTL' limit 1 [ RunTime:0.000844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC-1.25-4AW' OR `brand` LIKE 'HCTL(华灿天禄)%' ) ) LIMIT 1 [ RunTime:0.003261s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'HC-1%' OR `brand` LIKE 'HC-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001618s ]