SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001533s ]
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=P6KE51CA&search=1' [ RunTime:0.004297s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002132s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001497s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004182s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.006840s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003006s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000822s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002214s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6KE51CA' LIMIT 1 [ RunTime:0.029035s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-16 16:10:01' WHERE `partno` = 'P6KE51CA' [ RunTime:0.022083s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003401s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016474s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905855 LIMIT 5 [ RunTime:0.017047s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905855 ORDER BY `minOrder` ASC [ RunTime:0.032284s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905855 ORDER BY `unit` DESC [ RunTime:0.018526s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905855 LIMIT 2 [ RunTime:0.041851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905855 ORDER BY `minOrder` ASC [ RunTime:0.035427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916276 LIMIT 5 [ RunTime:0.017783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916276 ORDER BY `minOrder` ASC [ RunTime:0.048628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916276 ORDER BY `unit` DESC [ RunTime:0.026378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916276 LIMIT 2 [ RunTime:0.026426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916276 ORDER BY `minOrder` ASC [ RunTime:0.026545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667321 LIMIT 5 [ RunTime:0.068158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667321 ORDER BY `minOrder` ASC [ RunTime:0.027600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667321 ORDER BY `unit` DESC [ RunTime:0.035829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667321 LIMIT 2 [ RunTime:0.047215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667321 ORDER BY `minOrder` ASC [ RunTime:0.012660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905028 LIMIT 5 [ RunTime:0.024335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905028 ORDER BY `minOrder` ASC [ RunTime:0.054461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905028 ORDER BY `unit` DESC [ RunTime:0.020745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905028 LIMIT 2 [ RunTime:0.048178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905028 ORDER BY `minOrder` ASC [ RunTime:0.028710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662727 LIMIT 5 [ RunTime:0.025811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662727 ORDER BY `minOrder` ASC [ RunTime:0.055351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662727 ORDER BY `unit` DESC [ RunTime:0.039255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662727 LIMIT 2 [ RunTime:0.005929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662727 ORDER BY `minOrder` ASC [ RunTime:0.014687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904599 LIMIT 5 [ RunTime:0.018350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904599 ORDER BY `minOrder` ASC [ RunTime:0.004855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904599 ORDER BY `unit` DESC [ RunTime:0.039999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904599 LIMIT 2 [ RunTime:0.005854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904599 ORDER BY `minOrder` ASC [ RunTime:0.003705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668404 LIMIT 5 [ RunTime:0.013092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668404 ORDER BY `minOrder` ASC [ RunTime:0.033958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668404 ORDER BY `unit` DESC [ RunTime:0.004846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668404 LIMIT 2 [ RunTime:0.009602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668404 ORDER BY `minOrder` ASC [ RunTime:0.020744s ]
select * from pdf where partno='P6KE51CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.012806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803674 LIMIT 5 [ RunTime:0.005258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803674 ORDER BY `minOrder` ASC [ RunTime:0.038086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803674 ORDER BY `unit` DESC [ RunTime:0.006396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803674 LIMIT 2 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803674 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677036 LIMIT 5 [ RunTime:0.001264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677036 ORDER BY `minOrder` ASC [ RunTime:0.010202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677036 ORDER BY `unit` DESC [ RunTime:0.000882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677036 LIMIT 2 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677036 ORDER BY `minOrder` ASC [ RunTime:0.003423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668145 LIMIT 5 [ RunTime:0.016155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668145 ORDER BY `minOrder` ASC [ RunTime:0.014199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668145 ORDER BY `unit` DESC [ RunTime:0.012055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668145 LIMIT 2 [ RunTime:0.004642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668145 ORDER BY `minOrder` ASC [ RunTime:0.001672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668122 LIMIT 5 [ RunTime:0.001162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668122 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668122 ORDER BY `unit` DESC [ RunTime:0.006752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668122 LIMIT 2 [ RunTime:0.026274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668122 ORDER BY `minOrder` ASC [ RunTime:0.005119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667896 LIMIT 5 [ RunTime:0.018106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667896 ORDER BY `minOrder` ASC [ RunTime:0.005554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667896 ORDER BY `unit` DESC [ RunTime:0.017268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667896 LIMIT 2 [ RunTime:0.001514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667896 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831456 LIMIT 5 [ RunTime:0.000914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831456 ORDER BY `minOrder` ASC [ RunTime:0.004253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831456 ORDER BY `unit` DESC [ RunTime:0.003539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831456 LIMIT 2 [ RunTime:0.002122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831456 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818305 LIMIT 5 [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818305 ORDER BY `minOrder` ASC [ RunTime:0.006352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818305 ORDER BY `unit` DESC [ RunTime:0.000669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818305 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818305 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809883 LIMIT 5 [ RunTime:0.001019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809883 ORDER BY `minOrder` ASC [ RunTime:0.003730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809883 ORDER BY `unit` DESC [ RunTime:0.000787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809883 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809883 ORDER BY `minOrder` ASC [ RunTime:0.001344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808572 LIMIT 5 [ RunTime:0.004021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808572 ORDER BY `minOrder` ASC [ RunTime:0.012639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808572 ORDER BY `unit` DESC [ RunTime:0.002483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808572 LIMIT 2 [ RunTime:0.005184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808572 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807826 LIMIT 5 [ RunTime:0.001167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807826 ORDER BY `minOrder` ASC [ RunTime:0.003217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807826 ORDER BY `unit` DESC [ RunTime:0.006947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807826 LIMIT 2 [ RunTime:0.002912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807826 ORDER BY `minOrder` ASC [ RunTime:0.006503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806400 LIMIT 5 [ RunTime:0.004760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806400 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806400 ORDER BY `unit` DESC [ RunTime:0.001085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806400 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806400 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917304 LIMIT 5 [ RunTime:0.002588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917304 ORDER BY `minOrder` ASC [ RunTime:0.005432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917304 ORDER BY `unit` DESC [ RunTime:0.007618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917304 LIMIT 2 [ RunTime:0.023797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917304 ORDER BY `minOrder` ASC [ RunTime:0.004782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915017 LIMIT 5 [ RunTime:0.021259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915017 ORDER BY `minOrder` ASC [ RunTime:0.004664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915017 ORDER BY `unit` DESC [ RunTime:0.008027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915017 LIMIT 2 [ RunTime:0.009482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915017 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
select * from pdf where partno='P6KE51CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007356s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140880 LIMIT 5 [ RunTime:0.014864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140880 ORDER BY `minOrder` ASC [ RunTime:0.017439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140880 ORDER BY `unit` DESC [ RunTime:0.002850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140880 LIMIT 2 [ RunTime:0.014224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140880 ORDER BY `minOrder` ASC [ RunTime:0.023910s ]
select * from pdf where partno='p6ke51ca-at/b' and brandshort='yageo' limit 1 [ RunTime:0.021825s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6ke51ca-at/b' OR `brand` LIKE 'yageo%' ) ) LIMIT 1 [ RunTime:0.006593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026330 LIMIT 5 [ RunTime:0.012971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026330 ORDER BY `minOrder` ASC [ RunTime:0.003893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026330 ORDER BY `unit` DESC [ RunTime:0.007382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026330 LIMIT 2 [ RunTime:0.016948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026330 ORDER BY `minOrder` ASC [ RunTime:0.006368s ]
select * from pdf where partno='p6ke51ca-at/b' and brandshort='yageo' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6ke51ca-at/b' OR `brand` LIKE 'yageo%' ) ) LIMIT 1 [ RunTime:0.002634s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150463 LIMIT 5 [ RunTime:0.009676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150463 ORDER BY `minOrder` ASC [ RunTime:0.005392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150463 ORDER BY `unit` DESC [ RunTime:0.003475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150463 LIMIT 2 [ RunTime:0.000985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150463 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='P6KE51CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.009670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007617s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150463 AND `partno` = 'P6KE51CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.011446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905855 [ RunTime:0.001546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42111549 LIMIT 5 [ RunTime:0.006215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111549 ORDER BY `minOrder` ASC [ RunTime:0.003584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42111549 ORDER BY `unit` DESC [ RunTime:0.031815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42111549 LIMIT 2 [ RunTime:0.016122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111549 ORDER BY `minOrder` ASC [ RunTime:0.004499s ]
select * from pdf where partno='P6KE51CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.006652s ]
SELECT `id` FROM `stock` WHERE `id` <> 42111549 AND `partno` = 'P6KE51CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.003459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916276 [ RunTime:0.021798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42115580 LIMIT 5 [ RunTime:0.013011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115580 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42115580 ORDER BY `unit` DESC [ RunTime:0.001970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42115580 LIMIT 2 [ RunTime:0.006696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115580 ORDER BY `minOrder` ASC [ RunTime:0.000718s ]
select * from pdf where partno='P6KE51CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.016099s ]
SELECT `id` FROM `stock` WHERE `id` <> 42115580 AND `partno` = 'P6KE51CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668404 [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118295 LIMIT 5 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118295 ORDER BY `minOrder` ASC [ RunTime:0.020513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118295 ORDER BY `unit` DESC [ RunTime:0.004836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118295 LIMIT 2 [ RunTime:0.015458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118295 ORDER BY `minOrder` ASC [ RunTime:0.006263s ]
select * from pdf where partno='P6KE51CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.010267s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118295 AND `partno` = 'P6KE51CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.013925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667321 [ RunTime:0.031697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128549 LIMIT 5 [ RunTime:0.003230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128549 ORDER BY `minOrder` ASC [ RunTime:0.008081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128549 ORDER BY `unit` DESC [ RunTime:0.010699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128549 LIMIT 2 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128549 ORDER BY `minOrder` ASC [ RunTime:0.002957s ]
select * from pdf where partno='P6KE51CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.008603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.008378s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128549 AND `partno` = 'P6KE51CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.003354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905028 [ RunTime:0.010520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152102 LIMIT 5 [ RunTime:0.020905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152102 ORDER BY `minOrder` ASC [ RunTime:0.007991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152102 ORDER BY `unit` DESC [ RunTime:0.015658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152102 LIMIT 2 [ RunTime:0.013225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152102 ORDER BY `minOrder` ASC [ RunTime:0.009852s ]
select * from pdf where partno='P6KE51CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.009626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.004529s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152102 AND `partno` = 'P6KE51CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.004918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662727 [ RunTime:0.007930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123008 LIMIT 5 [ RunTime:0.010047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123008 ORDER BY `minOrder` ASC [ RunTime:0.014810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123008 ORDER BY `unit` DESC [ RunTime:0.010468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123008 LIMIT 2 [ RunTime:0.020541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123008 ORDER BY `minOrder` ASC [ RunTime:0.008496s ]
select * from pdf where partno='P6KE51CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.014951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.031482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282641 LIMIT 5 [ RunTime:0.006980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282641 ORDER BY `minOrder` ASC [ RunTime:0.017626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282641 ORDER BY `unit` DESC [ RunTime:0.018959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282641 LIMIT 2 [ RunTime:0.007260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282641 ORDER BY `minOrder` ASC [ RunTime:0.014259s ]
select * from pdf where partno='P6KE51CAHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CAHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.023252s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282641 AND `partno` = 'P6KE51CAHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917304 [ RunTime:0.004381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282621 LIMIT 5 [ RunTime:0.013600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282621 ORDER BY `minOrder` ASC [ RunTime:0.037529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282621 ORDER BY `unit` DESC [ RunTime:0.045222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282621 LIMIT 2 [ RunTime:0.036830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282621 ORDER BY `minOrder` ASC [ RunTime:0.018831s ]
select * from pdf where partno='P6KE51CAHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CAHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011383s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282621 AND `partno` = 'P6KE51CAHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.021785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42275627 LIMIT 5 [ RunTime:0.020935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275627 ORDER BY `minOrder` ASC [ RunTime:0.011183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42275627 ORDER BY `unit` DESC [ RunTime:0.019025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42275627 LIMIT 2 [ RunTime:0.019410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275627 ORDER BY `minOrder` ASC [ RunTime:0.017005s ]
select * from pdf where partno='P6KE51CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.029795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.031684s ]
SELECT `id` FROM `stock` WHERE `id` <> 42275627 AND `partno` = 'P6KE51CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.056987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42241122 LIMIT 5 [ RunTime:0.040541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241122 ORDER BY `minOrder` ASC [ RunTime:0.033576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42241122 ORDER BY `unit` DESC [ RunTime:0.012526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42241122 LIMIT 2 [ RunTime:0.029874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241122 ORDER BY `minOrder` ASC [ RunTime:0.013349s ]
select * from pdf where partno='P6KE51CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.030642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.048737s ]
SELECT `id` FROM `stock` WHERE `id` <> 42241122 AND `partno` = 'P6KE51CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.050278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915017 [ RunTime:0.060148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234039 LIMIT 5 [ RunTime:0.051364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234039 ORDER BY `minOrder` ASC [ RunTime:0.012789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234039 ORDER BY `unit` DESC [ RunTime:0.011819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234039 LIMIT 2 [ RunTime:0.024470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234039 ORDER BY `minOrder` ASC [ RunTime:0.011930s ]
select * from pdf where partno='P6KE51CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.039092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.065530s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234039 AND `partno` = 'P6KE51CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.049357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914905 [ RunTime:0.065351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42233760 LIMIT 5 [ RunTime:0.065033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233760 ORDER BY `minOrder` ASC [ RunTime:0.036103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42233760 ORDER BY `unit` DESC [ RunTime:0.078988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42233760 LIMIT 2 [ RunTime:0.113361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233760 ORDER BY `minOrder` ASC [ RunTime:0.002902s ]
select * from pdf where partno='P6KE51CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.093562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.063210s ]
SELECT `id` FROM `stock` WHERE `id` <> 42233760 AND `partno` = 'P6KE51CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.086147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914948 [ RunTime:0.093650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222938 LIMIT 5 [ RunTime:0.099037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222938 ORDER BY `minOrder` ASC [ RunTime:0.116979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222938 ORDER BY `unit` DESC [ RunTime:0.144155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222938 LIMIT 2 [ RunTime:0.084975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222938 ORDER BY `minOrder` ASC [ RunTime:0.055355s ]
select * from pdf where partno='P6KE51CA A0G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.057154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA A0G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.083300s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222938 AND `partno` = 'P6KE51CA A0G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.061042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677036 [ RunTime:0.050056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222350 LIMIT 5 [ RunTime:0.030760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222350 ORDER BY `minOrder` ASC [ RunTime:0.051529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222350 ORDER BY `unit` DESC [ RunTime:0.078724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222350 LIMIT 2 [ RunTime:0.085226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222350 ORDER BY `minOrder` ASC [ RunTime:0.049431s ]
select * from pdf where partno='P6KE51CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.056364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.058399s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222350 AND `partno` = 'P6KE51CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.046037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809883 [ RunTime:0.025497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42208282 LIMIT 5 [ RunTime:0.043196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42208282 ORDER BY `minOrder` ASC [ RunTime:0.028504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42208282 ORDER BY `unit` DESC [ RunTime:0.040894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42208282 LIMIT 2 [ RunTime:0.055122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42208282 ORDER BY `minOrder` ASC [ RunTime:0.014928s ]
select * from pdf where partno='P6KE51CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.021963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.005063s ]
SELECT `id` FROM `stock` WHERE `id` <> 42208282 AND `partno` = 'P6KE51CA-BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.013695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668145 [ RunTime:0.002988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42207247 LIMIT 5 [ RunTime:0.001799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207247 ORDER BY `minOrder` ASC [ RunTime:0.012471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42207247 ORDER BY `unit` DESC [ RunTime:0.016833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42207247 LIMIT 2 [ RunTime:0.014164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207247 ORDER BY `minOrder` ASC [ RunTime:0.001266s ]
select * from pdf where partno='P6KE51CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.012462s ]
SELECT `id` FROM `stock` WHERE `id` <> 42207247 AND `partno` = 'P6KE51CA-AP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.007902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667896 [ RunTime:0.001680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42207014 LIMIT 5 [ RunTime:0.003391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207014 ORDER BY `minOrder` ASC [ RunTime:0.008939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42207014 ORDER BY `unit` DESC [ RunTime:0.010202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42207014 LIMIT 2 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207014 ORDER BY `minOrder` ASC [ RunTime:0.001401s ]
select * from pdf where partno='P6KE51CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000956s ]
SELECT `id` FROM `stock` WHERE `id` <> 42207014 AND `partno` = 'P6KE51CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818305 [ RunTime:0.001942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42204461 LIMIT 5 [ RunTime:0.001605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204461 ORDER BY `minOrder` ASC [ RunTime:0.001258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42204461 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42204461 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204461 ORDER BY `minOrder` ASC [ RunTime:0.002481s ]
select * from pdf where partno='P6KE51CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.009943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001977s ]
SELECT `id` FROM `stock` WHERE `id` <> 42204461 AND `partno` = 'P6KE51CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.001063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807826 [ RunTime:0.003041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42200192 LIMIT 5 [ RunTime:0.005687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200192 ORDER BY `minOrder` ASC [ RunTime:0.004051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42200192 ORDER BY `unit` DESC [ RunTime:0.001573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42200192 LIMIT 2 [ RunTime:0.007237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200192 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='P6KE51CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE51CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013812s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006092s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003793s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001516s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008648s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007339s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002831s ]
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 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008578s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6KE51CA%' OR `brand` LIKE 'P6KE51CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001423s ]