SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001939s ]
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.5KE300A&search=1' [ RunTime:0.003400s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001877s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000484s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001189s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000261s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000972s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000218s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.010205s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5KE300A' LIMIT 1 [ RunTime:0.008804s ]
UPDATE `stock_search` SET `count` = 1439 , `updatetime` = '2026-08-21 11:16:52' WHERE `partno` = '1.5KE300A' [ RunTime:0.011885s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001515s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003684s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662812 LIMIT 5 [ RunTime:0.019268s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662812 ORDER BY `minOrder` ASC [ RunTime:0.011014s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662812 ORDER BY `unit` DESC [ RunTime:0.029633s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662812 LIMIT 2 [ RunTime:0.011268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662812 ORDER BY `minOrder` ASC [ RunTime:0.003875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810741 LIMIT 5 [ RunTime:0.014313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810741 ORDER BY `minOrder` ASC [ RunTime:0.003308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810741 ORDER BY `unit` DESC [ RunTime:0.035386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810741 LIMIT 2 [ RunTime:0.012365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810741 ORDER BY `minOrder` ASC [ RunTime:0.001509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919585 LIMIT 5 [ RunTime:0.013760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919585 ORDER BY `minOrder` ASC [ RunTime:0.022905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919585 ORDER BY `unit` DESC [ RunTime:0.013372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919585 LIMIT 2 [ RunTime:0.030081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919585 ORDER BY `minOrder` ASC [ RunTime:0.009754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913248 LIMIT 5 [ RunTime:0.018633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913248 ORDER BY `minOrder` ASC [ RunTime:0.041502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913248 ORDER BY `unit` DESC [ RunTime:0.028804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913248 LIMIT 2 [ RunTime:0.023613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913248 ORDER BY `minOrder` ASC [ RunTime:0.011985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661727 LIMIT 5 [ RunTime:0.012928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661727 ORDER BY `minOrder` ASC [ RunTime:0.010809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661727 ORDER BY `unit` DESC [ RunTime:0.059740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661727 LIMIT 2 [ RunTime:0.033491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661727 ORDER BY `minOrder` ASC [ RunTime:0.021663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802894 LIMIT 5 [ RunTime:0.028006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802894 ORDER BY `minOrder` ASC [ RunTime:0.032039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802894 ORDER BY `unit` DESC [ RunTime:0.026672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802894 LIMIT 2 [ RunTime:0.047339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802894 ORDER BY `minOrder` ASC [ RunTime:0.011859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811 LIMIT 5 [ RunTime:0.034221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811 ORDER BY `minOrder` ASC [ RunTime:0.026716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811 ORDER BY `unit` DESC [ RunTime:0.047607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811 LIMIT 2 [ RunTime:0.033152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811 ORDER BY `minOrder` ASC [ RunTime:0.030098s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.016697s ]
SELECT `id` FROM `stock` WHERE `id` <> 14811 AND `partno` = '1.5KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.013721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810741 [ RunTime:0.035595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692762 LIMIT 5 [ RunTime:0.033252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692762 ORDER BY `minOrder` ASC [ RunTime:0.039206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692762 ORDER BY `unit` DESC [ RunTime:0.025044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692762 LIMIT 2 [ RunTime:0.022281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692762 ORDER BY `minOrder` ASC [ RunTime:0.024346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16686883 LIMIT 5 [ RunTime:0.015148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686883 ORDER BY `minOrder` ASC [ RunTime:0.053638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16686883 ORDER BY `unit` DESC [ RunTime:0.071739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16686883 LIMIT 2 [ RunTime:0.022063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686883 ORDER BY `minOrder` ASC [ RunTime:0.022406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679025 LIMIT 5 [ RunTime:0.057534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679025 ORDER BY `minOrder` ASC [ RunTime:0.050897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679025 ORDER BY `unit` DESC [ RunTime:0.050973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679025 LIMIT 2 [ RunTime:0.040558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679025 ORDER BY `minOrder` ASC [ RunTime:0.094893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677972 LIMIT 5 [ RunTime:0.058791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677972 ORDER BY `minOrder` ASC [ RunTime:0.017485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677972 ORDER BY `unit` DESC [ RunTime:0.018468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677972 LIMIT 2 [ RunTime:0.016306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677972 ORDER BY `minOrder` ASC [ RunTime:0.024620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676760 LIMIT 5 [ RunTime:0.021179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676760 ORDER BY `minOrder` ASC [ RunTime:0.041417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676760 ORDER BY `unit` DESC [ RunTime:0.038566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676760 LIMIT 2 [ RunTime:0.039664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676760 ORDER BY `minOrder` ASC [ RunTime:0.017736s ]
select * from pdf where partno='1.5KE300AE3/TR13' and brandshort='Microsemi Corporation' limit 1 [ RunTime:0.009927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676276 LIMIT 5 [ RunTime:0.061903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676276 ORDER BY `minOrder` ASC [ RunTime:0.065859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676276 ORDER BY `unit` DESC [ RunTime:0.027580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676276 LIMIT 2 [ RunTime:0.092174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676276 ORDER BY `minOrder` ASC [ RunTime:0.020351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673316 LIMIT 5 [ RunTime:0.020915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673316 ORDER BY `minOrder` ASC [ RunTime:0.040236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673316 ORDER BY `unit` DESC [ RunTime:0.020424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673316 LIMIT 2 [ RunTime:0.017150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673316 ORDER BY `minOrder` ASC [ RunTime:0.010123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665190 LIMIT 5 [ RunTime:0.013136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665190 ORDER BY `minOrder` ASC [ RunTime:0.015685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665190 ORDER BY `unit` DESC [ RunTime:0.005851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665190 LIMIT 2 [ RunTime:0.037429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665190 ORDER BY `minOrder` ASC [ RunTime:0.019007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828289 LIMIT 5 [ RunTime:0.018656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828289 ORDER BY `minOrder` ASC [ RunTime:0.034448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828289 ORDER BY `unit` DESC [ RunTime:0.012120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828289 LIMIT 2 [ RunTime:0.010739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828289 ORDER BY `minOrder` ASC [ RunTime:0.004321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820136 LIMIT 5 [ RunTime:0.011613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820136 ORDER BY `minOrder` ASC [ RunTime:0.001968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820136 ORDER BY `unit` DESC [ RunTime:0.000581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820136 LIMIT 2 [ RunTime:0.007051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820136 ORDER BY `minOrder` ASC [ RunTime:0.002958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932016 LIMIT 5 [ RunTime:0.004183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932016 ORDER BY `minOrder` ASC [ RunTime:0.002915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932016 ORDER BY `unit` DESC [ RunTime:0.011407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932016 LIMIT 2 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932016 ORDER BY `minOrder` ASC [ RunTime:0.001942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930653 LIMIT 5 [ RunTime:0.003100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930653 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13930653 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13930653 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930653 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920426 LIMIT 5 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920426 ORDER BY `minOrder` ASC [ RunTime:0.002816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920426 ORDER BY `unit` DESC [ RunTime:0.005740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920426 LIMIT 2 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920426 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001469s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106770 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106770 ORDER BY `minOrder` ASC [ RunTime:0.001134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106770 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106770 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106770 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='1.5KE300A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000995s ]
SELECT `id` FROM `stock` WHERE `id` <> 42106770 AND `partno` = '1.5KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913248 [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153328 LIMIT 5 [ RunTime:0.008364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153328 ORDER BY `minOrder` ASC [ RunTime:0.003800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153328 ORDER BY `unit` DESC [ RunTime:0.001123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153328 LIMIT 2 [ RunTime:0.006265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153328 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='1.5KE300A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.001467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.005852s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153328 AND `partno` = '1.5KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.003733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662812 [ RunTime:0.011564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42120590 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120590 ORDER BY `minOrder` ASC [ RunTime:0.001803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42120590 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42120590 LIMIT 2 [ RunTime:0.001241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120590 ORDER BY `minOrder` ASC [ RunTime:0.005607s ]
select * from pdf where partno='1.5KE300A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002825s ]
SELECT `id` FROM `stock` WHERE `id` <> 42120590 AND `partno` = '1.5KE300A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919585 [ RunTime:0.000818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143450 LIMIT 5 [ RunTime:0.008233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143450 ORDER BY `minOrder` ASC [ RunTime:0.018740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143450 ORDER BY `unit` DESC [ RunTime:0.003189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143450 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143450 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='1.5KE300A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.015526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.006162s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143450 AND `partno` = '1.5KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.001287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661727 [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42157233 LIMIT 5 [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157233 ORDER BY `minOrder` ASC [ RunTime:0.005830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42157233 ORDER BY `unit` DESC [ RunTime:0.012905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42157233 LIMIT 2 [ RunTime:0.001898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157233 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
select * from pdf where partno='1.5KE300A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.001231s ]
select foldpath,foldpath2,filename from pdf_file where id=310456 limit 1 [ RunTime:0.000311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.012720s ]
SELECT `id` FROM `stock` WHERE `id` <> 42157233 AND `partno` = '1.5KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.021657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811 [ RunTime:0.024976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810741 [ RunTime:0.028640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169678 LIMIT 5 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169678 ORDER BY `minOrder` ASC [ RunTime:0.014903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169678 ORDER BY `unit` DESC [ RunTime:0.003456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169678 LIMIT 2 [ RunTime:0.012063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169678 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='1.5KE300A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.001981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.016718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297644 LIMIT 5 [ RunTime:0.003690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297644 ORDER BY `minOrder` ASC [ RunTime:0.030579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297644 ORDER BY `unit` DESC [ RunTime:0.007602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297644 LIMIT 2 [ RunTime:0.011958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297644 ORDER BY `minOrder` ASC [ RunTime:0.010487s ]
select * from pdf where partno='1.5KE300A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001303s ]
SELECT `id` FROM `stock` WHERE `id` <> 42297644 AND `partno` = '1.5KE300A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828289 [ RunTime:0.011436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42296610 LIMIT 5 [ RunTime:0.010951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296610 ORDER BY `minOrder` ASC [ RunTime:0.021790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42296610 ORDER BY `unit` DESC [ RunTime:0.015415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42296610 LIMIT 2 [ RunTime:0.010957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296610 ORDER BY `minOrder` ASC [ RunTime:0.002504s ]
select * from pdf where partno='1.5KE300A_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.005383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002453s ]
SELECT `id` FROM `stock` WHERE `id` <> 42296610 AND `partno` = '1.5KE300A_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.001094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820136 [ RunTime:0.008676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42291400 LIMIT 5 [ RunTime:0.003142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291400 ORDER BY `minOrder` ASC [ RunTime:0.028514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42291400 ORDER BY `unit` DESC [ RunTime:0.026902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42291400 LIMIT 2 [ RunTime:0.017275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291400 ORDER BY `minOrder` ASC [ RunTime:0.002745s ]
select * from pdf where partno='1.5KE300A-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.030251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.035393s ]
SELECT `id` FROM `stock` WHERE `id` <> 42291400 AND `partno` = '1.5KE300A-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.046641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920426 [ RunTime:0.012528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42291372 LIMIT 5 [ RunTime:0.007757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291372 ORDER BY `minOrder` ASC [ RunTime:0.005694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42291372 ORDER BY `unit` DESC [ RunTime:0.007226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42291372 LIMIT 2 [ RunTime:0.010619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291372 ORDER BY `minOrder` ASC [ RunTime:0.012881s ]
select * from pdf where partno='1.5KE300A-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.029193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.012178s ]
SELECT `id` FROM `stock` WHERE `id` <> 42291372 AND `partno` = '1.5KE300A-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.006135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677972 [ RunTime:0.018493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282574 LIMIT 5 [ RunTime:0.035808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282574 ORDER BY `minOrder` ASC [ RunTime:0.054767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282574 ORDER BY `unit` DESC [ RunTime:0.022254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282574 LIMIT 2 [ RunTime:0.041402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282574 ORDER BY `minOrder` ASC [ RunTime:0.016343s ]
select * from pdf where partno='1.5KE300A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.044057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.053563s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282574 AND `partno` = '1.5KE300A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.037418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676276 [ RunTime:0.010849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282435 LIMIT 5 [ RunTime:0.027591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282435 ORDER BY `minOrder` ASC [ RunTime:0.081311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282435 ORDER BY `unit` DESC [ RunTime:0.028528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282435 LIMIT 2 [ RunTime:0.032189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282435 ORDER BY `minOrder` ASC [ RunTime:0.025852s ]
select * from pdf where partno='1.5KE300AE3/TR13' and brandshort='Microsemi Corporation' limit 1 [ RunTime:0.013091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300AE3/TR13' OR `brand` LIKE 'Microsemi Corporation%' ) ) LIMIT 1 [ RunTime:0.032998s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282435 AND `partno` = '1.5KE300AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microsemi corporation%' ) [ RunTime:0.022325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676760 [ RunTime:0.141981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42276054 LIMIT 5 [ RunTime:0.094507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276054 ORDER BY `minOrder` ASC [ RunTime:0.048640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42276054 ORDER BY `unit` DESC [ RunTime:0.081744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42276054 LIMIT 2 [ RunTime:0.072162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276054 ORDER BY `minOrder` ASC [ RunTime:0.032469s ]
select * from pdf where partno='1.5KE300AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.075064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.025020s ]
SELECT `id` FROM `stock` WHERE `id` <> 42276054 AND `partno` = '1.5KE300AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.062260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918260 [ RunTime:0.109257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42276051 LIMIT 5 [ RunTime:0.050908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276051 ORDER BY `minOrder` ASC [ RunTime:0.054628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42276051 ORDER BY `unit` DESC [ RunTime:0.056845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42276051 LIMIT 2 [ RunTime:0.016271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276051 ORDER BY `minOrder` ASC [ RunTime:0.055879s ]
select * from pdf where partno='1.5KE300A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.040405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.058654s ]
SELECT `id` FROM `stock` WHERE `id` <> 42276051 AND `partno` = '1.5KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.080737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679025 [ RunTime:0.048005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42261740 LIMIT 5 [ RunTime:0.095413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261740 ORDER BY `minOrder` ASC [ RunTime:0.068633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42261740 ORDER BY `unit` DESC [ RunTime:0.062765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42261740 LIMIT 2 [ RunTime:0.139604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261740 ORDER BY `minOrder` ASC [ RunTime:0.019692s ]
select * from pdf where partno='1.5KE300A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.041932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.100437s ]
SELECT `id` FROM `stock` WHERE `id` <> 42261740 AND `partno` = '1.5KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.110948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917559 [ RunTime:0.091349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239650 LIMIT 5 [ RunTime:0.041870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239650 ORDER BY `minOrder` ASC [ RunTime:0.078993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239650 ORDER BY `unit` DESC [ RunTime:0.118324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239650 LIMIT 2 [ RunTime:0.110389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239650 ORDER BY `minOrder` ASC [ RunTime:0.017854s ]
select * from pdf where partno='1.5KE300A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.044612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.052886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239622 LIMIT 5 [ RunTime:0.072322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239622 ORDER BY `minOrder` ASC [ RunTime:0.103566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239622 ORDER BY `unit` DESC [ RunTime:0.119573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239622 LIMIT 2 [ RunTime:0.063875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239622 ORDER BY `minOrder` ASC [ RunTime:0.023877s ]
select * from pdf where partno='1.5KE300A-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.075645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.066557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225917 LIMIT 5 [ RunTime:0.057635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225917 ORDER BY `minOrder` ASC [ RunTime:0.155178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225917 ORDER BY `unit` DESC [ RunTime:0.092644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225917 LIMIT 2 [ RunTime:0.059396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225917 ORDER BY `minOrder` ASC [ RunTime:0.024829s ]
select * from pdf where partno='1.5KE300A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.090158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.016523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42177230 LIMIT 5 [ RunTime:0.025454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42177230 ORDER BY `minOrder` ASC [ RunTime:0.061573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42177230 ORDER BY `unit` DESC [ RunTime:0.051264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42177230 LIMIT 2 [ RunTime:0.097562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42177230 ORDER BY `minOrder` ASC [ RunTime:0.035031s ]
select * from pdf where partno='1.5KE300A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.080586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE300A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.049178s ]
SELECT `id` FROM `stock` WHERE `id` <> 42177230 AND `partno` = '1.5KE300A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.107872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802894 [ RunTime:0.078419s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.118261s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044685s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086010s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042512s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085332s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089309s ]
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.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076263s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5KE300A%' OR `brand` LIKE '1.5KE300A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.119170s ]