SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001456s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.103' , `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=1080&search=1' [ RunTime:0.010563s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001641s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002977s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002477s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.103' ) [ RunTime:0.002469s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002978s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001585s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001612s ]
SELECT * FROM `stock_search` WHERE `partno` = '1080' LIMIT 1 [ RunTime:0.011275s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 13:09:57' WHERE `partno` = '1080' [ RunTime:0.003871s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001441s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063462s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325049 LIMIT 5 [ RunTime:0.023493s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325049 ORDER BY `minOrder` ASC [ RunTime:0.011513s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325049 ORDER BY `unit` DESC [ RunTime:0.005930s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325049 LIMIT 2 [ RunTime:0.004431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325049 ORDER BY `minOrder` ASC [ RunTime:0.004252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068628 LIMIT 5 [ RunTime:0.007853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068628 ORDER BY `minOrder` ASC [ RunTime:0.002432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068628 ORDER BY `unit` DESC [ RunTime:0.005521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068628 LIMIT 2 [ RunTime:0.012799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068628 ORDER BY `minOrder` ASC [ RunTime:0.002860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066464 LIMIT 5 [ RunTime:0.012153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066464 ORDER BY `minOrder` ASC [ RunTime:0.012148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066464 ORDER BY `unit` DESC [ RunTime:0.002975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066464 LIMIT 2 [ RunTime:0.002409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066464 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274890 LIMIT 5 [ RunTime:0.003686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274890 ORDER BY `minOrder` ASC [ RunTime:0.011855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274890 ORDER BY `unit` DESC [ RunTime:0.002828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274890 LIMIT 2 [ RunTime:0.001085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274890 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349758 LIMIT 5 [ RunTime:0.002270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349758 ORDER BY `minOrder` ASC [ RunTime:0.011565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349758 ORDER BY `unit` DESC [ RunTime:0.031773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349758 LIMIT 2 [ RunTime:0.007142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349758 ORDER BY `minOrder` ASC [ RunTime:0.013199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068702 LIMIT 5 [ RunTime:0.013723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068702 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068702 ORDER BY `unit` DESC [ RunTime:0.011382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068702 LIMIT 2 [ RunTime:0.002489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068702 ORDER BY `minOrder` ASC [ RunTime:0.007219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350559 LIMIT 5 [ RunTime:0.003771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350559 ORDER BY `minOrder` ASC [ RunTime:0.002240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350559 ORDER BY `unit` DESC [ RunTime:0.005632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350559 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350559 ORDER BY `minOrder` ASC [ RunTime:0.010797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065908 LIMIT 5 [ RunTime:0.009432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065908 ORDER BY `minOrder` ASC [ RunTime:0.014002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065908 ORDER BY `unit` DESC [ RunTime:0.001259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065908 LIMIT 2 [ RunTime:0.004278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065908 ORDER BY `minOrder` ASC [ RunTime:0.005518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15450359 LIMIT 5 [ RunTime:0.008897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15450359 ORDER BY `minOrder` ASC [ RunTime:0.004347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15450359 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15450359 LIMIT 2 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15450359 ORDER BY `minOrder` ASC [ RunTime:0.002722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349900 LIMIT 5 [ RunTime:0.000942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349900 ORDER BY `minOrder` ASC [ RunTime:0.002544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349900 ORDER BY `unit` DESC [ RunTime:0.011327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349900 LIMIT 2 [ RunTime:0.005485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349900 ORDER BY `minOrder` ASC [ RunTime:0.002862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605464 LIMIT 5 [ RunTime:0.001705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605464 ORDER BY `minOrder` ASC [ RunTime:0.002101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605464 ORDER BY `unit` DESC [ RunTime:0.007855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605464 LIMIT 2 [ RunTime:0.010447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605464 ORDER BY `minOrder` ASC [ RunTime:0.003031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606414 LIMIT 5 [ RunTime:0.017579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606414 ORDER BY `minOrder` ASC [ RunTime:0.004463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606414 ORDER BY `unit` DESC [ RunTime:0.008046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606414 LIMIT 2 [ RunTime:0.016152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606414 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605633 LIMIT 5 [ RunTime:0.009562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605633 ORDER BY `minOrder` ASC [ RunTime:0.009080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605633 ORDER BY `unit` DESC [ RunTime:0.001376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605633 LIMIT 2 [ RunTime:0.005284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605633 ORDER BY `minOrder` ASC [ RunTime:0.007200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17302247 LIMIT 5 [ RunTime:0.028608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17302247 ORDER BY `minOrder` ASC [ RunTime:0.030128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17302247 ORDER BY `unit` DESC [ RunTime:0.020017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17302247 LIMIT 2 [ RunTime:0.005878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17302247 ORDER BY `minOrder` ASC [ RunTime:0.021172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605624 LIMIT 5 [ RunTime:0.027310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605624 ORDER BY `minOrder` ASC [ RunTime:0.076954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605624 ORDER BY `unit` DESC [ RunTime:0.076528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605624 LIMIT 2 [ RunTime:0.028270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605624 ORDER BY `minOrder` ASC [ RunTime:0.027914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14690816 LIMIT 5 [ RunTime:0.024715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690816 ORDER BY `minOrder` ASC [ RunTime:0.032049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14690816 ORDER BY `unit` DESC [ RunTime:0.014470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14690816 LIMIT 2 [ RunTime:0.006925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690816 ORDER BY `minOrder` ASC [ RunTime:0.004722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673819 LIMIT 5 [ RunTime:0.011962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673819 ORDER BY `minOrder` ASC [ RunTime:0.044102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673819 ORDER BY `unit` DESC [ RunTime:0.041649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673819 LIMIT 2 [ RunTime:0.015546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673819 ORDER BY `minOrder` ASC [ RunTime:0.013321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14668600 LIMIT 5 [ RunTime:0.028911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14668600 ORDER BY `minOrder` ASC [ RunTime:0.011480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14668600 ORDER BY `unit` DESC [ RunTime:0.019500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14668600 LIMIT 2 [ RunTime:0.033755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14668600 ORDER BY `minOrder` ASC [ RunTime:0.007769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673821 LIMIT 5 [ RunTime:0.017511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673821 ORDER BY `minOrder` ASC [ RunTime:0.012192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673821 ORDER BY `unit` DESC [ RunTime:0.001532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673821 LIMIT 2 [ RunTime:0.011482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673821 ORDER BY `minOrder` ASC [ RunTime:0.015246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13800288 LIMIT 5 [ RunTime:0.020329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800288 ORDER BY `minOrder` ASC [ RunTime:0.005477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13800288 ORDER BY `unit` DESC [ RunTime:0.014197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13800288 LIMIT 2 [ RunTime:0.007704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800288 ORDER BY `minOrder` ASC [ RunTime:0.012217s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134546 LIMIT 5 [ RunTime:0.014725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134546 ORDER BY `minOrder` ASC [ RunTime:0.046438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134546 ORDER BY `unit` DESC [ RunTime:0.043696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134546 LIMIT 2 [ RunTime:0.025386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134546 ORDER BY `minOrder` ASC [ RunTime:0.015348s ]
select * from pdf where partno='1080725' and brandshort='phoenix contact' limit 1 [ RunTime:0.030216s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080725' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.034640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235690 LIMIT 5 [ RunTime:0.046199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235690 ORDER BY `minOrder` ASC [ RunTime:0.023678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235690 ORDER BY `unit` DESC [ RunTime:0.005866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235690 LIMIT 2 [ RunTime:0.027941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235690 ORDER BY `minOrder` ASC [ RunTime:0.018890s ]
select * from pdf where partno='108009' and brandshort='basler' limit 1 [ RunTime:0.013293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108009' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.019803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235774 LIMIT 5 [ RunTime:0.060908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235774 ORDER BY `minOrder` ASC [ RunTime:0.021160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235774 ORDER BY `unit` DESC [ RunTime:0.003867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235774 LIMIT 2 [ RunTime:0.016306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235774 ORDER BY `minOrder` ASC [ RunTime:0.025140s ]
select * from pdf where partno='108012' and brandshort='basler' limit 1 [ RunTime:0.024322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108012' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.008866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32247364 LIMIT 5 [ RunTime:0.046663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247364 ORDER BY `minOrder` ASC [ RunTime:0.034246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32247364 ORDER BY `unit` DESC [ RunTime:0.056181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32247364 LIMIT 2 [ RunTime:0.064688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247364 ORDER BY `minOrder` ASC [ RunTime:0.042485s ]
select * from pdf where partno='108031' and brandshort='basler' limit 1 [ RunTime:0.035467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108031' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.058069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080367 LIMIT 5 [ RunTime:0.079678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080367 ORDER BY `minOrder` ASC [ RunTime:0.050990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080367 ORDER BY `unit` DESC [ RunTime:0.037474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080367 LIMIT 2 [ RunTime:0.058091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080367 ORDER BY `minOrder` ASC [ RunTime:0.049055s ]
select * from pdf where partno='108030' and brandshort='basler' limit 1 [ RunTime:0.027265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108030' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.002473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235679 LIMIT 5 [ RunTime:0.027847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235679 ORDER BY `minOrder` ASC [ RunTime:0.030486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235679 ORDER BY `unit` DESC [ RunTime:0.049457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235679 LIMIT 2 [ RunTime:0.006454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235679 ORDER BY `minOrder` ASC [ RunTime:0.006845s ]
select * from pdf where partno='108010' and brandshort='basler' limit 1 [ RunTime:0.003624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108010' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086559 LIMIT 5 [ RunTime:0.017109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086559 ORDER BY `minOrder` ASC [ RunTime:0.007560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086559 ORDER BY `unit` DESC [ RunTime:0.026991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086559 LIMIT 2 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086559 ORDER BY `minOrder` ASC [ RunTime:0.003554s ]
select * from pdf where partno='1080245' and brandshort='phoenix contact' limit 1 [ RunTime:0.008527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080245' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.018681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080410 LIMIT 5 [ RunTime:0.013217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080410 ORDER BY `minOrder` ASC [ RunTime:0.010614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080410 ORDER BY `unit` DESC [ RunTime:0.017568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080410 LIMIT 2 [ RunTime:0.008715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080410 ORDER BY `minOrder` ASC [ RunTime:0.001491s ]
select * from pdf where partno='108029' and brandshort='basler' limit 1 [ RunTime:0.003434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108029' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.003245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32247271 LIMIT 5 [ RunTime:0.007954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247271 ORDER BY `minOrder` ASC [ RunTime:0.020416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32247271 ORDER BY `unit` DESC [ RunTime:0.020492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32247271 LIMIT 2 [ RunTime:0.004274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247271 ORDER BY `minOrder` ASC [ RunTime:0.003113s ]
select * from pdf where partno='108017' and brandshort='basler' limit 1 [ RunTime:0.004544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108017' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.012265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32172578 LIMIT 5 [ RunTime:0.017198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32172578 ORDER BY `minOrder` ASC [ RunTime:0.004754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32172578 ORDER BY `unit` DESC [ RunTime:0.003511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32172578 LIMIT 2 [ RunTime:0.008827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32172578 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='108017' and brandshort='basler' limit 1 [ RunTime:0.000495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108017' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081202 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081202 ORDER BY `minOrder` ASC [ RunTime:0.002361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081202 ORDER BY `unit` DESC [ RunTime:0.000671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081202 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081202 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='108015' and brandshort='basler' limit 1 [ RunTime:0.000895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108015' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.001529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235989 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235989 ORDER BY `minOrder` ASC [ RunTime:0.003602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235989 ORDER BY `unit` DESC [ RunTime:0.007236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235989 LIMIT 2 [ RunTime:0.011832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235989 ORDER BY `minOrder` ASC [ RunTime:0.001621s ]
select * from pdf where partno='108013' and brandshort='basler' limit 1 [ RunTime:0.002122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108013' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32247328 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247328 ORDER BY `minOrder` ASC [ RunTime:0.003163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32247328 ORDER BY `unit` DESC [ RunTime:0.002918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32247328 LIMIT 2 [ RunTime:0.001976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247328 ORDER BY `minOrder` ASC [ RunTime:0.005628s ]
select * from pdf where partno='108016' and brandshort='basler' limit 1 [ RunTime:0.001026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108016' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.017362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32247327 LIMIT 5 [ RunTime:0.012973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247327 ORDER BY `minOrder` ASC [ RunTime:0.011035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32247327 ORDER BY `unit` DESC [ RunTime:0.000845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32247327 LIMIT 2 [ RunTime:0.001910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247327 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='108014' and brandshort='basler' limit 1 [ RunTime:0.003501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108014' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.001070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173611 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173611 ORDER BY `minOrder` ASC [ RunTime:0.001034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32173611 ORDER BY `unit` DESC [ RunTime:0.016233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32173611 LIMIT 2 [ RunTime:0.008019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173611 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='108016' and brandshort='basler' limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108016' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173610 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173610 ORDER BY `minOrder` ASC [ RunTime:0.002097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32173610 ORDER BY `unit` DESC [ RunTime:0.006498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32173610 LIMIT 2 [ RunTime:0.009129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173610 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='108014' and brandshort='basler' limit 1 [ RunTime:0.000571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108014' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080898 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080898 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080898 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080898 LIMIT 2 [ RunTime:0.003060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080898 ORDER BY `minOrder` ASC [ RunTime:0.004673s ]
select * from pdf where partno='108028' and brandshort='basler' limit 1 [ RunTime:0.005548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108028' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.001042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32187446 LIMIT 5 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187446 ORDER BY `minOrder` ASC [ RunTime:0.001136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32187446 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32187446 LIMIT 2 [ RunTime:0.006639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187446 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='1080' and brandshort='adafruit' limit 1 [ RunTime:0.004775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.004853s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60323855 LIMIT 5 [ RunTime:0.007983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60323855 ORDER BY `minOrder` ASC [ RunTime:0.008454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60323855 ORDER BY `unit` DESC [ RunTime:0.010388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60323855 LIMIT 2 [ RunTime:0.017075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60323855 ORDER BY `minOrder` ASC [ RunTime:0.010723s ]
select * from pdf where partno='108012-ZZ' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108012-ZZ' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.005664s ]
SELECT `id` FROM `stock` WHERE `id` <> 60323855 AND `partno` = '108012-ZZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.003597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563661 LIMIT 5 [ RunTime:0.018799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563661 ORDER BY `minOrder` ASC [ RunTime:0.018490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563661 ORDER BY `unit` DESC [ RunTime:0.000667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563661 LIMIT 2 [ RunTime:0.014202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563661 ORDER BY `minOrder` ASC [ RunTime:0.003171s ]
select * from pdf where partno='10806CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10806CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002071s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563661 AND `partno` = '10806CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068702 [ RunTime:0.000698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63387178 LIMIT 5 [ RunTime:0.006526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387178 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63387178 ORDER BY `unit` DESC [ RunTime:0.008925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63387178 LIMIT 2 [ RunTime:0.018846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387178 ORDER BY `minOrder` ASC [ RunTime:0.011032s ]
select * from pdf where partno='1080A' and brandshort='Essentra Components' limit 1 [ RunTime:0.010601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080A' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.010300s ]
SELECT `id` FROM `stock` WHERE `id` <> 63387178 AND `partno` = '1080A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.002894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325049 [ RunTime:0.010137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560368 LIMIT 5 [ RunTime:0.005872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560368 ORDER BY `minOrder` ASC [ RunTime:0.003956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560368 ORDER BY `unit` DESC [ RunTime:0.002125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560368 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560368 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='10808CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10808CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008240s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560368 AND `partno` = '10808CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349758 [ RunTime:0.005118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560565 LIMIT 5 [ RunTime:0.003321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560565 ORDER BY `minOrder` ASC [ RunTime:0.004400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560565 ORDER BY `unit` DESC [ RunTime:0.002807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560565 LIMIT 2 [ RunTime:0.010363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560565 ORDER BY `minOrder` ASC [ RunTime:0.005005s ]
select * from pdf where partno='10803CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10803CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001307s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560565 AND `partno` = '10803CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.003055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349900 [ RunTime:0.016009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60323491 LIMIT 5 [ RunTime:0.016322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60323491 ORDER BY `minOrder` ASC [ RunTime:0.001942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60323491 ORDER BY `unit` DESC [ RunTime:0.014392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60323491 LIMIT 2 [ RunTime:0.018368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60323491 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='108039112' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108039112' OR `brand` LIKE 'Amphenol Sine Systems Corp%' ) ) LIMIT 1 [ RunTime:0.002690s ]
SELECT `id` FROM `stock` WHERE `id` <> 60323491 AND `partno` = '108039112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sine systems corp%' ) [ RunTime:0.005832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11689969 [ RunTime:0.003995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558201 LIMIT 5 [ RunTime:0.002855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558201 ORDER BY `minOrder` ASC [ RunTime:0.020981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558201 ORDER BY `unit` DESC [ RunTime:0.002376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558201 LIMIT 2 [ RunTime:0.011959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558201 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='10809CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10809CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010855s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558201 AND `partno` = '10809CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066464 [ RunTime:0.003673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563483 LIMIT 5 [ RunTime:0.002589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563483 ORDER BY `minOrder` ASC [ RunTime:0.012565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563483 ORDER BY `unit` DESC [ RunTime:0.003284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563483 LIMIT 2 [ RunTime:0.012685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563483 ORDER BY `minOrder` ASC [ RunTime:0.020118s ]
select * from pdf where partno='10800CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10800CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002299s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563483 AND `partno` = '10800CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068628 [ RunTime:0.019869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104885 LIMIT 5 [ RunTime:0.000919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104885 ORDER BY `minOrder` ASC [ RunTime:0.013148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104885 ORDER BY `unit` DESC [ RunTime:0.014696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104885 LIMIT 2 [ RunTime:0.012421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104885 ORDER BY `minOrder` ASC [ RunTime:0.007992s ]
select * from pdf where partno='1080' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001896s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104885 AND `partno` = '1080' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274890 [ RunTime:0.017209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64556942 LIMIT 5 [ RunTime:0.005924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556942 ORDER BY `minOrder` ASC [ RunTime:0.003237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64556942 ORDER BY `unit` DESC [ RunTime:0.017546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64556942 LIMIT 2 [ RunTime:0.023446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556942 ORDER BY `minOrder` ASC [ RunTime:0.021986s ]
select * from pdf where partno='10801CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10801CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013200s ]
SELECT `id` FROM `stock` WHERE `id` <> 64556942 AND `partno` = '10801CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065908 [ RunTime:0.003450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61011155 LIMIT 5 [ RunTime:0.007525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61011155 ORDER BY `minOrder` ASC [ RunTime:0.005588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61011155 ORDER BY `unit` DESC [ RunTime:0.013950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61011155 LIMIT 2 [ RunTime:0.017510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61011155 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='1080239' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080239' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565947 LIMIT 5 [ RunTime:0.001619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565947 ORDER BY `minOrder` ASC [ RunTime:0.031374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565947 ORDER BY `unit` DESC [ RunTime:0.009964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565947 LIMIT 2 [ RunTime:0.001547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565947 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
select * from pdf where partno='10807CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10807CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003819s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565947 AND `partno` = '10807CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350559 [ RunTime:0.008723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488829 LIMIT 5 [ RunTime:0.011076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488829 ORDER BY `minOrder` ASC [ RunTime:0.013653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488829 ORDER BY `unit` DESC [ RunTime:0.000826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488829 LIMIT 2 [ RunTime:0.007804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488829 ORDER BY `minOrder` ASC [ RunTime:0.011970s ]
select * from pdf where partno='1080550000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080550000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010687s ]
SELECT `id` FROM `stock` WHERE `id` <> 60488829 AND `partno` = '1080550000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.017992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605464 [ RunTime:0.021690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488885 LIMIT 5 [ RunTime:0.014910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488885 ORDER BY `minOrder` ASC [ RunTime:0.020965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488885 ORDER BY `unit` DESC [ RunTime:0.038942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488885 LIMIT 2 [ RunTime:0.032641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488885 ORDER BY `minOrder` ASC [ RunTime:0.014995s ]
select * from pdf where partno='1080490000' and brandshort='Weidmüller' limit 1 [ RunTime:0.018905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080490000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008464s ]
SELECT `id` FROM `stock` WHERE `id` <> 60488885 AND `partno` = '1080490000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605633 [ RunTime:0.007419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60471025 LIMIT 5 [ RunTime:0.008050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60471025 ORDER BY `minOrder` ASC [ RunTime:0.011032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60471025 ORDER BY `unit` DESC [ RunTime:0.006425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60471025 LIMIT 2 [ RunTime:0.022568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60471025 ORDER BY `minOrder` ASC [ RunTime:0.013151s ]
select * from pdf where partno='1080103' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080103' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61012608 LIMIT 5 [ RunTime:0.003107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61012608 ORDER BY `minOrder` ASC [ RunTime:0.026407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61012608 ORDER BY `unit` DESC [ RunTime:0.019167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61012608 LIMIT 2 [ RunTime:0.010375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61012608 ORDER BY `minOrder` ASC [ RunTime:0.008224s ]
select * from pdf where partno='1080233' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080233' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386538 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386538 ORDER BY `minOrder` ASC [ RunTime:0.001131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386538 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386538 LIMIT 2 [ RunTime:0.001505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386538 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='1080116' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080116' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62127898 LIMIT 5 [ RunTime:0.005782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62127898 ORDER BY `minOrder` ASC [ RunTime:0.004509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62127898 ORDER BY `unit` DESC [ RunTime:0.000715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62127898 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62127898 ORDER BY `minOrder` ASC [ RunTime:0.004099s ]
select * from pdf where partno='1080743' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080743' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386033 LIMIT 5 [ RunTime:0.007116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386033 ORDER BY `minOrder` ASC [ RunTime:0.004849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386033 ORDER BY `unit` DESC [ RunTime:0.000750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386033 LIMIT 2 [ RunTime:0.008226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386033 ORDER BY `minOrder` ASC [ RunTime:0.005259s ]
select * from pdf where partno='1080100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004507s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386033 AND `partno` = '1080100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488938 LIMIT 5 [ RunTime:0.003443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488938 ORDER BY `minOrder` ASC [ RunTime:0.011958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488938 ORDER BY `unit` DESC [ RunTime:0.002852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488938 LIMIT 2 [ RunTime:0.001407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488938 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='1080510000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1080510000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008454s ]
SELECT `id` FROM `stock` WHERE `id` <> 60488938 AND `partno` = '1080510000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605624 [ RunTime:0.004636s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003304s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005937s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014355s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012501s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017784s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003664s ]
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 '1080%' OR `brand` LIKE '1080%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005408s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1080%' OR `brand` LIKE '1080%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014770s ]