SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001716s ]
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=1.5KE62C&search=1' [ RunTime:0.007173s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001621s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000857s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001916s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.002937s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001447s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005397s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001376s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5KE62C' LIMIT 1 [ RunTime:0.008641s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-17 01:57:21' WHERE `partno` = '1.5KE62C' [ RunTime:0.011897s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002713s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025260s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680099 LIMIT 5 [ RunTime:0.043185s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680099 ORDER BY `minOrder` ASC [ RunTime:0.017746s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680099 ORDER BY `unit` DESC [ RunTime:0.038563s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680099 LIMIT 2 [ RunTime:0.022646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680099 ORDER BY `minOrder` ASC [ RunTime:0.016061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922232 LIMIT 5 [ RunTime:0.024669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922232 ORDER BY `minOrder` ASC [ RunTime:0.030992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922232 ORDER BY `unit` DESC [ RunTime:0.031650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922232 LIMIT 2 [ RunTime:0.027229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922232 ORDER BY `minOrder` ASC [ RunTime:0.009786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669533 LIMIT 5 [ RunTime:0.009682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669533 ORDER BY `minOrder` ASC [ RunTime:0.012545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669533 ORDER BY `unit` DESC [ RunTime:0.014438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669533 LIMIT 2 [ RunTime:0.031566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669533 ORDER BY `minOrder` ASC [ RunTime:0.032557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690764 LIMIT 5 [ RunTime:0.026717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690764 ORDER BY `minOrder` ASC [ RunTime:0.020471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690764 ORDER BY `unit` DESC [ RunTime:0.015610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690764 LIMIT 2 [ RunTime:0.021217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690764 ORDER BY `minOrder` ASC [ RunTime:0.019611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690678 LIMIT 5 [ RunTime:0.007782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690678 ORDER BY `minOrder` ASC [ RunTime:0.006573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690678 ORDER BY `unit` DESC [ RunTime:0.016799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690678 LIMIT 2 [ RunTime:0.018018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690678 ORDER BY `minOrder` ASC [ RunTime:0.006032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688150 LIMIT 5 [ RunTime:0.020945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688150 ORDER BY `minOrder` ASC [ RunTime:0.012865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688150 ORDER BY `unit` DESC [ RunTime:0.022440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688150 LIMIT 2 [ RunTime:0.034299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688150 ORDER BY `minOrder` ASC [ RunTime:0.007477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688149 LIMIT 5 [ RunTime:0.002926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688149 ORDER BY `minOrder` ASC [ RunTime:0.007558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688149 ORDER BY `unit` DESC [ RunTime:0.009647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688149 LIMIT 2 [ RunTime:0.008700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688149 ORDER BY `minOrder` ASC [ RunTime:0.014012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687516 LIMIT 5 [ RunTime:0.005773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687516 ORDER BY `minOrder` ASC [ RunTime:0.008819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687516 ORDER BY `unit` DESC [ RunTime:0.012820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687516 LIMIT 2 [ RunTime:0.014590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687516 ORDER BY `minOrder` ASC [ RunTime:0.003725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687039 LIMIT 5 [ RunTime:0.003382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687039 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687039 ORDER BY `unit` DESC [ RunTime:0.002209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687039 LIMIT 2 [ RunTime:0.007894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687039 ORDER BY `minOrder` ASC [ RunTime:0.012844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676447 LIMIT 5 [ RunTime:0.003981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676447 ORDER BY `minOrder` ASC [ RunTime:0.014719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676447 ORDER BY `unit` DESC [ RunTime:0.006565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676447 LIMIT 2 [ RunTime:0.008427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676447 ORDER BY `minOrder` ASC [ RunTime:0.003096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674426 LIMIT 5 [ RunTime:0.003333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674426 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674426 ORDER BY `unit` DESC [ RunTime:0.001251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674426 LIMIT 2 [ RunTime:0.005587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674426 ORDER BY `minOrder` ASC [ RunTime:0.001223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674354 LIMIT 5 [ RunTime:0.000995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674354 ORDER BY `minOrder` ASC [ RunTime:0.015377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674354 ORDER BY `unit` DESC [ RunTime:0.019021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674354 LIMIT 2 [ RunTime:0.007430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674354 ORDER BY `minOrder` ASC [ RunTime:0.008437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673588 LIMIT 5 [ RunTime:0.001146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673588 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673588 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673588 LIMIT 2 [ RunTime:0.001926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673588 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671352 LIMIT 5 [ RunTime:0.016799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671352 ORDER BY `minOrder` ASC [ RunTime:0.003161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671352 ORDER BY `unit` DESC [ RunTime:0.008769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671352 LIMIT 2 [ RunTime:0.006239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671352 ORDER BY `minOrder` ASC [ RunTime:0.007713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670080 LIMIT 5 [ RunTime:0.004404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670080 ORDER BY `minOrder` ASC [ RunTime:0.009709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670080 ORDER BY `unit` DESC [ RunTime:0.004728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670080 LIMIT 2 [ RunTime:0.004167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670080 ORDER BY `minOrder` ASC [ RunTime:0.001876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665237 LIMIT 5 [ RunTime:0.002571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665237 ORDER BY `minOrder` ASC [ RunTime:0.002231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665237 ORDER BY `unit` DESC [ RunTime:0.004704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665237 LIMIT 2 [ RunTime:0.002253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665237 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831156 LIMIT 5 [ RunTime:0.004074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831156 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831156 ORDER BY `unit` DESC [ RunTime:0.003209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831156 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831156 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828054 LIMIT 5 [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828054 ORDER BY `minOrder` ASC [ RunTime:0.002106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828054 ORDER BY `unit` DESC [ RunTime:0.002046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828054 LIMIT 2 [ RunTime:0.002219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828054 ORDER BY `minOrder` ASC [ RunTime:0.003160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819648 LIMIT 5 [ RunTime:0.000963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819648 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819648 ORDER BY `unit` DESC [ RunTime:0.006887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819648 LIMIT 2 [ RunTime:0.003444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819648 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817431 LIMIT 5 [ RunTime:0.002348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817431 ORDER BY `minOrder` ASC [ RunTime:0.001127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817431 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817431 LIMIT 2 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817431 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001480s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42133874 LIMIT 5 [ RunTime:0.027213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133874 ORDER BY `minOrder` ASC [ RunTime:0.018511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42133874 ORDER BY `unit` DESC [ RunTime:0.002003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42133874 LIMIT 2 [ RunTime:0.013288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133874 ORDER BY `minOrder` ASC [ RunTime:0.003945s ]
select * from pdf where partno='1.5KE62CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007767s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.006741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001123s ]
SELECT `id` FROM `stock` WHERE `id` <> 42133874 AND `partno` = '1.5KE62CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680099 [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156577 LIMIT 5 [ RunTime:0.009881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156577 ORDER BY `minOrder` ASC [ RunTime:0.023855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156577 ORDER BY `unit` DESC [ RunTime:0.010710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156577 LIMIT 2 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156577 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
select * from pdf where partno='1.5KE62CA' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.010661s ]
select foldpath,foldpath2,filename from pdf_file where id=310456 limit 1 [ RunTime:0.004308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.017456s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156577 AND `partno` = '1.5KE62CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.005782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922232 [ RunTime:0.003041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169439 LIMIT 5 [ RunTime:0.017122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169439 ORDER BY `minOrder` ASC [ RunTime:0.023303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169439 ORDER BY `unit` DESC [ RunTime:0.011007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169439 LIMIT 2 [ RunTime:0.009836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169439 ORDER BY `minOrder` ASC [ RunTime:0.004181s ]
select * from pdf where partno='1.5KE62CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.004131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105813 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105813 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105813 ORDER BY `unit` DESC [ RunTime:0.000924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105813 LIMIT 2 [ RunTime:0.013006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105813 ORDER BY `minOrder` ASC [ RunTime:0.003756s ]
select * from pdf where partno='1.5KE62CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.010761s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105813 AND `partno` = '1.5KE62CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.037031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669533 [ RunTime:0.025636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295678 LIMIT 5 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295678 ORDER BY `minOrder` ASC [ RunTime:0.019527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295678 ORDER BY `unit` DESC [ RunTime:0.002164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295678 LIMIT 2 [ RunTime:0.004393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295678 ORDER BY `minOrder` ASC [ RunTime:0.023912s ]
select * from pdf where partno='1.5KE62CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.017138s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295678 AND `partno` = '1.5KE62CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.011260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819648 [ RunTime:0.005961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42294196 LIMIT 5 [ RunTime:0.031915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294196 ORDER BY `minOrder` ASC [ RunTime:0.040810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42294196 ORDER BY `unit` DESC [ RunTime:0.054887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42294196 LIMIT 2 [ RunTime:0.018910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294196 ORDER BY `minOrder` ASC [ RunTime:0.004655s ]
select * from pdf where partno='1.5KE62CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030032s ]
SELECT `id` FROM `stock` WHERE `id` <> 42294196 AND `partno` = '1.5KE62CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42294176 LIMIT 5 [ RunTime:0.026434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294176 ORDER BY `minOrder` ASC [ RunTime:0.007688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42294176 ORDER BY `unit` DESC [ RunTime:0.030108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42294176 LIMIT 2 [ RunTime:0.015389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294176 ORDER BY `minOrder` ASC [ RunTime:0.006129s ]
select * from pdf where partno='1.5KE62CAHE3_B/C' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CAHE3_B/C' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008339s ]
SELECT `id` FROM `stock` WHERE `id` <> 42294176 AND `partno` = '1.5KE62CAHE3_B/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817431 [ RunTime:0.013544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279349 LIMIT 5 [ RunTime:0.013798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279349 ORDER BY `minOrder` ASC [ RunTime:0.010302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279349 ORDER BY `unit` DESC [ RunTime:0.054065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279349 LIMIT 2 [ RunTime:0.019544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279349 ORDER BY `minOrder` ASC [ RunTime:0.008721s ]
select * from pdf where partno='1.5KE62CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.006870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.005372s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279349 AND `partno` = '1.5KE62CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.015430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676447 [ RunTime:0.006744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279314 LIMIT 5 [ RunTime:0.031847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279314 ORDER BY `minOrder` ASC [ RunTime:0.011574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279314 ORDER BY `unit` DESC [ RunTime:0.009227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279314 LIMIT 2 [ RunTime:0.010551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279314 ORDER BY `minOrder` ASC [ RunTime:0.007088s ]
select * from pdf where partno='1.5KE62CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.010001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.010560s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279314 AND `partno` = '1.5KE62CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.014379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919100 [ RunTime:0.024207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42272233 LIMIT 5 [ RunTime:0.002498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272233 ORDER BY `minOrder` ASC [ RunTime:0.006274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42272233 ORDER BY `unit` DESC [ RunTime:0.006958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42272233 LIMIT 2 [ RunTime:0.002300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272233 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='1.5KE62CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.011013s ]
SELECT `id` FROM `stock` WHERE `id` <> 42272233 AND `partno` = '1.5KE62CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.012843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815344 [ RunTime:0.005949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262885 LIMIT 5 [ RunTime:0.023650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262885 ORDER BY `minOrder` ASC [ RunTime:0.016050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262885 ORDER BY `unit` DESC [ RunTime:0.002428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262885 LIMIT 2 [ RunTime:0.004907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262885 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='1.5KE62CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.015615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.024466s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262885 AND `partno` = '1.5KE62CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.018366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674354 [ RunTime:0.008941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262728 LIMIT 5 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262728 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262728 ORDER BY `unit` DESC [ RunTime:0.005697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262728 LIMIT 2 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262728 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='1.5KE62C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.008833s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262728 AND `partno` = '1.5KE62C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.012507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674426 [ RunTime:0.007762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262691 LIMIT 5 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262691 ORDER BY `minOrder` ASC [ RunTime:0.004077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262691 ORDER BY `unit` DESC [ RunTime:0.002310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262691 LIMIT 2 [ RunTime:0.019560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262691 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
select * from pdf where partno='1.5KE62CH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002491s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262691 AND `partno` = '1.5KE62CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814763 [ RunTime:0.011935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262258 LIMIT 5 [ RunTime:0.011567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262258 ORDER BY `minOrder` ASC [ RunTime:0.016327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262258 ORDER BY `unit` DESC [ RunTime:0.004152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262258 LIMIT 2 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262258 ORDER BY `minOrder` ASC [ RunTime:0.003073s ]
select * from pdf where partno='1.5KE62CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003127s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262258 AND `partno` = '1.5KE62CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.007533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814713 [ RunTime:0.015808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42261066 LIMIT 5 [ RunTime:0.007496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261066 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42261066 ORDER BY `unit` DESC [ RunTime:0.016127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42261066 LIMIT 2 [ RunTime:0.019211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261066 ORDER BY `minOrder` ASC [ RunTime:0.002059s ]
select * from pdf where partno='1.5KE62CAE3/TR13' and brandshort='Microsemi Corporation' limit 1 [ RunTime:0.001793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CAE3/TR13' OR `brand` LIKE 'Microsemi Corporation%' ) ) LIMIT 1 [ RunTime:0.003590s ]
SELECT `id` FROM `stock` WHERE `id` <> 42261066 AND `partno` = '1.5KE62CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microsemi corporation%' ) [ RunTime:0.018727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815010 [ RunTime:0.018729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245897 LIMIT 5 [ RunTime:0.019044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245897 ORDER BY `minOrder` ASC [ RunTime:0.011973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245897 ORDER BY `unit` DESC [ RunTime:0.008738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245897 LIMIT 2 [ RunTime:0.046847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245897 ORDER BY `minOrder` ASC [ RunTime:0.022887s ]
select * from pdf where partno='1.5KE62CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.024410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.013185s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245897 AND `partno` = '1.5KE62CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.017516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673588 [ RunTime:0.010327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239944 LIMIT 5 [ RunTime:0.017679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239944 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239944 ORDER BY `unit` DESC [ RunTime:0.017820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239944 LIMIT 2 [ RunTime:0.013537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239944 ORDER BY `minOrder` ASC [ RunTime:0.006965s ]
select * from pdf where partno='1.5KE62CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.005255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.039413s ]
SELECT `id` FROM `stock` WHERE `id` <> 42239944 AND `partno` = '1.5KE62CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.013715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916632 [ RunTime:0.008773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42238571 LIMIT 5 [ RunTime:0.000977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238571 ORDER BY `minOrder` ASC [ RunTime:0.034626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42238571 ORDER BY `unit` DESC [ RunTime:0.012256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42238571 LIMIT 2 [ RunTime:0.004884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238571 ORDER BY `minOrder` ASC [ RunTime:0.008388s ]
select * from pdf where partno='1.5KE62CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.011057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.015612s ]
SELECT `id` FROM `stock` WHERE `id` <> 42238571 AND `partno` = '1.5KE62CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.019075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915565 [ RunTime:0.025617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42223790 LIMIT 5 [ RunTime:0.008766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223790 ORDER BY `minOrder` ASC [ RunTime:0.022865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42223790 ORDER BY `unit` DESC [ RunTime:0.032831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42223790 LIMIT 2 [ RunTime:0.009076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223790 ORDER BY `minOrder` ASC [ RunTime:0.011433s ]
select * from pdf where partno='1.5KE62CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.024298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42223354 LIMIT 5 [ RunTime:0.026076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223354 ORDER BY `minOrder` ASC [ RunTime:0.056123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42223354 ORDER BY `unit` DESC [ RunTime:0.031809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42223354 LIMIT 2 [ RunTime:0.020206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223354 ORDER BY `minOrder` ASC [ RunTime:0.021433s ]
select * from pdf where partno='1.5KE62CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.013541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE62CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.035403s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050821s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062378s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023423s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041995s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039294s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094721s ]
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.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.088651s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5KE62C%' OR `brand` LIKE '1.5KE62C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.073136s ]