SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002565s ]
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.5smc43a&search=1' [ RunTime:0.007672s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002427s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002796s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.007385s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002390s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009203s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002673s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5smc43a' LIMIT 1 [ RunTime:0.011659s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-19 13:43:16' WHERE `partno` = '1.5smc43a' [ RunTime:0.023213s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002626s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018098s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669899 LIMIT 5 [ RunTime:0.024889s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669899 ORDER BY `minOrder` ASC [ RunTime:0.008608s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669899 ORDER BY `unit` DESC [ RunTime:0.007611s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669899 LIMIT 2 [ RunTime:0.009825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669899 ORDER BY `minOrder` ASC [ RunTime:0.001866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911922 LIMIT 5 [ RunTime:0.003883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911922 ORDER BY `minOrder` ASC [ RunTime:0.007024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911922 ORDER BY `unit` DESC [ RunTime:0.019745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911922 LIMIT 2 [ RunTime:0.020798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911922 ORDER BY `minOrder` ASC [ RunTime:0.012945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692949 LIMIT 5 [ RunTime:0.015722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692949 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692949 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692949 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692949 ORDER BY `minOrder` ASC [ RunTime:0.000199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803728 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803728 ORDER BY `minOrder` ASC [ RunTime:0.002555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803728 ORDER BY `unit` DESC [ RunTime:0.003732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803728 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803728 ORDER BY `minOrder` ASC [ RunTime:0.001654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803716 LIMIT 5 [ RunTime:0.002407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803716 ORDER BY `minOrder` ASC [ RunTime:0.003079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803716 ORDER BY `unit` DESC [ RunTime:0.027485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803716 LIMIT 2 [ RunTime:0.010238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803716 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908200 LIMIT 5 [ RunTime:0.015106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908200 ORDER BY `minOrder` ASC [ RunTime:0.017326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908200 ORDER BY `unit` DESC [ RunTime:0.021849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908200 LIMIT 2 [ RunTime:0.012201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908200 ORDER BY `minOrder` ASC [ RunTime:0.006804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692041 LIMIT 5 [ RunTime:0.005953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692041 ORDER BY `minOrder` ASC [ RunTime:0.004291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692041 ORDER BY `unit` DESC [ RunTime:0.015806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692041 LIMIT 2 [ RunTime:0.018866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692041 ORDER BY `minOrder` ASC [ RunTime:0.002989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675379 LIMIT 5 [ RunTime:0.011408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675379 ORDER BY `minOrder` ASC [ RunTime:0.029607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675379 ORDER BY `unit` DESC [ RunTime:0.013580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675379 LIMIT 2 [ RunTime:0.024080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675379 ORDER BY `minOrder` ASC [ RunTime:0.033178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675310 LIMIT 5 [ RunTime:0.033864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675310 ORDER BY `minOrder` ASC [ RunTime:0.034076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675310 ORDER BY `unit` DESC [ RunTime:0.037043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675310 LIMIT 2 [ RunTime:0.014284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675310 ORDER BY `minOrder` ASC [ RunTime:0.011031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675026 LIMIT 5 [ RunTime:0.004028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675026 ORDER BY `minOrder` ASC [ RunTime:0.018036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675026 ORDER BY `unit` DESC [ RunTime:0.018367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675026 LIMIT 2 [ RunTime:0.042109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675026 ORDER BY `minOrder` ASC [ RunTime:0.018931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674894 LIMIT 5 [ RunTime:0.006008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674894 ORDER BY `minOrder` ASC [ RunTime:0.007784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674894 ORDER BY `unit` DESC [ RunTime:0.014773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674894 LIMIT 2 [ RunTime:0.010188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674894 ORDER BY `minOrder` ASC [ RunTime:0.004101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674687 LIMIT 5 [ RunTime:0.019123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674687 ORDER BY `minOrder` ASC [ RunTime:0.001549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674687 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674687 LIMIT 2 [ RunTime:0.002696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674687 ORDER BY `minOrder` ASC [ RunTime:0.009614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672834 LIMIT 5 [ RunTime:0.027649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672834 ORDER BY `minOrder` ASC [ RunTime:0.010018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672834 ORDER BY `unit` DESC [ RunTime:0.004615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672834 LIMIT 2 [ RunTime:0.001657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672834 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670898 LIMIT 5 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670898 ORDER BY `minOrder` ASC [ RunTime:0.002759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670898 ORDER BY `unit` DESC [ RunTime:0.011605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670898 LIMIT 2 [ RunTime:0.005729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670898 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831549 LIMIT 5 [ RunTime:0.000916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831549 ORDER BY `minOrder` ASC [ RunTime:0.005346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831549 ORDER BY `unit` DESC [ RunTime:0.003026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831549 LIMIT 2 [ RunTime:0.007008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831549 ORDER BY `minOrder` ASC [ RunTime:0.006996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831548 LIMIT 5 [ RunTime:0.009540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831548 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831548 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831548 LIMIT 2 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831548 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828703 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828703 ORDER BY `minOrder` ASC [ RunTime:0.007865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828703 ORDER BY `unit` DESC [ RunTime:0.012403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828703 LIMIT 2 [ RunTime:0.004061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828703 ORDER BY `minOrder` ASC [ RunTime:0.001914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827327 LIMIT 5 [ RunTime:0.002460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827327 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827327 ORDER BY `unit` DESC [ RunTime:0.007826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827327 LIMIT 2 [ RunTime:0.006221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827327 ORDER BY `minOrder` ASC [ RunTime:0.003666s ]
select * from pdf where partno='1.5SMC43AT3' and brandshort='onsemi' limit 1 [ RunTime:0.001865s ]
select foldpath,foldpath2,filename from pdf_file where id=310499 limit 1 [ RunTime:0.010768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818658 LIMIT 5 [ RunTime:0.014869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818658 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818658 ORDER BY `unit` DESC [ RunTime:0.011417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818658 LIMIT 2 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818658 ORDER BY `minOrder` ASC [ RunTime:0.002151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815510 LIMIT 5 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815510 ORDER BY `minOrder` ASC [ RunTime:0.001651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815510 ORDER BY `unit` DESC [ RunTime:0.002623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815510 LIMIT 2 [ RunTime:0.011600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815510 ORDER BY `minOrder` ASC [ RunTime:0.007266s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141657 LIMIT 5 [ RunTime:0.031051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141657 ORDER BY `minOrder` ASC [ RunTime:0.004772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141657 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141657 LIMIT 2 [ RunTime:0.008053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141657 ORDER BY `minOrder` ASC [ RunTime:0.005988s ]
select * from pdf where partno='1.5smc43a' and brandshort='bourns' limit 1 [ RunTime:0.005584s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc43a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.012318s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104865 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104865 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104865 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104865 LIMIT 2 [ RunTime:0.013263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104865 ORDER BY `minOrder` ASC [ RunTime:0.006946s ]
select * from pdf where partno='1.5SMC43A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.005114s ]
SELECT `id` FROM `stock` WHERE `id` <> 42104865 AND `partno` = '1.5SMC43A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.014435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669899 [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105777 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105777 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105777 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105777 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105777 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
select * from pdf where partno='1.5SMC43A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000675s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105777 AND `partno` = '1.5SMC43A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911922 [ RunTime:0.006624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142616 LIMIT 5 [ RunTime:0.005499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142616 ORDER BY `minOrder` ASC [ RunTime:0.006020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142616 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142616 LIMIT 2 [ RunTime:0.001616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142616 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
select * from pdf where partno='1.5SMC43A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005998s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142616 AND `partno` = '1.5SMC43A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804637 [ RunTime:0.003599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142406 LIMIT 5 [ RunTime:0.003115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142406 ORDER BY `minOrder` ASC [ RunTime:0.008960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142406 ORDER BY `unit` DESC [ RunTime:0.000560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142406 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142406 ORDER BY `minOrder` ASC [ RunTime:0.001637s ]
select * from pdf where partno='1.5SMC43A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003409s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142406 AND `partno` = '1.5SMC43A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813988 [ RunTime:0.001345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174601 LIMIT 5 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174601 ORDER BY `minOrder` ASC [ RunTime:0.001329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174601 ORDER BY `unit` DESC [ RunTime:0.012589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174601 LIMIT 2 [ RunTime:0.006931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174601 ORDER BY `minOrder` ASC [ RunTime:0.001488s ]
select * from pdf where partno='1.5SMC43A-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000662s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174601 AND `partno` = '1.5SMC43A-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803728 [ RunTime:0.003295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174364 LIMIT 5 [ RunTime:0.009850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174364 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174364 ORDER BY `unit` DESC [ RunTime:0.002671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174364 LIMIT 2 [ RunTime:0.008637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174364 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
select * from pdf where partno='1.5SMC43A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.002192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.003771s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174364 AND `partno` = '1.5SMC43A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803716 [ RunTime:0.007827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174325 LIMIT 5 [ RunTime:0.008698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174325 ORDER BY `minOrder` ASC [ RunTime:0.006896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174325 ORDER BY `unit` DESC [ RunTime:0.000274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174325 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174325 ORDER BY `minOrder` ASC [ RunTime:0.001805s ]
select * from pdf where partno='1.5SMC43AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.004039s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174325 AND `partno` = '1.5SMC43AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.020159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908200 [ RunTime:0.009385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117921 LIMIT 5 [ RunTime:0.009406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117921 ORDER BY `minOrder` ASC [ RunTime:0.011890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117921 ORDER BY `unit` DESC [ RunTime:0.003139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117921 LIMIT 2 [ RunTime:0.005067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117921 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='1.5SMC43A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001772s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117921 AND `partno` = '1.5SMC43A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692949 [ RunTime:0.026501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42271630 LIMIT 5 [ RunTime:0.006636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271630 ORDER BY `minOrder` ASC [ RunTime:0.035961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42271630 ORDER BY `unit` DESC [ RunTime:0.022407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42271630 LIMIT 2 [ RunTime:0.008509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271630 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
select * from pdf where partno='1.5SMC43AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011667s ]
SELECT `id` FROM `stock` WHERE `id` <> 42271630 AND `partno` = '1.5SMC43AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815510 [ RunTime:0.008282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42271629 LIMIT 5 [ RunTime:0.004766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271629 ORDER BY `minOrder` ASC [ RunTime:0.000788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42271629 ORDER BY `unit` DESC [ RunTime:0.005580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42271629 LIMIT 2 [ RunTime:0.003032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271629 ORDER BY `minOrder` ASC [ RunTime:0.004993s ]
select * from pdf where partno='1.5SMC43AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT `id` FROM `stock` WHERE `id` <> 42271629 AND `partno` = '1.5SMC43AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675026 [ RunTime:0.006561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263640 LIMIT 5 [ RunTime:0.001671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263640 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263640 ORDER BY `unit` DESC [ RunTime:0.008458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263640 LIMIT 2 [ RunTime:0.003961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263640 ORDER BY `minOrder` ASC [ RunTime:0.003900s ]
select * from pdf where partno='1.5SMC43AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002772s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263640 AND `partno` = '1.5SMC43AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675379 [ RunTime:0.001504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262957 LIMIT 5 [ RunTime:0.002004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262957 ORDER BY `minOrder` ASC [ RunTime:0.005733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262957 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262957 LIMIT 2 [ RunTime:0.002119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262957 ORDER BY `minOrder` ASC [ RunTime:0.003339s ]
select * from pdf where partno='1.5SMC43A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.008938s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262957 AND `partno` = '1.5SMC43A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.006455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814106 [ RunTime:0.003010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262208 LIMIT 5 [ RunTime:0.002310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262208 ORDER BY `minOrder` ASC [ RunTime:0.001249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262208 ORDER BY `unit` DESC [ RunTime:0.007863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262208 LIMIT 2 [ RunTime:0.005923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262208 ORDER BY `minOrder` ASC [ RunTime:0.001676s ]
select * from pdf where partno='1.5SMC43A TR13 PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.001185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A TR13 PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.004780s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262208 AND `partno` = '1.5SMC43A TR13 PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.001763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674687 [ RunTime:0.001226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42261712 LIMIT 5 [ RunTime:0.007307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261712 ORDER BY `minOrder` ASC [ RunTime:0.007474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42261712 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42261712 LIMIT 2 [ RunTime:0.003230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261712 ORDER BY `minOrder` ASC [ RunTime:0.005401s ]
select * from pdf where partno='1.5SMC43AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007618s ]
SELECT `id` FROM `stock` WHERE `id` <> 42261712 AND `partno` = '1.5SMC43AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675310 [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257543 LIMIT 5 [ RunTime:0.014160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257543 ORDER BY `minOrder` ASC [ RunTime:0.006910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257543 ORDER BY `unit` DESC [ RunTime:0.015327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257543 LIMIT 2 [ RunTime:0.014668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257543 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='1.5SMC43A-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-M3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002332s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257543 AND `partno` = '1.5SMC43A-M3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674894 [ RunTime:0.003537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257517 LIMIT 5 [ RunTime:0.004207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257517 ORDER BY `minOrder` ASC [ RunTime:0.014734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257517 ORDER BY `unit` DESC [ RunTime:0.004398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257517 LIMIT 2 [ RunTime:0.002343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257517 ORDER BY `minOrder` ASC [ RunTime:0.002867s ]
select * from pdf where partno='1.5SMC43A-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-M3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003529s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257517 AND `partno` = '1.5SMC43A-M3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814979 [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246098 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246098 ORDER BY `minOrder` ASC [ RunTime:0.003246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246098 ORDER BY `unit` DESC [ RunTime:0.002159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246098 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246098 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
select * from pdf where partno='1.5SMC43AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000767s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246098 AND `partno` = '1.5SMC43AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813996 [ RunTime:0.001142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245935 LIMIT 5 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245935 ORDER BY `minOrder` ASC [ RunTime:0.000981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245935 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245935 LIMIT 2 [ RunTime:0.002249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245935 ORDER BY `minOrder` ASC [ RunTime:0.004944s ]
select * from pdf where partno='1.5SMC43A-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-E3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007209s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245935 AND `partno` = '1.5SMC43A-E3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916309 [ RunTime:0.005989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42243046 LIMIT 5 [ RunTime:0.003744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243046 ORDER BY `minOrder` ASC [ RunTime:0.002381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42243046 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42243046 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243046 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='1.5SMC43AT3G' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43AT3G' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000840s ]
SELECT `id` FROM `stock` WHERE `id` <> 42243046 AND `partno` = '1.5SMC43AT3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818658 [ RunTime:0.007026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227745 LIMIT 5 [ RunTime:0.010455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227745 ORDER BY `minOrder` ASC [ RunTime:0.002176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227745 ORDER BY `unit` DESC [ RunTime:0.000706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227745 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227745 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='1.5SMC43A-AT/7' and brandshort='YAGEO' limit 1 [ RunTime:0.001484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC43A-AT/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011615s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015131s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002227s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011925s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008356s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001639s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004060s ]
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.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001431s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5smc43a%' OR `brand` LIKE '1.5smc43a%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011941s ]