SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001354s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=4067&search=1' [ RunTime:0.004225s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001516s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000575s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002820s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.002385s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002679s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005258s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002512s ]
SELECT * FROM `stock_search` WHERE `partno` = '4067' LIMIT 1 [ RunTime:0.014456s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-21 21:32:29' WHERE `partno` = '4067' [ RunTime:0.005128s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003558s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017828s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074088 LIMIT 5 [ RunTime:0.024593s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074088 ORDER BY `minOrder` ASC [ RunTime:0.003656s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074088 ORDER BY `unit` DESC [ RunTime:0.001553s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074088 LIMIT 2 [ RunTime:0.023114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074088 ORDER BY `minOrder` ASC [ RunTime:0.018382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520530 LIMIT 5 [ RunTime:0.019787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520530 ORDER BY `minOrder` ASC [ RunTime:0.023045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520530 ORDER BY `unit` DESC [ RunTime:0.015747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520530 LIMIT 2 [ RunTime:0.066161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520530 ORDER BY `minOrder` ASC [ RunTime:0.049585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316361 LIMIT 5 [ RunTime:0.085716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316361 ORDER BY `minOrder` ASC [ RunTime:0.030602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316361 ORDER BY `unit` DESC [ RunTime:0.099815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316361 LIMIT 2 [ RunTime:0.025635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316361 ORDER BY `minOrder` ASC [ RunTime:0.032004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234655 LIMIT 5 [ RunTime:0.042835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234655 ORDER BY `minOrder` ASC [ RunTime:0.044779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11234655 ORDER BY `unit` DESC [ RunTime:0.114353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11234655 LIMIT 2 [ RunTime:0.022981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234655 ORDER BY `minOrder` ASC [ RunTime:0.009590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10416 LIMIT 5 [ RunTime:0.051139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10416 ORDER BY `minOrder` ASC [ RunTime:0.031366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10416 ORDER BY `unit` DESC [ RunTime:0.102654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10416 LIMIT 2 [ RunTime:0.080809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10416 ORDER BY `minOrder` ASC [ RunTime:0.056885s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40674' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.019989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527092 LIMIT 5 [ RunTime:0.012254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527092 ORDER BY `minOrder` ASC [ RunTime:0.046284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527092 ORDER BY `unit` DESC [ RunTime:0.031968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527092 LIMIT 2 [ RunTime:0.029187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527092 ORDER BY `minOrder` ASC [ RunTime:0.003763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425550 LIMIT 5 [ RunTime:0.019500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425550 ORDER BY `minOrder` ASC [ RunTime:0.025722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425550 ORDER BY `unit` DESC [ RunTime:0.021291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425550 LIMIT 2 [ RunTime:0.011357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425550 ORDER BY `minOrder` ASC [ RunTime:0.015817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425542 LIMIT 5 [ RunTime:0.016539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425542 ORDER BY `minOrder` ASC [ RunTime:0.018382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425542 ORDER BY `unit` DESC [ RunTime:0.018301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425542 LIMIT 2 [ RunTime:0.012313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425542 ORDER BY `minOrder` ASC [ RunTime:0.030399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425536 LIMIT 5 [ RunTime:0.018430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425536 ORDER BY `minOrder` ASC [ RunTime:0.009707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425536 ORDER BY `unit` DESC [ RunTime:0.020973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425536 LIMIT 2 [ RunTime:0.026595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425536 ORDER BY `minOrder` ASC [ RunTime:0.009231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424318 LIMIT 5 [ RunTime:0.017541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424318 ORDER BY `minOrder` ASC [ RunTime:0.009306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424318 ORDER BY `unit` DESC [ RunTime:0.002537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424318 LIMIT 2 [ RunTime:0.015377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424318 ORDER BY `minOrder` ASC [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345279 LIMIT 5 [ RunTime:0.005303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345279 ORDER BY `minOrder` ASC [ RunTime:0.005077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345279 ORDER BY `unit` DESC [ RunTime:0.000722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345279 LIMIT 2 [ RunTime:0.003966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345279 ORDER BY `minOrder` ASC [ RunTime:0.002775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344864 LIMIT 5 [ RunTime:0.011012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344864 ORDER BY `minOrder` ASC [ RunTime:0.006417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14344864 ORDER BY `unit` DESC [ RunTime:0.006729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14344864 LIMIT 2 [ RunTime:0.008182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344864 ORDER BY `minOrder` ASC [ RunTime:0.010856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344783 LIMIT 5 [ RunTime:0.004804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344783 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14344783 ORDER BY `unit` DESC [ RunTime:0.000761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14344783 LIMIT 2 [ RunTime:0.005613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344783 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556623 LIMIT 5 [ RunTime:0.014354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556623 ORDER BY `minOrder` ASC [ RunTime:0.003332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556623 ORDER BY `unit` DESC [ RunTime:0.000948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556623 LIMIT 2 [ RunTime:0.000828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556623 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556586 LIMIT 5 [ RunTime:0.001081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556586 ORDER BY `minOrder` ASC [ RunTime:0.003956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556586 ORDER BY `unit` DESC [ RunTime:0.001128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556586 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556586 ORDER BY `minOrder` ASC [ RunTime:0.003745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555235 LIMIT 5 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555235 ORDER BY `minOrder` ASC [ RunTime:0.006273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555235 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555235 LIMIT 2 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555235 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555234 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555234 ORDER BY `minOrder` ASC [ RunTime:0.022583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555234 ORDER BY `unit` DESC [ RunTime:0.001483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555234 LIMIT 2 [ RunTime:0.003990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555234 ORDER BY `minOrder` ASC [ RunTime:0.008668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555219 LIMIT 5 [ RunTime:0.001229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555219 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555219 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555219 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555219 ORDER BY `minOrder` ASC [ RunTime:0.008316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459744 LIMIT 5 [ RunTime:0.018354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459744 ORDER BY `minOrder` ASC [ RunTime:0.017552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459744 ORDER BY `unit` DESC [ RunTime:0.002905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459744 LIMIT 2 [ RunTime:0.011581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459744 ORDER BY `minOrder` ASC [ RunTime:0.005201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459581 LIMIT 5 [ RunTime:0.010220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459581 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459581 ORDER BY `unit` DESC [ RunTime:0.008347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459581 LIMIT 2 [ RunTime:0.005113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459581 ORDER BY `minOrder` ASC [ RunTime:0.006977s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096955 LIMIT 5 [ RunTime:0.014129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096955 ORDER BY `minOrder` ASC [ RunTime:0.020736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096955 ORDER BY `unit` DESC [ RunTime:0.005501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096955 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096955 ORDER BY `minOrder` ASC [ RunTime:0.007174s ]
select * from pdf where partno='4067' and brandshort='adafruit' limit 1 [ RunTime:0.010576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.008769s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53596544 LIMIT 5 [ RunTime:0.010267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53596544 ORDER BY `minOrder` ASC [ RunTime:0.009803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53596544 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53596544 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53596544 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='406732-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '406732-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002422s ]
SELECT `id` FROM `stock` WHERE `id` <> 53596544 AND `partno` = '406732-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074088 [ RunTime:0.008849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49480862 LIMIT 5 [ RunTime:0.008359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49480862 ORDER BY `minOrder` ASC [ RunTime:0.016552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49480862 ORDER BY `unit` DESC [ RunTime:0.010208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49480862 LIMIT 2 [ RunTime:0.003590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49480862 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='4067' and brandshort='Pololu' limit 1 [ RunTime:0.001816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.024224s ]
SELECT `id` FROM `stock` WHERE `id` <> 49480862 AND `partno` = '4067' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.001461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520530 [ RunTime:0.004501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36674802 LIMIT 5 [ RunTime:0.008087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36674802 ORDER BY `minOrder` ASC [ RunTime:0.019820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36674802 ORDER BY `unit` DESC [ RunTime:0.007483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36674802 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36674802 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
select * from pdf where partno='4067' and brandshort='Pololu' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.005249s ]
SELECT `id` FROM `stock` WHERE `id` <> 36674802 AND `partno` = '4067' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.010910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520530 [ RunTime:0.002532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49577233 LIMIT 5 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49577233 ORDER BY `minOrder` ASC [ RunTime:0.004842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49577233 ORDER BY `unit` DESC [ RunTime:0.003763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49577233 LIMIT 2 [ RunTime:0.012259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49577233 ORDER BY `minOrder` ASC [ RunTime:0.002901s ]
select * from pdf where partno='4067-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.009885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.004116s ]
SELECT `id` FROM `stock` WHERE `id` <> 49577233 AND `partno` = '4067-440-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.006221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316361 [ RunTime:0.013148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36770463 LIMIT 5 [ RunTime:0.010634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36770463 ORDER BY `minOrder` ASC [ RunTime:0.006178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36770463 ORDER BY `unit` DESC [ RunTime:0.002270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36770463 LIMIT 2 [ RunTime:0.001980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36770463 ORDER BY `minOrder` ASC [ RunTime:0.003585s ]
select * from pdf where partno='4067-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000444s ]
SELECT `id` FROM `stock` WHERE `id` <> 36770463 AND `partno` = '4067-440-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316361 [ RunTime:0.002502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49395011 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49395011 ORDER BY `minOrder` ASC [ RunTime:0.005639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49395011 ORDER BY `unit` DESC [ RunTime:0.000863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49395011 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49395011 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='4067881' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067881' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004333s ]
SELECT `id` FROM `stock` WHERE `id` <> 49395011 AND `partno` = '4067881' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234655 [ RunTime:0.003886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36588977 LIMIT 5 [ RunTime:0.001519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36588977 ORDER BY `minOrder` ASC [ RunTime:0.003512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36588977 ORDER BY `unit` DESC [ RunTime:0.002121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36588977 LIMIT 2 [ RunTime:0.001320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36588977 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='4067881' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067881' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000516s ]
SELECT `id` FROM `stock` WHERE `id` <> 36588977 AND `partno` = '4067881' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234655 [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49161236 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49161236 ORDER BY `minOrder` ASC [ RunTime:0.001397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49161236 ORDER BY `unit` DESC [ RunTime:0.002890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49161236 LIMIT 2 [ RunTime:0.004317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49161236 ORDER BY `minOrder` ASC [ RunTime:0.004037s ]
select * from pdf where partno='4067' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.010133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000283s ]
SELECT `id` FROM `stock` WHERE `id` <> 49161236 AND `partno` = '4067' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.002507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527092 [ RunTime:0.002560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36364972 LIMIT 5 [ RunTime:0.001297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36364972 ORDER BY `minOrder` ASC [ RunTime:0.004184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36364972 ORDER BY `unit` DESC [ RunTime:0.004447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36364972 LIMIT 2 [ RunTime:0.030250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36364972 ORDER BY `minOrder` ASC [ RunTime:0.003249s ]
select * from pdf where partno='4067' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.002087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000371s ]
SELECT `id` FROM `stock` WHERE `id` <> 36364972 AND `partno` = '4067' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.009865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527092 [ RunTime:0.015427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51723528 LIMIT 5 [ RunTime:0.010825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51723528 ORDER BY `minOrder` ASC [ RunTime:0.013803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51723528 ORDER BY `unit` DESC [ RunTime:0.032579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51723528 LIMIT 2 [ RunTime:0.019964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51723528 ORDER BY `minOrder` ASC [ RunTime:0.004150s ]
select * from pdf where partno='40678-10000' and brandshort='3M' limit 1 [ RunTime:0.010229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40678-10000' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.022578s ]
SELECT `id` FROM `stock` WHERE `id` <> 51723528 AND `partno` = '40678-10000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.049720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11179335 [ RunTime:0.034155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51000169 LIMIT 5 [ RunTime:0.015044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51000169 ORDER BY `minOrder` ASC [ RunTime:0.007357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51000169 ORDER BY `unit` DESC [ RunTime:0.015719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51000169 LIMIT 2 [ RunTime:0.013788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51000169 ORDER BY `minOrder` ASC [ RunTime:0.013400s ]
select * from pdf where partno='4067-01BK-BU' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.008721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067-01BK-BU' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.029781s ]
SELECT `id` FROM `stock` WHERE `id` <> 51000169 AND `partno` = '4067-01BK-BU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.030092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38540940 [ RunTime:0.047591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51000162 LIMIT 5 [ RunTime:0.028900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51000162 ORDER BY `minOrder` ASC [ RunTime:0.005106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51000162 ORDER BY `unit` DESC [ RunTime:0.028133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51000162 LIMIT 2 [ RunTime:0.025140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51000162 ORDER BY `minOrder` ASC [ RunTime:0.031337s ]
select * from pdf where partno='4067BK-BU' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.034969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4067BK-BU' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.024541s ]
SELECT `id` FROM `stock` WHERE `id` <> 51000162 AND `partno` = '4067BK-BU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.023925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38540934 [ RunTime:0.026539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50712808 LIMIT 5 [ RunTime:0.006215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712808 ORDER BY `minOrder` ASC [ RunTime:0.022315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50712808 ORDER BY `unit` DESC [ RunTime:0.020265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50712808 LIMIT 2 [ RunTime:0.061975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712808 ORDER BY `minOrder` ASC [ RunTime:0.022781s ]
select * from pdf where partno='40676' and brandshort='Brady Corporation' limit 1 [ RunTime:0.027689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40676' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.030897s ]
SELECT `id` FROM `stock` WHERE `id` <> 50712808 AND `partno` = '40676' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556623 [ RunTime:0.010473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50712768 LIMIT 5 [ RunTime:0.020503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712768 ORDER BY `minOrder` ASC [ RunTime:0.001590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50712768 ORDER BY `unit` DESC [ RunTime:0.016911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50712768 LIMIT 2 [ RunTime:0.008897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712768 ORDER BY `minOrder` ASC [ RunTime:0.001682s ]
select * from pdf where partno='40678' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40678' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004507s ]
SELECT `id` FROM `stock` WHERE `id` <> 50712768 AND `partno` = '40678' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425550 [ RunTime:0.018970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50712751 LIMIT 5 [ RunTime:0.019326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712751 ORDER BY `minOrder` ASC [ RunTime:0.019982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50712751 ORDER BY `unit` DESC [ RunTime:0.001848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50712751 LIMIT 2 [ RunTime:0.017418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712751 ORDER BY `minOrder` ASC [ RunTime:0.010305s ]
select * from pdf where partno='40674' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40674' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50712743 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712743 ORDER BY `minOrder` ASC [ RunTime:0.010880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50712743 ORDER BY `unit` DESC [ RunTime:0.007868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50712743 LIMIT 2 [ RunTime:0.002487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712743 ORDER BY `minOrder` ASC [ RunTime:0.002211s ]
select * from pdf where partno='40672' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40672' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50712740 LIMIT 5 [ RunTime:0.010161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712740 ORDER BY `minOrder` ASC [ RunTime:0.014301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50712740 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50712740 LIMIT 2 [ RunTime:0.005975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712740 ORDER BY `minOrder` ASC [ RunTime:0.002842s ]
select * from pdf where partno='40670' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40670' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.012057s ]
SELECT `id` FROM `stock` WHERE `id` <> 50712740 AND `partno` = '40670' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425536 [ RunTime:0.001750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710416 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710416 ORDER BY `minOrder` ASC [ RunTime:0.003838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710416 ORDER BY `unit` DESC [ RunTime:0.002830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710416 LIMIT 2 [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710416 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
select * from pdf where partno='40677' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40677' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000782s ]
SELECT `id` FROM `stock` WHERE `id` <> 50710416 AND `partno` = '40677' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555235 [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710415 LIMIT 5 [ RunTime:0.003316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710415 ORDER BY `minOrder` ASC [ RunTime:0.002088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710415 ORDER BY `unit` DESC [ RunTime:0.001613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710415 LIMIT 2 [ RunTime:0.001590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710415 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='40671' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40671' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004283s ]
SELECT `id` FROM `stock` WHERE `id` <> 50710415 AND `partno` = '40671' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555234 [ RunTime:0.003968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710404 LIMIT 5 [ RunTime:0.001540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710404 ORDER BY `minOrder` ASC [ RunTime:0.006613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710404 ORDER BY `unit` DESC [ RunTime:0.002055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710404 LIMIT 2 [ RunTime:0.006045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710404 ORDER BY `minOrder` ASC [ RunTime:0.004629s ]
select * from pdf where partno='40675' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40675' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002115s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002444s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001610s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004127s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000927s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012794s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006422s ]
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 '4067%' OR `brand` LIKE '4067%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010366s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4067%' OR `brand` LIKE '4067%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002656s ]