SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002733s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=4223&search=1' [ RunTime:0.001787s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001677s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002072s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001546s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005963s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001784s ]
SELECT * FROM `stock_search` WHERE `partno` = '4223' LIMIT 1 [ RunTime:0.000889s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 15:28:55' WHERE `partno` = '4223' [ RunTime:0.006630s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001566s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011932s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516541 LIMIT 5 [ RunTime:0.007580s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516541 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516541 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516541 LIMIT 2 [ RunTime:0.010533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516541 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417215 LIMIT 5 [ RunTime:0.008356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417215 ORDER BY `minOrder` ASC [ RunTime:0.023559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417215 ORDER BY `unit` DESC [ RunTime:0.007531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417215 LIMIT 2 [ RunTime:0.013767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417215 ORDER BY `minOrder` ASC [ RunTime:0.006555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417499 LIMIT 5 [ RunTime:0.003587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417499 ORDER BY `minOrder` ASC [ RunTime:0.003931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417499 ORDER BY `unit` DESC [ RunTime:0.002170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417499 LIMIT 2 [ RunTime:0.006540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417499 ORDER BY `minOrder` ASC [ RunTime:0.002003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417267 LIMIT 5 [ RunTime:0.012294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417267 ORDER BY `minOrder` ASC [ RunTime:0.006623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417267 ORDER BY `unit` DESC [ RunTime:0.016394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417267 LIMIT 2 [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417267 ORDER BY `minOrder` ASC [ RunTime:0.003331s ]
select * from pdf where partno='42232-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384746 LIMIT 5 [ RunTime:0.001368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384746 ORDER BY `minOrder` ASC [ RunTime:0.012342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14384746 ORDER BY `unit` DESC [ RunTime:0.005293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14384746 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384746 ORDER BY `minOrder` ASC [ RunTime:0.004747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11990229 LIMIT 5 [ RunTime:0.006584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11990229 ORDER BY `minOrder` ASC [ RunTime:0.028010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11990229 ORDER BY `unit` DESC [ RunTime:0.001040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11990229 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11990229 ORDER BY `minOrder` ASC [ RunTime:0.006414s ]
select * from pdf where partno='4223PA51G01800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845720 LIMIT 5 [ RunTime:0.007570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845720 ORDER BY `minOrder` ASC [ RunTime:0.018310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845720 ORDER BY `unit` DESC [ RunTime:0.013432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845720 LIMIT 2 [ RunTime:0.006512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845720 ORDER BY `minOrder` ASC [ RunTime:0.030745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845717 LIMIT 5 [ RunTime:0.003428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845717 ORDER BY `minOrder` ASC [ RunTime:0.007622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845717 ORDER BY `unit` DESC [ RunTime:0.005801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845717 LIMIT 2 [ RunTime:0.013131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845717 ORDER BY `minOrder` ASC [ RunTime:0.002279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845486 LIMIT 5 [ RunTime:0.008689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845486 ORDER BY `minOrder` ASC [ RunTime:0.015557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845486 ORDER BY `unit` DESC [ RunTime:0.018369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845486 LIMIT 2 [ RunTime:0.008276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845486 ORDER BY `minOrder` ASC [ RunTime:0.010532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845311 LIMIT 5 [ RunTime:0.010671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845311 ORDER BY `minOrder` ASC [ RunTime:0.015165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845311 ORDER BY `unit` DESC [ RunTime:0.022204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845311 LIMIT 2 [ RunTime:0.028859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845311 ORDER BY `minOrder` ASC [ RunTime:0.008635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845078 LIMIT 5 [ RunTime:0.013655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845078 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845078 ORDER BY `unit` DESC [ RunTime:0.014504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845078 LIMIT 2 [ RunTime:0.036048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845078 ORDER BY `minOrder` ASC [ RunTime:0.005767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17478386 LIMIT 5 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17478386 ORDER BY `minOrder` ASC [ RunTime:0.003044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17478386 ORDER BY `unit` DESC [ RunTime:0.012151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17478386 LIMIT 2 [ RunTime:0.009773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17478386 ORDER BY `minOrder` ASC [ RunTime:0.006067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238116 LIMIT 5 [ RunTime:0.006768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238116 ORDER BY `minOrder` ASC [ RunTime:0.022905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15238116 ORDER BY `unit` DESC [ RunTime:0.036400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15238116 LIMIT 2 [ RunTime:0.021463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238116 ORDER BY `minOrder` ASC [ RunTime:0.009782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393819 LIMIT 5 [ RunTime:0.014600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393819 ORDER BY `minOrder` ASC [ RunTime:0.030672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393819 ORDER BY `unit` DESC [ RunTime:0.027235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393819 LIMIT 2 [ RunTime:0.022454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393819 ORDER BY `minOrder` ASC [ RunTime:0.009351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393817 LIMIT 5 [ RunTime:0.017451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393817 ORDER BY `minOrder` ASC [ RunTime:0.056268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393817 ORDER BY `unit` DESC [ RunTime:0.015870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393817 LIMIT 2 [ RunTime:0.014768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393817 ORDER BY `minOrder` ASC [ RunTime:0.003351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393814 LIMIT 5 [ RunTime:0.024040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393814 ORDER BY `minOrder` ASC [ RunTime:0.003749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393814 ORDER BY `unit` DESC [ RunTime:0.024976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393814 LIMIT 2 [ RunTime:0.026344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393814 ORDER BY `minOrder` ASC [ RunTime:0.006001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393813 LIMIT 5 [ RunTime:0.024142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393813 ORDER BY `minOrder` ASC [ RunTime:0.003578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393813 ORDER BY `unit` DESC [ RunTime:0.010998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393813 LIMIT 2 [ RunTime:0.045384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393813 ORDER BY `minOrder` ASC [ RunTime:0.041740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393810 LIMIT 5 [ RunTime:0.013259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393810 ORDER BY `minOrder` ASC [ RunTime:0.009358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393810 ORDER BY `unit` DESC [ RunTime:0.061017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393810 LIMIT 2 [ RunTime:0.003711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393810 ORDER BY `minOrder` ASC [ RunTime:0.014913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521792 LIMIT 5 [ RunTime:0.014891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521792 ORDER BY `minOrder` ASC [ RunTime:0.008256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13521792 ORDER BY `unit` DESC [ RunTime:0.040303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13521792 LIMIT 2 [ RunTime:0.016817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521792 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521790 LIMIT 5 [ RunTime:0.002475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521790 ORDER BY `minOrder` ASC [ RunTime:0.014978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13521790 ORDER BY `unit` DESC [ RunTime:0.034172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13521790 LIMIT 2 [ RunTime:0.006808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521790 ORDER BY `minOrder` ASC [ RunTime:0.003102s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281669 LIMIT 5 [ RunTime:0.027169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281669 ORDER BY `minOrder` ASC [ RunTime:0.004983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281669 ORDER BY `unit` DESC [ RunTime:0.010177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281669 LIMIT 2 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281669 ORDER BY `minOrder` ASC [ RunTime:0.006803s ]
select * from pdf where partno='42233-7' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.013953s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42233-7' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.036630s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281669 AND `partno` = '42233-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.019926s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639019 LIMIT 5 [ RunTime:0.018282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639019 ORDER BY `minOrder` ASC [ RunTime:0.020509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639019 ORDER BY `unit` DESC [ RunTime:0.013681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639019 LIMIT 2 [ RunTime:0.011376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639019 ORDER BY `minOrder` ASC [ RunTime:0.025072s ]
select * from pdf where partno='42236-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42236-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002539s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639019 AND `partno` = '42236-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639953 LIMIT 5 [ RunTime:0.009909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639953 ORDER BY `minOrder` ASC [ RunTime:0.007201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639953 ORDER BY `unit` DESC [ RunTime:0.002964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639953 LIMIT 2 [ RunTime:0.010680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639953 ORDER BY `minOrder` ASC [ RunTime:0.012484s ]
select * from pdf where partno='42233-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42233-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.036742s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639953 AND `partno` = '42233-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516541 [ RunTime:0.005910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640452 LIMIT 5 [ RunTime:0.025167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640452 ORDER BY `minOrder` ASC [ RunTime:0.021982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640452 ORDER BY `unit` DESC [ RunTime:0.012481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640452 LIMIT 2 [ RunTime:0.007802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640452 ORDER BY `minOrder` ASC [ RunTime:0.009073s ]
select * from pdf where partno='42234-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42234-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010326s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640452 AND `partno` = '42234-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417215 [ RunTime:0.011162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639494 LIMIT 5 [ RunTime:0.003431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639494 ORDER BY `minOrder` ASC [ RunTime:0.033700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639494 ORDER BY `unit` DESC [ RunTime:0.031274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639494 LIMIT 2 [ RunTime:0.006827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639494 ORDER BY `minOrder` ASC [ RunTime:0.005774s ]
select * from pdf where partno='42238-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.028410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42238-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016376s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639494 AND `partno` = '42238-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.056043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516366 [ RunTime:0.026999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640226 LIMIT 5 [ RunTime:0.001779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640226 ORDER BY `minOrder` ASC [ RunTime:0.011889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640226 ORDER BY `unit` DESC [ RunTime:0.021909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640226 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640226 ORDER BY `minOrder` ASC [ RunTime:0.011552s ]
select * from pdf where partno='42232-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42232-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007183s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640226 AND `partno` = '42232-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417267 [ RunTime:0.019792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60641195 LIMIT 5 [ RunTime:0.034353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641195 ORDER BY `minOrder` ASC [ RunTime:0.010799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60641195 ORDER BY `unit` DESC [ RunTime:0.008542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60641195 LIMIT 2 [ RunTime:0.008372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641195 ORDER BY `minOrder` ASC [ RunTime:0.010413s ]
select * from pdf where partno='42238-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.002002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42238-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.033913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64415999 LIMIT 5 [ RunTime:0.007014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415999 ORDER BY `minOrder` ASC [ RunTime:0.014057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64415999 ORDER BY `unit` DESC [ RunTime:0.006536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64415999 LIMIT 2 [ RunTime:0.027173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415999 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='4223PA51G01800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.002804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4223PA51G01800' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.002913s ]
SELECT `id` FROM `stock` WHERE `id` <> 64415999 AND `partno` = '4223PA51G01800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.001288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11990229 [ RunTime:0.004986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56608971 LIMIT 5 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56608971 ORDER BY `minOrder` ASC [ RunTime:0.004748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56608971 ORDER BY `unit` DESC [ RunTime:0.001014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56608971 LIMIT 2 [ RunTime:0.009224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56608971 ORDER BY `minOrder` ASC [ RunTime:0.006443s ]
select * from pdf where partno='422390-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422390-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.013005s ]
SELECT `id` FROM `stock` WHERE `id` <> 56608971 AND `partno` = '422390-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.002201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508747 LIMIT 5 [ RunTime:0.008761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508747 ORDER BY `minOrder` ASC [ RunTime:0.016533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508747 ORDER BY `unit` DESC [ RunTime:0.019427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508747 LIMIT 2 [ RunTime:0.004385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508747 ORDER BY `minOrder` ASC [ RunTime:0.010504s ]
select * from pdf where partno='42238' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42238' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000972s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508747 AND `partno` = '42238' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393819 [ RunTime:0.011655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508737 LIMIT 5 [ RunTime:0.003018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508737 ORDER BY `minOrder` ASC [ RunTime:0.003691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508737 ORDER BY `unit` DESC [ RunTime:0.003843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508737 LIMIT 2 [ RunTime:0.001509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508737 ORDER BY `minOrder` ASC [ RunTime:0.007010s ]
select * from pdf where partno='42230' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42230' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020382s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508737 AND `partno` = '42230' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393817 [ RunTime:0.003212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508734 LIMIT 5 [ RunTime:0.004052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508734 ORDER BY `minOrder` ASC [ RunTime:0.031206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508734 ORDER BY `unit` DESC [ RunTime:0.022953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508734 LIMIT 2 [ RunTime:0.015863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508734 ORDER BY `minOrder` ASC [ RunTime:0.012573s ]
select * from pdf where partno='42232' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42232' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007994s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508734 AND `partno` = '42232' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393814 [ RunTime:0.010434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508733 LIMIT 5 [ RunTime:0.007333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508733 ORDER BY `minOrder` ASC [ RunTime:0.016154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508733 ORDER BY `unit` DESC [ RunTime:0.023421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508733 LIMIT 2 [ RunTime:0.023041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508733 ORDER BY `minOrder` ASC [ RunTime:0.009271s ]
select * from pdf where partno='42234' and brandshort='Brady Corporation' limit 1 [ RunTime:0.035471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42234' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016985s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508733 AND `partno` = '42234' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521792 [ RunTime:0.008898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508731 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508731 ORDER BY `minOrder` ASC [ RunTime:0.013452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508731 ORDER BY `unit` DESC [ RunTime:0.022984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508731 LIMIT 2 [ RunTime:0.009052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508731 ORDER BY `minOrder` ASC [ RunTime:0.016892s ]
select * from pdf where partno='42233' and brandshort='Brady Corporation' limit 1 [ RunTime:0.019673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42233' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.026451s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508731 AND `partno` = '42233' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521790 [ RunTime:0.010320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508729 LIMIT 5 [ RunTime:0.043296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508729 ORDER BY `minOrder` ASC [ RunTime:0.007804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508729 ORDER BY `unit` DESC [ RunTime:0.021848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508729 LIMIT 2 [ RunTime:0.018425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508729 ORDER BY `minOrder` ASC [ RunTime:0.016789s ]
select * from pdf where partno='42235' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42235' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.028617s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508729 AND `partno` = '42235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393813 [ RunTime:0.018782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508726 LIMIT 5 [ RunTime:0.017538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508726 ORDER BY `minOrder` ASC [ RunTime:0.027619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508726 ORDER BY `unit` DESC [ RunTime:0.032818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508726 LIMIT 2 [ RunTime:0.019362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508726 ORDER BY `minOrder` ASC [ RunTime:0.002943s ]
select * from pdf where partno='42231' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42231' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010641s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508726 AND `partno` = '42231' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393810 [ RunTime:0.003420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64418480 LIMIT 5 [ RunTime:0.002116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418480 ORDER BY `minOrder` ASC [ RunTime:0.018713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64418480 ORDER BY `unit` DESC [ RunTime:0.008198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64418480 LIMIT 2 [ RunTime:0.003078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418480 ORDER BY `minOrder` ASC [ RunTime:0.005112s ]
select * from pdf where partno='4223PAX1R03937' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.019213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4223PAX1R03937' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.026310s ]
SELECT `id` FROM `stock` WHERE `id` <> 64418480 AND `partno` = '4223PAX1R03937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.021784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64418360 LIMIT 5 [ RunTime:0.013234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418360 ORDER BY `minOrder` ASC [ RunTime:0.026819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64418360 ORDER BY `unit` DESC [ RunTime:0.026895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64418360 LIMIT 2 [ RunTime:0.020931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418360 ORDER BY `minOrder` ASC [ RunTime:0.008623s ]
select * from pdf where partno='4223PA51H03937' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.020415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4223PA51H03937' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.015566s ]
SELECT `id` FROM `stock` WHERE `id` <> 64418360 AND `partno` = '4223PA51H03937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.010295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262117 [ RunTime:0.027229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64417085 LIMIT 5 [ RunTime:0.027930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64417085 ORDER BY `minOrder` ASC [ RunTime:0.021949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64417085 ORDER BY `unit` DESC [ RunTime:0.020898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64417085 LIMIT 2 [ RunTime:0.013869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64417085 ORDER BY `minOrder` ASC [ RunTime:0.004075s ]
select * from pdf where partno='4223PA51H01800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.021120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4223PA51H01800' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.033521s ]
SELECT `id` FROM `stock` WHERE `id` <> 64417085 AND `partno` = '4223PA51H01800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.018627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13261175 [ RunTime:0.009580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64239303 LIMIT 5 [ RunTime:0.020360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64239303 ORDER BY `minOrder` ASC [ RunTime:0.008963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64239303 ORDER BY `unit` DESC [ RunTime:0.010213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64239303 LIMIT 2 [ RunTime:0.004992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64239303 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='4223.09-405-T8' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4223.09-405-T8' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005165s ]
SELECT `id` FROM `stock` WHERE `id` <> 64239303 AND `partno` = '4223.09-405-T8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol procom%' ) [ RunTime:0.005101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64238630 LIMIT 5 [ RunTime:0.025471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64238630 ORDER BY `minOrder` ASC [ RunTime:0.010499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64238630 ORDER BY `unit` DESC [ RunTime:0.016823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64238630 LIMIT 2 [ RunTime:0.003456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64238630 ORDER BY `minOrder` ASC [ RunTime:0.015070s ]
select * from pdf where partno='4223.06-405-T0' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.005287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4223.06-405-T0' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000905s ]
SELECT `id` FROM `stock` WHERE `id` <> 64238630 AND `partno` = '4223.06-405-T0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol procom%' ) [ RunTime:0.005016s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004444s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009520s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002863s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007883s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023854s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004691s ]
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 '4223%' OR `brand` LIKE '4223%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004515s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4223%' OR `brand` LIKE '4223%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002014s ]