SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001136s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=66201&search=1' [ RunTime:0.005768s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001257s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001544s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.007215s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.033056s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002861s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001971s ]
SELECT * FROM `stock_search` WHERE `partno` = '66201' LIMIT 1 [ RunTime:0.009724s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-23 09:22:58' WHERE `partno` = '66201' [ RunTime:0.010380s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001825s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032942s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15487839 LIMIT 5 [ RunTime:0.030013s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487839 ORDER BY `minOrder` ASC [ RunTime:0.010401s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15487839 ORDER BY `unit` DESC [ RunTime:0.009440s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15487839 LIMIT 2 [ RunTime:0.014974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487839 ORDER BY `minOrder` ASC [ RunTime:0.008761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850427 LIMIT 5 [ RunTime:0.014221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850427 ORDER BY `minOrder` ASC [ RunTime:0.034568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19850427 ORDER BY `unit` DESC [ RunTime:0.002716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19850427 LIMIT 2 [ RunTime:0.014574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850427 ORDER BY `minOrder` ASC [ RunTime:0.001632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12627270 LIMIT 5 [ RunTime:0.015915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627270 ORDER BY `minOrder` ASC [ RunTime:0.051482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12627270 ORDER BY `unit` DESC [ RunTime:0.010106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12627270 LIMIT 2 [ RunTime:0.018506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627270 ORDER BY `minOrder` ASC [ RunTime:0.008148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11493372 LIMIT 5 [ RunTime:0.003650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11493372 ORDER BY `minOrder` ASC [ RunTime:0.032862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11493372 ORDER BY `unit` DESC [ RunTime:0.020406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11493372 LIMIT 2 [ RunTime:0.017941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11493372 ORDER BY `minOrder` ASC [ RunTime:0.003563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488152 LIMIT 5 [ RunTime:0.017359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488152 ORDER BY `minOrder` ASC [ RunTime:0.002875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11488152 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11488152 LIMIT 2 [ RunTime:0.004853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488152 ORDER BY `minOrder` ASC [ RunTime:0.007667s ]
select * from pdf where partno='662018113322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630817 LIMIT 5 [ RunTime:0.036132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630817 ORDER BY `minOrder` ASC [ RunTime:0.007533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630817 ORDER BY `unit` DESC [ RunTime:0.001726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630817 LIMIT 2 [ RunTime:0.025468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630817 ORDER BY `minOrder` ASC [ RunTime:0.010667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496057 LIMIT 5 [ RunTime:0.007402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496057 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496057 ORDER BY `unit` DESC [ RunTime:0.019201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496057 LIMIT 2 [ RunTime:0.031384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496057 ORDER BY `minOrder` ASC [ RunTime:0.004639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630806 LIMIT 5 [ RunTime:0.023574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630806 ORDER BY `minOrder` ASC [ RunTime:0.018217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630806 ORDER BY `unit` DESC [ RunTime:0.007498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630806 LIMIT 2 [ RunTime:0.008721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630806 ORDER BY `minOrder` ASC [ RunTime:0.009437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496022 LIMIT 5 [ RunTime:0.011905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496022 ORDER BY `minOrder` ASC [ RunTime:0.009091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496022 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496022 LIMIT 2 [ RunTime:0.009876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496022 ORDER BY `minOrder` ASC [ RunTime:0.009923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16224201 LIMIT 5 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224201 ORDER BY `minOrder` ASC [ RunTime:0.017887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16224201 ORDER BY `unit` DESC [ RunTime:0.009678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16224201 LIMIT 2 [ RunTime:0.003185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224201 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
select * from pdf where partno='66201621122' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495986 LIMIT 5 [ RunTime:0.015007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495986 ORDER BY `minOrder` ASC [ RunTime:0.003234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495986 ORDER BY `unit` DESC [ RunTime:0.002840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495986 LIMIT 2 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495986 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617908 LIMIT 5 [ RunTime:0.001596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617908 ORDER BY `minOrder` ASC [ RunTime:0.006422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12617908 ORDER BY `unit` DESC [ RunTime:0.021290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12617908 LIMIT 2 [ RunTime:0.015818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617908 ORDER BY `minOrder` ASC [ RunTime:0.018581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619335 LIMIT 5 [ RunTime:0.052158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619335 ORDER BY `minOrder` ASC [ RunTime:0.023877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619335 ORDER BY `unit` DESC [ RunTime:0.054514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619335 LIMIT 2 [ RunTime:0.024802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619335 ORDER BY `minOrder` ASC [ RunTime:0.017327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851399 LIMIT 5 [ RunTime:0.026693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851399 ORDER BY `minOrder` ASC [ RunTime:0.021434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851399 ORDER BY `unit` DESC [ RunTime:0.050683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851399 LIMIT 2 [ RunTime:0.057582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851399 ORDER BY `minOrder` ASC [ RunTime:0.004276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236755 LIMIT 5 [ RunTime:0.051804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236755 ORDER BY `minOrder` ASC [ RunTime:0.005242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16236755 ORDER BY `unit` DESC [ RunTime:0.034085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16236755 LIMIT 2 [ RunTime:0.028994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236755 ORDER BY `minOrder` ASC [ RunTime:0.012521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191431 LIMIT 5 [ RunTime:0.054050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191431 ORDER BY `minOrder` ASC [ RunTime:0.022288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16191431 ORDER BY `unit` DESC [ RunTime:0.040303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16191431 LIMIT 2 [ RunTime:0.065852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191431 ORDER BY `minOrder` ASC [ RunTime:0.001859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494066 LIMIT 5 [ RunTime:0.003586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494066 ORDER BY `minOrder` ASC [ RunTime:0.012947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15494066 ORDER BY `unit` DESC [ RunTime:0.021542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15494066 LIMIT 2 [ RunTime:0.047622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494066 ORDER BY `minOrder` ASC [ RunTime:0.025134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236748 LIMIT 5 [ RunTime:0.037590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236748 ORDER BY `minOrder` ASC [ RunTime:0.019186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16236748 ORDER BY `unit` DESC [ RunTime:0.032047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16236748 LIMIT 2 [ RunTime:0.036042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236748 ORDER BY `minOrder` ASC [ RunTime:0.029189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236829 LIMIT 5 [ RunTime:0.019982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236829 ORDER BY `minOrder` ASC [ RunTime:0.041323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16236829 ORDER BY `unit` DESC [ RunTime:0.058792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16236829 LIMIT 2 [ RunTime:0.047724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236829 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851495 LIMIT 5 [ RunTime:0.022819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851495 ORDER BY `minOrder` ASC [ RunTime:0.012432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851495 ORDER BY `unit` DESC [ RunTime:0.034242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851495 LIMIT 2 [ RunTime:0.055186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851495 ORDER BY `minOrder` ASC [ RunTime:0.020948s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029236s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59437448 LIMIT 5 [ RunTime:0.010724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437448 ORDER BY `minOrder` ASC [ RunTime:0.013386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59437448 ORDER BY `unit` DESC [ RunTime:0.010583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59437448 LIMIT 2 [ RunTime:0.004804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437448 ORDER BY `minOrder` ASC [ RunTime:0.005512s ]
select * from pdf where partno='66201021122' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005180s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201021122' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.019783s ]
SELECT `id` FROM `stock` WHERE `id` <> 59437448 AND `partno` = '66201021122' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.032069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15487839 [ RunTime:0.013296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936721 LIMIT 5 [ RunTime:0.014951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936721 ORDER BY `minOrder` ASC [ RunTime:0.034500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936721 ORDER BY `unit` DESC [ RunTime:0.011343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936721 LIMIT 2 [ RunTime:0.020105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936721 ORDER BY `minOrder` ASC [ RunTime:0.011204s ]
select * from pdf where partno='662010113322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662010113322' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003500s ]
SELECT `id` FROM `stock` WHERE `id` <> 59936721 AND `partno` = '662010113322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487015 [ RunTime:0.027140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936884 LIMIT 5 [ RunTime:0.004129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936884 ORDER BY `minOrder` ASC [ RunTime:0.026982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936884 ORDER BY `unit` DESC [ RunTime:0.003163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936884 LIMIT 2 [ RunTime:0.003312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936884 ORDER BY `minOrder` ASC [ RunTime:0.004009s ]
select * from pdf where partno='662012113322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662012113322' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000651s ]
SELECT `id` FROM `stock` WHERE `id` <> 59936884 AND `partno` = '662012113322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11493372 [ RunTime:0.004332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59939533 LIMIT 5 [ RunTime:0.011364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939533 ORDER BY `minOrder` ASC [ RunTime:0.004281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59939533 ORDER BY `unit` DESC [ RunTime:0.001305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59939533 LIMIT 2 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939533 ORDER BY `minOrder` ASC [ RunTime:0.006139s ]
select * from pdf where partno='662018113322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662018113322' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007118s ]
SELECT `id` FROM `stock` WHERE `id` <> 59939533 AND `partno` = '662018113322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488152 [ RunTime:0.008630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438133 LIMIT 5 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438133 ORDER BY `minOrder` ASC [ RunTime:0.007338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438133 ORDER BY `unit` DESC [ RunTime:0.002376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438133 LIMIT 2 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438133 ORDER BY `minOrder` ASC [ RunTime:0.005749s ]
select * from pdf where partno='66201621122' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.020530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201621122' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.011109s ]
SELECT `id` FROM `stock` WHERE `id` <> 59438133 AND `partno` = '66201621122' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16224201 [ RunTime:0.002832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59949441 LIMIT 5 [ RunTime:0.002353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59949441 ORDER BY `minOrder` ASC [ RunTime:0.009076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59949441 ORDER BY `unit` DESC [ RunTime:0.006010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59949441 LIMIT 2 [ RunTime:0.031053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59949441 ORDER BY `minOrder` ASC [ RunTime:0.006042s ]
select * from pdf where partno='66201021822' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201021822' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009941s ]
SELECT `id` FROM `stock` WHERE `id` <> 59949441 AND `partno` = '66201021822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.008237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617908 [ RunTime:0.014278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936945 LIMIT 5 [ RunTime:0.012525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936945 ORDER BY `minOrder` ASC [ RunTime:0.031360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936945 ORDER BY `unit` DESC [ RunTime:0.009390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936945 LIMIT 2 [ RunTime:0.011507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936945 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='662014113322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662014113322' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002155s ]
SELECT `id` FROM `stock` WHERE `id` <> 59936945 AND `partno` = '662014113322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12627270 [ RunTime:0.010547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59538562 LIMIT 5 [ RunTime:0.002207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538562 ORDER BY `minOrder` ASC [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59538562 ORDER BY `unit` DESC [ RunTime:0.007345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59538562 LIMIT 2 [ RunTime:0.006282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538562 ORDER BY `minOrder` ASC [ RunTime:0.012423s ]
select * from pdf where partno='66201221122' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201221122' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008201s ]
SELECT `id` FROM `stock` WHERE `id` <> 59538562 AND `partno` = '66201221122' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763280 [ RunTime:0.026419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936738 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936738 ORDER BY `minOrder` ASC [ RunTime:0.003534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936738 ORDER BY `unit` DESC [ RunTime:0.002470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936738 LIMIT 2 [ RunTime:0.009825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936738 ORDER BY `minOrder` ASC [ RunTime:0.007883s ]
select * from pdf where partno='662016113322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662016113322' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010956s ]
SELECT `id` FROM `stock` WHERE `id` <> 59936738 AND `partno` = '662016113322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59538581 LIMIT 5 [ RunTime:0.011044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538581 ORDER BY `minOrder` ASC [ RunTime:0.010211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59538581 ORDER BY `unit` DESC [ RunTime:0.006468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59538581 LIMIT 2 [ RunTime:0.001537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538581 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='66201021022' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201021022' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005816s ]
SELECT `id` FROM `stock` WHERE `id` <> 59538581 AND `partno` = '66201021022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850427 [ RunTime:0.004272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941807 LIMIT 5 [ RunTime:0.004154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941807 ORDER BY `minOrder` ASC [ RunTime:0.009709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941807 ORDER BY `unit` DESC [ RunTime:0.003604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941807 LIMIT 2 [ RunTime:0.003216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941807 ORDER BY `minOrder` ASC [ RunTime:0.009517s ]
select * from pdf where partno='66201821822' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201821822' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003534s ]
SELECT `id` FROM `stock` WHERE `id` <> 59941807 AND `partno` = '66201821822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496057 [ RunTime:0.006384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59538571 LIMIT 5 [ RunTime:0.007295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538571 ORDER BY `minOrder` ASC [ RunTime:0.004520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59538571 ORDER BY `unit` DESC [ RunTime:0.005717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59538571 LIMIT 2 [ RunTime:0.005180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538571 ORDER BY `minOrder` ASC [ RunTime:0.003087s ]
select * from pdf where partno='66201221022' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201221022' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000873s ]
SELECT `id` FROM `stock` WHERE `id` <> 59538571 AND `partno` = '66201221022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494066 [ RunTime:0.017601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59939611 LIMIT 5 [ RunTime:0.004157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939611 ORDER BY `minOrder` ASC [ RunTime:0.007960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59939611 ORDER BY `unit` DESC [ RunTime:0.009043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59939611 LIMIT 2 [ RunTime:0.009663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939611 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='662012013322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662012013322' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.018849s ]
SELECT `id` FROM `stock` WHERE `id` <> 59939611 AND `partno` = '662012013322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630817 [ RunTime:0.000918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59443650 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443650 ORDER BY `minOrder` ASC [ RunTime:0.011053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59443650 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59443650 LIMIT 2 [ RunTime:0.008552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443650 ORDER BY `minOrder` ASC [ RunTime:0.004153s ]
select * from pdf where partno='66201421022' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201421022' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.026981s ]
SELECT `id` FROM `stock` WHERE `id` <> 59443650 AND `partno` = '66201421022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.014702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851307 [ RunTime:0.013770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941687 LIMIT 5 [ RunTime:0.010704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941687 ORDER BY `minOrder` ASC [ RunTime:0.015206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941687 ORDER BY `unit` DESC [ RunTime:0.010267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941687 LIMIT 2 [ RunTime:0.019438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941687 ORDER BY `minOrder` ASC [ RunTime:0.010999s ]
select * from pdf where partno='66201621822' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201621822' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.020238s ]
SELECT `id` FROM `stock` WHERE `id` <> 59941687 AND `partno` = '66201621822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496022 [ RunTime:0.002783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941616 LIMIT 5 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941616 ORDER BY `minOrder` ASC [ RunTime:0.005584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941616 ORDER BY `unit` DESC [ RunTime:0.008700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941616 LIMIT 2 [ RunTime:0.008964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941616 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='66201221822' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66201221822' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000626s ]
SELECT `id` FROM `stock` WHERE `id` <> 59941616 AND `partno` = '66201221822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630806 [ RunTime:0.018896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53082406 LIMIT 5 [ RunTime:0.020278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082406 ORDER BY `minOrder` ASC [ RunTime:0.008077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53082406 ORDER BY `unit` DESC [ RunTime:0.000534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53082406 LIMIT 2 [ RunTime:0.001798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082406 ORDER BY `minOrder` ASC [ RunTime:0.001957s ]
select * from pdf where partno='662011013322' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.028468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662011013322' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005415s ]
SELECT `id` FROM `stock` WHERE `id` <> 53082406 AND `partno` = '662011013322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495986 [ RunTime:0.003158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59540442 LIMIT 5 [ RunTime:0.003645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540442 ORDER BY `minOrder` ASC [ RunTime:0.012556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59540442 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59540442 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540442 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='662014231822' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662014231822' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.016878s ]
SELECT `id` FROM `stock` WHERE `id` <> 59540442 AND `partno` = '662014231822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236755 [ RunTime:0.013111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59540334 LIMIT 5 [ RunTime:0.009353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540334 ORDER BY `minOrder` ASC [ RunTime:0.009750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59540334 ORDER BY `unit` DESC [ RunTime:0.000667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59540334 LIMIT 2 [ RunTime:0.009892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540334 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
select * from pdf where partno='662012231822' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662012231822' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006545s ]
SELECT `id` FROM `stock` WHERE `id` <> 59540334 AND `partno` = '662012231822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191431 [ RunTime:0.021197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59540576 LIMIT 5 [ RunTime:0.003911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540576 ORDER BY `minOrder` ASC [ RunTime:0.003417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59540576 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59540576 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540576 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
select * from pdf where partno='662016231722' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.010664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '662016231722' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004056s ]
SELECT `id` FROM `stock` WHERE `id` <> 59540576 AND `partno` = '662016231722' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494264 [ RunTime:0.001450s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006716s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007912s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001419s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024179s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026848s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015787s ]
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 '66201%' OR `brand` LIKE '66201%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015654s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '66201%' OR `brand` LIKE '66201%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004575s ]