SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001693s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=P6KE16C&search=1' [ RunTime:0.003806s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001248s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000489s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001671s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001817s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006030s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002548s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6KE16C' LIMIT 1 [ RunTime:0.001573s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-17 14:39:59' WHERE `partno` = 'P6KE16C' [ RunTime:0.011005s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002374s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036936s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800432 LIMIT 5 [ RunTime:0.026848s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.027339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800432 ORDER BY `minOrder` ASC [ RunTime:0.008594s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800432 ORDER BY `unit` DESC [ RunTime:0.011859s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800432 LIMIT 2 [ RunTime:0.021150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800432 ORDER BY `minOrder` ASC [ RunTime:0.024416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801951 LIMIT 5 [ RunTime:0.014502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801951 ORDER BY `minOrder` ASC [ RunTime:0.011413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801951 ORDER BY `unit` DESC [ RunTime:0.037591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801951 LIMIT 2 [ RunTime:0.031557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801951 ORDER BY `minOrder` ASC [ RunTime:0.014785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904967 LIMIT 5 [ RunTime:0.008869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904967 ORDER BY `minOrder` ASC [ RunTime:0.022322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904967 ORDER BY `unit` DESC [ RunTime:0.029741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904967 LIMIT 2 [ RunTime:0.021742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904967 ORDER BY `minOrder` ASC [ RunTime:0.006158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818009 LIMIT 5 [ RunTime:0.023680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818009 ORDER BY `minOrder` ASC [ RunTime:0.021858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818009 ORDER BY `unit` DESC [ RunTime:0.024416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818009 LIMIT 2 [ RunTime:0.029546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818009 ORDER BY `minOrder` ASC [ RunTime:0.021927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664452 LIMIT 5 [ RunTime:0.013700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664452 ORDER BY `minOrder` ASC [ RunTime:0.021634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664452 ORDER BY `unit` DESC [ RunTime:0.008730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664452 LIMIT 2 [ RunTime:0.023441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664452 ORDER BY `minOrder` ASC [ RunTime:0.001804s ]
select * from pdf where partno='P6KE16CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.027626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802977 LIMIT 5 [ RunTime:0.034079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802977 ORDER BY `minOrder` ASC [ RunTime:0.007545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802977 ORDER BY `unit` DESC [ RunTime:0.029402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802977 LIMIT 2 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802977 ORDER BY `minOrder` ASC [ RunTime:0.008799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664860 LIMIT 5 [ RunTime:0.011718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664860 ORDER BY `minOrder` ASC [ RunTime:0.010256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664860 ORDER BY `unit` DESC [ RunTime:0.014624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664860 LIMIT 2 [ RunTime:0.008744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664860 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
select * from pdf where partno='P6KE16CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691072 LIMIT 5 [ RunTime:0.012325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691072 ORDER BY `minOrder` ASC [ RunTime:0.036646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691072 ORDER BY `unit` DESC [ RunTime:0.014601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691072 LIMIT 2 [ RunTime:0.028474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691072 ORDER BY `minOrder` ASC [ RunTime:0.014249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688714 LIMIT 5 [ RunTime:0.015173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688714 ORDER BY `minOrder` ASC [ RunTime:0.019286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688714 ORDER BY `unit` DESC [ RunTime:0.020087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688714 LIMIT 2 [ RunTime:0.029211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688714 ORDER BY `minOrder` ASC [ RunTime:0.010099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688713 LIMIT 5 [ RunTime:0.004046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688713 ORDER BY `minOrder` ASC [ RunTime:0.010207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688713 ORDER BY `unit` DESC [ RunTime:0.022581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688713 LIMIT 2 [ RunTime:0.043250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688713 ORDER BY `minOrder` ASC [ RunTime:0.007957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687885 LIMIT 5 [ RunTime:0.007371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687885 ORDER BY `minOrder` ASC [ RunTime:0.013097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687885 ORDER BY `unit` DESC [ RunTime:0.005700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687885 LIMIT 2 [ RunTime:0.027308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687885 ORDER BY `minOrder` ASC [ RunTime:0.002568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666816 LIMIT 5 [ RunTime:0.011825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666816 ORDER BY `minOrder` ASC [ RunTime:0.003276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666816 ORDER BY `unit` DESC [ RunTime:0.010038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666816 LIMIT 2 [ RunTime:0.013600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666816 ORDER BY `minOrder` ASC [ RunTime:0.008608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828454 LIMIT 5 [ RunTime:0.037224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828454 ORDER BY `minOrder` ASC [ RunTime:0.007364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828454 ORDER BY `unit` DESC [ RunTime:0.002675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828454 LIMIT 2 [ RunTime:0.007004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828454 ORDER BY `minOrder` ASC [ RunTime:0.007847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828453 LIMIT 5 [ RunTime:0.016694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828453 ORDER BY `minOrder` ASC [ RunTime:0.017867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828453 ORDER BY `unit` DESC [ RunTime:0.024813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828453 LIMIT 2 [ RunTime:0.033148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828453 ORDER BY `minOrder` ASC [ RunTime:0.007670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828452 LIMIT 5 [ RunTime:0.028738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828452 ORDER BY `minOrder` ASC [ RunTime:0.039112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828452 ORDER BY `unit` DESC [ RunTime:0.006148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828452 LIMIT 2 [ RunTime:0.025725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828452 ORDER BY `minOrder` ASC [ RunTime:0.016724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827247 LIMIT 5 [ RunTime:0.036812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827247 ORDER BY `minOrder` ASC [ RunTime:0.028369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827247 ORDER BY `unit` DESC [ RunTime:0.020058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827247 LIMIT 2 [ RunTime:0.026723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827247 ORDER BY `minOrder` ASC [ RunTime:0.027282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810414 LIMIT 5 [ RunTime:0.013585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810414 ORDER BY `minOrder` ASC [ RunTime:0.095589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810414 ORDER BY `unit` DESC [ RunTime:0.087036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810414 LIMIT 2 [ RunTime:0.024982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810414 ORDER BY `minOrder` ASC [ RunTime:0.008484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808565 LIMIT 5 [ RunTime:0.036339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808565 ORDER BY `minOrder` ASC [ RunTime:0.025924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808565 ORDER BY `unit` DESC [ RunTime:0.025558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808565 LIMIT 2 [ RunTime:0.030721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808565 ORDER BY `minOrder` ASC [ RunTime:0.008425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807824 LIMIT 5 [ RunTime:0.049597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807824 ORDER BY `minOrder` ASC [ RunTime:0.041442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807824 ORDER BY `unit` DESC [ RunTime:0.039301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807824 LIMIT 2 [ RunTime:0.018928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807824 ORDER BY `minOrder` ASC [ RunTime:0.027121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807793 LIMIT 5 [ RunTime:0.045077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807793 ORDER BY `minOrder` ASC [ RunTime:0.042436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807793 ORDER BY `unit` DESC [ RunTime:0.023666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807793 LIMIT 2 [ RunTime:0.053281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807793 ORDER BY `minOrder` ASC [ RunTime:0.026084s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024480s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145318 LIMIT 5 [ RunTime:0.030784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145318 ORDER BY `minOrder` ASC [ RunTime:0.055350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145318 ORDER BY `unit` DESC [ RunTime:0.015419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145318 LIMIT 2 [ RunTime:0.095144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145318 ORDER BY `minOrder` ASC [ RunTime:0.034636s ]
select * from pdf where partno='P6KE16CARL' and brandshort='onsemi' limit 1 [ RunTime:0.073583s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.013682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CARL' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.097354s ]
SELECT `id` FROM `stock` WHERE `id` <> 42145318 AND `partno` = 'P6KE16CARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.124182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800432 [ RunTime:0.049342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162190 LIMIT 5 [ RunTime:0.105145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162190 ORDER BY `minOrder` ASC [ RunTime:0.070212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162190 ORDER BY `unit` DESC [ RunTime:0.046769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162190 LIMIT 2 [ RunTime:0.022148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162190 ORDER BY `minOrder` ASC [ RunTime:0.039850s ]
select * from pdf where partno='P6KE16CA' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.027086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.010952s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162190 AND `partno` = 'P6KE16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.021842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801951 [ RunTime:0.018288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109596 LIMIT 5 [ RunTime:0.031786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109596 ORDER BY `minOrder` ASC [ RunTime:0.033911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109596 ORDER BY `unit` DESC [ RunTime:0.002679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109596 LIMIT 2 [ RunTime:0.049257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109596 ORDER BY `minOrder` ASC [ RunTime:0.034634s ]
select * from pdf where partno='P6KE16CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.023766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.046584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104290 LIMIT 5 [ RunTime:0.038600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104290 ORDER BY `minOrder` ASC [ RunTime:0.028485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104290 ORDER BY `unit` DESC [ RunTime:0.033486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104290 LIMIT 2 [ RunTime:0.034077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104290 ORDER BY `minOrder` ASC [ RunTime:0.015918s ]
select * from pdf where partno='P6KE16CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.022937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.038037s ]
SELECT `id` FROM `stock` WHERE `id` <> 42104290 AND `partno` = 'P6KE16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.011255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664452 [ RunTime:0.027483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170319 LIMIT 5 [ RunTime:0.028853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170319 ORDER BY `minOrder` ASC [ RunTime:0.007086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170319 ORDER BY `unit` DESC [ RunTime:0.006419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170319 LIMIT 2 [ RunTime:0.024350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170319 ORDER BY `minOrder` ASC [ RunTime:0.020275s ]
select * from pdf where partno='P6KE16CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.012831s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170319 AND `partno` = 'P6KE16CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.014794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664860 [ RunTime:0.020146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42281789 LIMIT 5 [ RunTime:0.016769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281789 ORDER BY `minOrder` ASC [ RunTime:0.003325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42281789 ORDER BY `unit` DESC [ RunTime:0.007801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42281789 LIMIT 2 [ RunTime:0.009518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281789 ORDER BY `minOrder` ASC [ RunTime:0.027844s ]
select * from pdf where partno='P6KE16CAHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CAHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013985s ]
SELECT `id` FROM `stock` WHERE `id` <> 42281789 AND `partno` = 'P6KE16CAHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.024745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42281201 LIMIT 5 [ RunTime:0.043308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281201 ORDER BY `minOrder` ASC [ RunTime:0.016642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42281201 ORDER BY `unit` DESC [ RunTime:0.010131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42281201 LIMIT 2 [ RunTime:0.003584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281201 ORDER BY `minOrder` ASC [ RunTime:0.001527s ]
select * from pdf where partno='P6KE16CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002826s ]
SELECT `id` FROM `stock` WHERE `id` <> 42281201 AND `partno` = 'P6KE16CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.005297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828453 [ RunTime:0.004719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42277057 LIMIT 5 [ RunTime:0.028278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277057 ORDER BY `minOrder` ASC [ RunTime:0.018154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42277057 ORDER BY `unit` DESC [ RunTime:0.001510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42277057 LIMIT 2 [ RunTime:0.008124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277057 ORDER BY `minOrder` ASC [ RunTime:0.001069s ]
select * from pdf where partno='P6KE16CAHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CAHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006770s ]
SELECT `id` FROM `stock` WHERE `id` <> 42277057 AND `partno` = 'P6KE16CAHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917299 [ RunTime:0.002723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222335 LIMIT 5 [ RunTime:0.008826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222335 ORDER BY `minOrder` ASC [ RunTime:0.029088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222335 ORDER BY `unit` DESC [ RunTime:0.037949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222335 LIMIT 2 [ RunTime:0.003150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222335 ORDER BY `minOrder` ASC [ RunTime:0.010092s ]
select * from pdf where partno='P6KE16CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.027045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.019748s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222335 AND `partno` = 'P6KE16CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.030766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913182 [ RunTime:0.033274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222250 LIMIT 5 [ RunTime:0.021076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222250 ORDER BY `minOrder` ASC [ RunTime:0.003923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222250 ORDER BY `unit` DESC [ RunTime:0.008010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222250 LIMIT 2 [ RunTime:0.002519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222250 ORDER BY `minOrder` ASC [ RunTime:0.015201s ]
select * from pdf where partno='P6KE16C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.017346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.013423s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222250 AND `partno` = 'P6KE16C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.002263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913621 [ RunTime:0.010836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222206 LIMIT 5 [ RunTime:0.025327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222206 ORDER BY `minOrder` ASC [ RunTime:0.010793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222206 ORDER BY `unit` DESC [ RunTime:0.012445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222206 LIMIT 2 [ RunTime:0.012611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222206 ORDER BY `minOrder` ASC [ RunTime:0.003153s ]
select * from pdf where partno='P6KE16CH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.004384s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222206 AND `partno` = 'P6KE16CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.002641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810414 [ RunTime:0.032150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222148 LIMIT 5 [ RunTime:0.017373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222148 ORDER BY `minOrder` ASC [ RunTime:0.044685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222148 ORDER BY `unit` DESC [ RunTime:0.032494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222148 LIMIT 2 [ RunTime:0.021683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222148 ORDER BY `minOrder` ASC [ RunTime:0.007371s ]
select * from pdf where partno='P6KE16CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.016080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.015378s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222148 AND `partno` = 'P6KE16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.060449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919619 [ RunTime:0.012328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42209404 LIMIT 5 [ RunTime:0.013891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209404 ORDER BY `minOrder` ASC [ RunTime:0.019451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42209404 ORDER BY `unit` DESC [ RunTime:0.036537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42209404 LIMIT 2 [ RunTime:0.016207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209404 ORDER BY `minOrder` ASC [ RunTime:0.007118s ]
select * from pdf where partno='P6KE16CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.032204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.012034s ]
SELECT `id` FROM `stock` WHERE `id` <> 42209404 AND `partno` = 'P6KE16CA-BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.016245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911778 [ RunTime:0.002567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42207662 LIMIT 5 [ RunTime:0.025687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207662 ORDER BY `minOrder` ASC [ RunTime:0.048010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42207662 ORDER BY `unit` DESC [ RunTime:0.029954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42207662 LIMIT 2 [ RunTime:0.051900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207662 ORDER BY `minOrder` ASC [ RunTime:0.018624s ]
select * from pdf where partno='P6KE16CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.034812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.054704s ]
SELECT `id` FROM `stock` WHERE `id` <> 42207662 AND `partno` = 'P6KE16CA-AP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.026040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807793 [ RunTime:0.038618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42206988 LIMIT 5 [ RunTime:0.048615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42206988 ORDER BY `minOrder` ASC [ RunTime:0.057530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42206988 ORDER BY `unit` DESC [ RunTime:0.054989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42206988 LIMIT 2 [ RunTime:0.067776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42206988 ORDER BY `minOrder` ASC [ RunTime:0.113359s ]
select * from pdf where partno='P6KE16CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.071201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.038915s ]
SELECT `id` FROM `stock` WHERE `id` <> 42206988 AND `partno` = 'P6KE16CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.049312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920128 [ RunTime:0.060821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42204447 LIMIT 5 [ RunTime:0.083775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204447 ORDER BY `minOrder` ASC [ RunTime:0.032071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42204447 ORDER BY `unit` DESC [ RunTime:0.005636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42204447 LIMIT 2 [ RunTime:0.000923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204447 ORDER BY `minOrder` ASC [ RunTime:0.045357s ]
select * from pdf where partno='P6KE16CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.035680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012190s ]
SELECT `id` FROM `stock` WHERE `id` <> 42204447 AND `partno` = 'P6KE16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.029740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807824 [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42204090 LIMIT 5 [ RunTime:0.063852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204090 ORDER BY `minOrder` ASC [ RunTime:0.070820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42204090 ORDER BY `unit` DESC [ RunTime:0.024740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42204090 LIMIT 2 [ RunTime:0.002056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204090 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
select * from pdf where partno='P6KE16CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.038529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.018594s ]
SELECT `id` FROM `stock` WHERE `id` <> 42204090 AND `partno` = 'P6KE16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.025438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911978 [ RunTime:0.063636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42200187 LIMIT 5 [ RunTime:0.020418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200187 ORDER BY `minOrder` ASC [ RunTime:0.060022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42200187 ORDER BY `unit` DESC [ RunTime:0.027169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42200187 LIMIT 2 [ RunTime:0.021815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200187 ORDER BY `minOrder` ASC [ RunTime:0.020052s ]
select * from pdf where partno='P6KE16CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.027410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42200033 LIMIT 5 [ RunTime:0.074791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200033 ORDER BY `minOrder` ASC [ RunTime:0.016663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42200033 ORDER BY `unit` DESC [ RunTime:0.029296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42200033 LIMIT 2 [ RunTime:0.073800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200033 ORDER BY `minOrder` ASC [ RunTime:0.031583s ]
select * from pdf where partno='P6KE16CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.053347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42191230 LIMIT 5 [ RunTime:0.105185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191230 ORDER BY `minOrder` ASC [ RunTime:0.025863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42191230 ORDER BY `unit` DESC [ RunTime:0.026964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42191230 LIMIT 2 [ RunTime:0.037007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191230 ORDER BY `minOrder` ASC [ RunTime:0.055096s ]
select * from pdf where partno='P6KE16CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.017071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE16CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000633s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038804s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040627s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037895s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.101214s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065783s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034606s ]
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 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037105s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6KE16C%' OR `brand` LIKE 'P6KE16C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.035586s ]