SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001626s ]
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=1.5KE400&search=1' [ RunTime:0.005087s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003019s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001337s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001712s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000664s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001096s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001202s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5KE400' LIMIT 1 [ RunTime:0.012846s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 11:54:05' WHERE `partno` = '1.5KE400' [ RunTime:0.039823s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001716s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052977s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.018615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680537 LIMIT 5 [ RunTime:0.016819s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680537 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680537 ORDER BY `unit` DESC [ RunTime:0.026169s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680537 LIMIT 2 [ RunTime:0.001983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680537 ORDER BY `minOrder` ASC [ RunTime:0.001046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668421 LIMIT 5 [ RunTime:0.043216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668421 ORDER BY `minOrder` ASC [ RunTime:0.024648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668421 ORDER BY `unit` DESC [ RunTime:0.043333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668421 LIMIT 2 [ RunTime:0.046181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668421 ORDER BY `minOrder` ASC [ RunTime:0.023771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800796 LIMIT 5 [ RunTime:0.025195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800796 ORDER BY `minOrder` ASC [ RunTime:0.020762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800796 ORDER BY `unit` DESC [ RunTime:0.016927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800796 LIMIT 2 [ RunTime:0.068986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800796 ORDER BY `minOrder` ASC [ RunTime:0.015700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820081 LIMIT 5 [ RunTime:0.031140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820081 ORDER BY `minOrder` ASC [ RunTime:0.033631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820081 ORDER BY `unit` DESC [ RunTime:0.047380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820081 LIMIT 2 [ RunTime:0.062114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820081 ORDER BY `minOrder` ASC [ RunTime:0.018134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922582 LIMIT 5 [ RunTime:0.038455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922582 ORDER BY `minOrder` ASC [ RunTime:0.045144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922582 ORDER BY `unit` DESC [ RunTime:0.020010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922582 LIMIT 2 [ RunTime:0.022030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922582 ORDER BY `minOrder` ASC [ RunTime:0.041259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810321 LIMIT 5 [ RunTime:0.047674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810321 ORDER BY `minOrder` ASC [ RunTime:0.011524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810321 ORDER BY `unit` DESC [ RunTime:0.020723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810321 LIMIT 2 [ RunTime:0.042320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810321 ORDER BY `minOrder` ASC [ RunTime:0.004032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913857 LIMIT 5 [ RunTime:0.026390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913857 ORDER BY `minOrder` ASC [ RunTime:0.027628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913857 ORDER BY `unit` DESC [ RunTime:0.028254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913857 LIMIT 2 [ RunTime:0.038925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913857 ORDER BY `minOrder` ASC [ RunTime:0.010006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913537 LIMIT 5 [ RunTime:0.014373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913537 ORDER BY `minOrder` ASC [ RunTime:0.048253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913537 ORDER BY `unit` DESC [ RunTime:0.066739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913537 LIMIT 2 [ RunTime:0.049018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913537 ORDER BY `minOrder` ASC [ RunTime:0.014773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833692 LIMIT 5 [ RunTime:0.013857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833692 ORDER BY `minOrder` ASC [ RunTime:0.018490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833692 ORDER BY `unit` DESC [ RunTime:0.017795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833692 LIMIT 2 [ RunTime:0.007123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833692 ORDER BY `minOrder` ASC [ RunTime:0.005591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917917 LIMIT 5 [ RunTime:0.018069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917917 ORDER BY `minOrder` ASC [ RunTime:0.010112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917917 ORDER BY `unit` DESC [ RunTime:0.022566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917917 LIMIT 2 [ RunTime:0.029893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917917 ORDER BY `minOrder` ASC [ RunTime:0.008326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905239 LIMIT 5 [ RunTime:0.007999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905239 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905239 ORDER BY `unit` DESC [ RunTime:0.008812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905239 LIMIT 2 [ RunTime:0.016596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905239 ORDER BY `minOrder` ASC [ RunTime:0.003509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661830 LIMIT 5 [ RunTime:0.036027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661830 ORDER BY `minOrder` ASC [ RunTime:0.003090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661830 ORDER BY `unit` DESC [ RunTime:0.026695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661830 LIMIT 2 [ RunTime:0.003207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661830 ORDER BY `minOrder` ASC [ RunTime:0.003066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907881 LIMIT 5 [ RunTime:0.002433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907881 ORDER BY `minOrder` ASC [ RunTime:0.014489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907881 ORDER BY `unit` DESC [ RunTime:0.001367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907881 LIMIT 2 [ RunTime:0.009059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907881 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803714 LIMIT 5 [ RunTime:0.004813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803714 ORDER BY `minOrder` ASC [ RunTime:0.006775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803714 ORDER BY `unit` DESC [ RunTime:0.006846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803714 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803714 ORDER BY `minOrder` ASC [ RunTime:0.007394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803698 LIMIT 5 [ RunTime:0.012461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803698 ORDER BY `minOrder` ASC [ RunTime:0.021338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803698 ORDER BY `unit` DESC [ RunTime:0.006126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803698 LIMIT 2 [ RunTime:0.016845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803698 ORDER BY `minOrder` ASC [ RunTime:0.023558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907616 LIMIT 5 [ RunTime:0.005369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907616 ORDER BY `minOrder` ASC [ RunTime:0.003012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907616 ORDER BY `unit` DESC [ RunTime:0.001914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907616 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907616 ORDER BY `minOrder` ASC [ RunTime:0.004779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803387 LIMIT 5 [ RunTime:0.010064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803387 ORDER BY `minOrder` ASC [ RunTime:0.014784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803387 ORDER BY `unit` DESC [ RunTime:0.001839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803387 LIMIT 2 [ RunTime:0.001032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803387 ORDER BY `minOrder` ASC [ RunTime:0.003354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802879 LIMIT 5 [ RunTime:0.019029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802879 ORDER BY `minOrder` ASC [ RunTime:0.002455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802879 ORDER BY `unit` DESC [ RunTime:0.001776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802879 LIMIT 2 [ RunTime:0.002687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802879 ORDER BY `minOrder` ASC [ RunTime:0.001604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13923471 LIMIT 5 [ RunTime:0.009095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13923471 ORDER BY `minOrder` ASC [ RunTime:0.017448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13923471 ORDER BY `unit` DESC [ RunTime:0.006564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13923471 LIMIT 2 [ RunTime:0.009502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13923471 ORDER BY `minOrder` ASC [ RunTime:0.008387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6572 LIMIT 5 [ RunTime:0.008316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6572 ORDER BY `minOrder` ASC [ RunTime:0.014693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6572 ORDER BY `unit` DESC [ RunTime:0.013771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6572 LIMIT 2 [ RunTime:0.014458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6572 ORDER BY `minOrder` ASC [ RunTime:0.002605s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CARL' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.014599s ]
SELECT `id` FROM `stock` WHERE `id` <> 6572 AND `partno` = '1.5KE400CARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.013815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13923471 [ RunTime:0.000749s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020590s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156887 LIMIT 5 [ RunTime:0.019136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156887 ORDER BY `minOrder` ASC [ RunTime:0.006675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156887 ORDER BY `unit` DESC [ RunTime:0.011676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156887 LIMIT 2 [ RunTime:0.006904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156887 ORDER BY `minOrder` ASC [ RunTime:0.005283s ]
select * from pdf where partno='1.5KE400ARL' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.053749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400ARL' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.015383s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156887 AND `partno` = '1.5KE400ARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.037497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680537 [ RunTime:0.011057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106162 LIMIT 5 [ RunTime:0.003506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106162 ORDER BY `minOrder` ASC [ RunTime:0.007807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106162 ORDER BY `unit` DESC [ RunTime:0.040931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106162 LIMIT 2 [ RunTime:0.026591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106162 ORDER BY `minOrder` ASC [ RunTime:0.011834s ]
select * from pdf where partno='1.5KE400CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.049890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.030709s ]
SELECT `id` FROM `stock` WHERE `id` <> 42106162 AND `partno` = '1.5KE400CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.039096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917917 [ RunTime:0.060420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42148621 LIMIT 5 [ RunTime:0.020868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148621 ORDER BY `minOrder` ASC [ RunTime:0.059424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42148621 ORDER BY `unit` DESC [ RunTime:0.044175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42148621 LIMIT 2 [ RunTime:0.001345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148621 ORDER BY `minOrder` ASC [ RunTime:0.011910s ]
select * from pdf where partno='1.5KE400CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.044219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.027001s ]
SELECT `id` FROM `stock` WHERE `id` <> 42148621 AND `partno` = '1.5KE400CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.060415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800796 [ RunTime:0.006265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118758 LIMIT 5 [ RunTime:0.049246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118758 ORDER BY `minOrder` ASC [ RunTime:0.027039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118758 ORDER BY `unit` DESC [ RunTime:0.075367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118758 LIMIT 2 [ RunTime:0.174227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118758 ORDER BY `minOrder` ASC [ RunTime:0.037755s ]
select * from pdf where partno='1.5KE400CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.026622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.063294s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118758 AND `partno` = '1.5KE400CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.046945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820081 [ RunTime:0.058272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42157241 LIMIT 5 [ RunTime:0.064028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157241 ORDER BY `minOrder` ASC [ RunTime:0.036902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42157241 ORDER BY `unit` DESC [ RunTime:0.077427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42157241 LIMIT 2 [ RunTime:0.060388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157241 ORDER BY `minOrder` ASC [ RunTime:0.017921s ]
select * from pdf where partno='1.5KE400CA' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.052248s ]
select foldpath,foldpath2,filename from pdf_file where id=310456 limit 1 [ RunTime:0.016522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.037126s ]
SELECT `id` FROM `stock` WHERE `id` <> 42157241 AND `partno` = '1.5KE400CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.025466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810321 [ RunTime:0.086785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168332 LIMIT 5 [ RunTime:0.051343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168332 ORDER BY `minOrder` ASC [ RunTime:0.072999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168332 ORDER BY `unit` DESC [ RunTime:0.073268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168332 LIMIT 2 [ RunTime:0.041715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168332 ORDER BY `minOrder` ASC [ RunTime:0.026787s ]
select * from pdf where partno='1.5KE400CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.049466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42120143 LIMIT 5 [ RunTime:0.063249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120143 ORDER BY `minOrder` ASC [ RunTime:0.068098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42120143 ORDER BY `unit` DESC [ RunTime:0.056379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42120143 LIMIT 2 [ RunTime:0.012099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120143 ORDER BY `minOrder` ASC [ RunTime:0.005991s ]
select * from pdf where partno='1.5KE400CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.026540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.048095s ]
SELECT `id` FROM `stock` WHERE `id` <> 42120143 AND `partno` = '1.5KE400CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.043471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922582 [ RunTime:0.035802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132649 LIMIT 5 [ RunTime:0.035636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132649 ORDER BY `minOrder` ASC [ RunTime:0.032002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132649 ORDER BY `unit` DESC [ RunTime:0.047050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132649 LIMIT 2 [ RunTime:0.023124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132649 ORDER BY `minOrder` ASC [ RunTime:0.027160s ]
select * from pdf where partno='1.5KE400A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.031128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.030493s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132649 AND `partno` = '1.5KE400A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.034020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833692 [ RunTime:0.020847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143451 LIMIT 5 [ RunTime:0.051936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143451 ORDER BY `minOrder` ASC [ RunTime:0.067455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143451 ORDER BY `unit` DESC [ RunTime:0.051138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143451 LIMIT 2 [ RunTime:0.035352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143451 ORDER BY `minOrder` ASC [ RunTime:0.009201s ]
select * from pdf where partno='1.5KE400A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.016562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.021443s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143451 AND `partno` = '1.5KE400A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.015181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905239 [ RunTime:0.031538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156911 LIMIT 5 [ RunTime:0.015304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156911 ORDER BY `minOrder` ASC [ RunTime:0.019013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156911 ORDER BY `unit` DESC [ RunTime:0.024522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156911 LIMIT 2 [ RunTime:0.013225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156911 ORDER BY `minOrder` ASC [ RunTime:0.023991s ]
select * from pdf where partno='1.5KE400CARL' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.012823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CARL' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.010171s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156911 AND `partno` = '1.5KE400CARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.020014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6572 [ RunTime:0.023220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13923471 [ RunTime:0.003058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143469 LIMIT 5 [ RunTime:0.019019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143469 ORDER BY `minOrder` ASC [ RunTime:0.007371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143469 ORDER BY `unit` DESC [ RunTime:0.008914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143469 LIMIT 2 [ RunTime:0.012356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143469 ORDER BY `minOrder` ASC [ RunTime:0.002607s ]
select * from pdf where partno='1.5KE400CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.008317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.020841s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143469 AND `partno` = '1.5KE400CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.010187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661830 [ RunTime:0.007388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169676 LIMIT 5 [ RunTime:0.003896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169676 ORDER BY `minOrder` ASC [ RunTime:0.015031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169676 ORDER BY `unit` DESC [ RunTime:0.003908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169676 LIMIT 2 [ RunTime:0.013016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169676 ORDER BY `minOrder` ASC [ RunTime:0.003476s ]
select * from pdf where partno='1.5KE400A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.005587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155856 LIMIT 5 [ RunTime:0.003687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155856 ORDER BY `minOrder` ASC [ RunTime:0.010416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155856 ORDER BY `unit` DESC [ RunTime:0.001249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155856 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155856 ORDER BY `minOrder` ASC [ RunTime:0.000804s ]
select * from pdf where partno='1.5KE400CA' and brandshort='EVVO' limit 1 [ RunTime:0.001254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA' OR `brand` LIKE 'EVVO%' ) ) LIMIT 1 [ RunTime:0.001199s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155856 AND `partno` = '1.5KE400CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%evvo%' ) [ RunTime:0.004187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803714 [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155593 LIMIT 5 [ RunTime:0.006895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155593 ORDER BY `minOrder` ASC [ RunTime:0.002282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155593 ORDER BY `unit` DESC [ RunTime:0.002677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155593 LIMIT 2 [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155593 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
select * from pdf where partno='1.5KE400A' and brandshort='EVVO' limit 1 [ RunTime:0.002449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A' OR `brand` LIKE 'EVVO%' ) ) LIMIT 1 [ RunTime:0.002221s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155593 AND `partno` = '1.5KE400A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%evvo%' ) [ RunTime:0.001601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803698 [ RunTime:0.004826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156831 LIMIT 5 [ RunTime:0.005919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156831 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156831 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156831 LIMIT 2 [ RunTime:0.017858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156831 ORDER BY `minOrder` ASC [ RunTime:0.004786s ]
select * from pdf where partno='1.5KE400A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.004200s ]
select foldpath,foldpath2,filename from pdf_file where id=310456 limit 1 [ RunTime:0.000818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.000947s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156831 AND `partno` = '1.5KE400A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913537 [ RunTime:0.002641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143436 LIMIT 5 [ RunTime:0.011047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143436 ORDER BY `minOrder` ASC [ RunTime:0.027098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143436 ORDER BY `unit` DESC [ RunTime:0.040665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143436 LIMIT 2 [ RunTime:0.041602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143436 ORDER BY `minOrder` ASC [ RunTime:0.028467s ]
select * from pdf where partno='1.5KE400A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.056835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.055875s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143436 AND `partno` = '1.5KE400A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.043927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665231 [ RunTime:0.021176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42121993 LIMIT 5 [ RunTime:0.034276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42121993 ORDER BY `minOrder` ASC [ RunTime:0.043697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42121993 ORDER BY `unit` DESC [ RunTime:0.053816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42121993 LIMIT 2 [ RunTime:0.133427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42121993 ORDER BY `minOrder` ASC [ RunTime:0.022671s ]
select * from pdf where partno='1.5KE400A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.019827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.039729s ]
SELECT `id` FROM `stock` WHERE `id` <> 42121993 AND `partno` = '1.5KE400A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.017782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913857 [ RunTime:0.036014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42119303 LIMIT 5 [ RunTime:0.050184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119303 ORDER BY `minOrder` ASC [ RunTime:0.032854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42119303 ORDER BY `unit` DESC [ RunTime:0.033601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42119303 LIMIT 2 [ RunTime:0.024076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119303 ORDER BY `minOrder` ASC [ RunTime:0.020477s ]
select * from pdf where partno='1.5KE400CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.019779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.023272s ]
SELECT `id` FROM `stock` WHERE `id` <> 42119303 AND `partno` = '1.5KE400CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.020291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802879 [ RunTime:0.003406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170486 LIMIT 5 [ RunTime:0.016125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170486 ORDER BY `minOrder` ASC [ RunTime:0.011573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170486 ORDER BY `unit` DESC [ RunTime:0.005844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170486 LIMIT 2 [ RunTime:0.011326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170486 ORDER BY `minOrder` ASC [ RunTime:0.005873s ]
select * from pdf where partno='1.5KE400A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.004825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.014669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168052 LIMIT 5 [ RunTime:0.006136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168052 ORDER BY `minOrder` ASC [ RunTime:0.002622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168052 ORDER BY `unit` DESC [ RunTime:0.006965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168052 LIMIT 2 [ RunTime:0.004038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168052 ORDER BY `minOrder` ASC [ RunTime:0.010193s ]
select * from pdf where partno='1.5KE400A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE400A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000912s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168052 AND `partno` = '1.5KE400A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668421 [ RunTime:0.005758s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001278s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006761s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006968s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030252s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025903s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019381s ]
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 '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020248s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5KE400%' OR `brand` LIKE '1.5KE400%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018409s ]