SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002666s ]
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=P6KE43C&search=1' [ RunTime:0.035798s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001253s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016280s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004641s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002472s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.022660s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002455s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6KE43C' LIMIT 1 [ RunTime:0.050261s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 00:24:05' WHERE `partno` = 'P6KE43C' [ RunTime:0.083977s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002507s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103531s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664352 LIMIT 5 [ RunTime:0.008710s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664352 ORDER BY `minOrder` ASC [ RunTime:0.029258s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664352 ORDER BY `unit` DESC [ RunTime:0.020717s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664352 LIMIT 2 [ RunTime:0.020386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664352 ORDER BY `minOrder` ASC [ RunTime:0.008683s ]
select * from pdf where partno='P6KE43CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663701 LIMIT 5 [ RunTime:0.015194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663701 ORDER BY `minOrder` ASC [ RunTime:0.005931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663701 ORDER BY `unit` DESC [ RunTime:0.010073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663701 LIMIT 2 [ RunTime:0.012815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663701 ORDER BY `minOrder` ASC [ RunTime:0.016651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662595 LIMIT 5 [ RunTime:0.020767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662595 ORDER BY `minOrder` ASC [ RunTime:0.003094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662595 ORDER BY `unit` DESC [ RunTime:0.005611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662595 LIMIT 2 [ RunTime:0.020926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662595 ORDER BY `minOrder` ASC [ RunTime:0.011507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904917 LIMIT 5 [ RunTime:0.016896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904917 ORDER BY `minOrder` ASC [ RunTime:0.010457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904917 ORDER BY `unit` DESC [ RunTime:0.031384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904917 LIMIT 2 [ RunTime:0.016690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904917 ORDER BY `minOrder` ASC [ RunTime:0.009190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688511 LIMIT 5 [ RunTime:0.006281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688511 ORDER BY `minOrder` ASC [ RunTime:0.015551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688511 ORDER BY `unit` DESC [ RunTime:0.022751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688511 LIMIT 2 [ RunTime:0.032711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688511 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827142 LIMIT 5 [ RunTime:0.005649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827142 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827142 ORDER BY `unit` DESC [ RunTime:0.010403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827142 LIMIT 2 [ RunTime:0.023204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827142 ORDER BY `minOrder` ASC [ RunTime:0.019752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661477 LIMIT 5 [ RunTime:0.021558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661477 ORDER BY `minOrder` ASC [ RunTime:0.008770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661477 ORDER BY `unit` DESC [ RunTime:0.010415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661477 LIMIT 2 [ RunTime:0.004600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661477 ORDER BY `minOrder` ASC [ RunTime:0.019563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661490 LIMIT 5 [ RunTime:0.014860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661490 ORDER BY `minOrder` ASC [ RunTime:0.016647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661490 ORDER BY `unit` DESC [ RunTime:0.016115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661490 LIMIT 2 [ RunTime:0.010504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661490 ORDER BY `minOrder` ASC [ RunTime:0.012035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691617 LIMIT 5 [ RunTime:0.016392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691617 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691617 ORDER BY `unit` DESC [ RunTime:0.006559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691617 LIMIT 2 [ RunTime:0.003603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691617 ORDER BY `minOrder` ASC [ RunTime:0.006030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688732 LIMIT 5 [ RunTime:0.008244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688732 ORDER BY `minOrder` ASC [ RunTime:0.012545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688732 ORDER BY `unit` DESC [ RunTime:0.010797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688732 LIMIT 2 [ RunTime:0.018036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688732 ORDER BY `minOrder` ASC [ RunTime:0.010535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688731 LIMIT 5 [ RunTime:0.009308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688731 ORDER BY `minOrder` ASC [ RunTime:0.005781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688731 ORDER BY `unit` DESC [ RunTime:0.002614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688731 LIMIT 2 [ RunTime:0.011776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688731 ORDER BY `minOrder` ASC [ RunTime:0.006850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688337 LIMIT 5 [ RunTime:0.001098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688337 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688337 ORDER BY `unit` DESC [ RunTime:0.001465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688337 LIMIT 2 [ RunTime:0.002165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688337 ORDER BY `minOrder` ASC [ RunTime:0.002267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687197 LIMIT 5 [ RunTime:0.010484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687197 ORDER BY `minOrder` ASC [ RunTime:0.018883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687197 ORDER BY `unit` DESC [ RunTime:0.022874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687197 LIMIT 2 [ RunTime:0.030114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687197 ORDER BY `minOrder` ASC [ RunTime:0.014255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687105 LIMIT 5 [ RunTime:0.019342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687105 ORDER BY `minOrder` ASC [ RunTime:0.024112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687105 ORDER BY `unit` DESC [ RunTime:0.034823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687105 LIMIT 2 [ RunTime:0.017083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687105 ORDER BY `minOrder` ASC [ RunTime:0.024516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670365 LIMIT 5 [ RunTime:0.010938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670365 ORDER BY `minOrder` ASC [ RunTime:0.071756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670365 ORDER BY `unit` DESC [ RunTime:0.020953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670365 LIMIT 2 [ RunTime:0.030450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670365 ORDER BY `minOrder` ASC [ RunTime:0.021894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668648 LIMIT 5 [ RunTime:0.022880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668648 ORDER BY `minOrder` ASC [ RunTime:0.020251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668648 ORDER BY `unit` DESC [ RunTime:0.044177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668648 LIMIT 2 [ RunTime:0.015440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668648 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831039 LIMIT 5 [ RunTime:0.023076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831039 ORDER BY `minOrder` ASC [ RunTime:0.018552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831039 ORDER BY `unit` DESC [ RunTime:0.015584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831039 LIMIT 2 [ RunTime:0.011121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831039 ORDER BY `minOrder` ASC [ RunTime:0.003766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828070 LIMIT 5 [ RunTime:0.015091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828070 ORDER BY `minOrder` ASC [ RunTime:0.025725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828070 ORDER BY `unit` DESC [ RunTime:0.022645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828070 LIMIT 2 [ RunTime:0.050524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828070 ORDER BY `minOrder` ASC [ RunTime:0.011141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818297 LIMIT 5 [ RunTime:0.040928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818297 ORDER BY `minOrder` ASC [ RunTime:0.010921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818297 ORDER BY `unit` DESC [ RunTime:0.024817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818297 LIMIT 2 [ RunTime:0.037965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818297 ORDER BY `minOrder` ASC [ RunTime:0.006583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814801 LIMIT 5 [ RunTime:0.005446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814801 ORDER BY `minOrder` ASC [ RunTime:0.006876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814801 ORDER BY `unit` DESC [ RunTime:0.020431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814801 LIMIT 2 [ RunTime:0.028237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814801 ORDER BY `minOrder` ASC [ RunTime:0.014221s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032220s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104277 LIMIT 5 [ RunTime:0.001339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104277 ORDER BY `minOrder` ASC [ RunTime:0.008511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104277 ORDER BY `unit` DESC [ RunTime:0.003286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104277 LIMIT 2 [ RunTime:0.015406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104277 ORDER BY `minOrder` ASC [ RunTime:0.007631s ]
select * from pdf where partno='P6KE43CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.014840s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 42104277 AND `partno` = 'P6KE43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.011169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664352 [ RunTime:0.013807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162728 LIMIT 5 [ RunTime:0.013903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162728 ORDER BY `minOrder` ASC [ RunTime:0.010886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162728 ORDER BY `unit` DESC [ RunTime:0.009218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162728 LIMIT 2 [ RunTime:0.019614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162728 ORDER BY `minOrder` ASC [ RunTime:0.015406s ]
select * from pdf where partno='P6KE43CA' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.012372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.019965s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162728 AND `partno` = 'P6KE43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.014417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663701 [ RunTime:0.036076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150465 LIMIT 5 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150465 ORDER BY `minOrder` ASC [ RunTime:0.063872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150465 ORDER BY `unit` DESC [ RunTime:0.019465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150465 LIMIT 2 [ RunTime:0.026772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150465 ORDER BY `minOrder` ASC [ RunTime:0.008139s ]
select * from pdf where partno='P6KE43CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.026666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009107s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150465 AND `partno` = 'P6KE43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.011059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662595 [ RunTime:0.010318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42140648 LIMIT 5 [ RunTime:0.008906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140648 ORDER BY `minOrder` ASC [ RunTime:0.003728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42140648 ORDER BY `unit` DESC [ RunTime:0.004600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42140648 LIMIT 2 [ RunTime:0.025963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140648 ORDER BY `minOrder` ASC [ RunTime:0.010565s ]
select * from pdf where partno='P6KE43CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.030938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.008827s ]
SELECT `id` FROM `stock` WHERE `id` <> 42140648 AND `partno` = 'P6KE43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.009952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904917 [ RunTime:0.003760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118297 LIMIT 5 [ RunTime:0.001980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118297 ORDER BY `minOrder` ASC [ RunTime:0.010460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118297 ORDER BY `unit` DESC [ RunTime:0.016557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118297 LIMIT 2 [ RunTime:0.019144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118297 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='P6KE43CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.010383s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118297 AND `partno` = 'P6KE43CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.018817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688511 [ RunTime:0.016815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128547 LIMIT 5 [ RunTime:0.011921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128547 ORDER BY `minOrder` ASC [ RunTime:0.022151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128547 ORDER BY `unit` DESC [ RunTime:0.006560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128547 LIMIT 2 [ RunTime:0.001903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128547 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='P6KE43CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000657s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128547 AND `partno` = 'P6KE43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661477 [ RunTime:0.012836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42125363 LIMIT 5 [ RunTime:0.009062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125363 ORDER BY `minOrder` ASC [ RunTime:0.015181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42125363 ORDER BY `unit` DESC [ RunTime:0.020372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42125363 LIMIT 2 [ RunTime:0.022654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125363 ORDER BY `minOrder` ASC [ RunTime:0.040894s ]
select * from pdf where partno='P6KE43CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.005654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.001361s ]
SELECT `id` FROM `stock` WHERE `id` <> 42125363 AND `partno` = 'P6KE43CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.011564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827142 [ RunTime:0.010038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123004 LIMIT 5 [ RunTime:0.015420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123004 ORDER BY `minOrder` ASC [ RunTime:0.010802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123004 ORDER BY `unit` DESC [ RunTime:0.024759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123004 LIMIT 2 [ RunTime:0.002994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123004 ORDER BY `minOrder` ASC [ RunTime:0.010562s ]
select * from pdf where partno='P6KE43CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.010224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282640 LIMIT 5 [ RunTime:0.019357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282640 ORDER BY `minOrder` ASC [ RunTime:0.017241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282640 ORDER BY `unit` DESC [ RunTime:0.004368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282640 LIMIT 2 [ RunTime:0.010313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282640 ORDER BY `minOrder` ASC [ RunTime:0.015252s ]
select * from pdf where partno='P6KE43CAHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CAHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030045s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282640 AND `partno` = 'P6KE43CAHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814801 [ RunTime:0.006638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282620 LIMIT 5 [ RunTime:0.011101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282620 ORDER BY `minOrder` ASC [ RunTime:0.006296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282620 ORDER BY `unit` DESC [ RunTime:0.005878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282620 LIMIT 2 [ RunTime:0.006780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282620 ORDER BY `minOrder` ASC [ RunTime:0.006206s ]
select * from pdf where partno='P6KE43CAHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CAHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.022358s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282620 AND `partno` = 'P6KE43CAHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42280883 LIMIT 5 [ RunTime:0.005384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280883 ORDER BY `minOrder` ASC [ RunTime:0.004014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42280883 ORDER BY `unit` DESC [ RunTime:0.002036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42280883 LIMIT 2 [ RunTime:0.009420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280883 ORDER BY `minOrder` ASC [ RunTime:0.004482s ]
select * from pdf where partno='P6KE43CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.020734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006761s ]
SELECT `id` FROM `stock` WHERE `id` <> 42280883 AND `partno` = 'P6KE43CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.020881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42241106 LIMIT 5 [ RunTime:0.009183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241106 ORDER BY `minOrder` ASC [ RunTime:0.015654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42241106 ORDER BY `unit` DESC [ RunTime:0.011455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42241106 LIMIT 2 [ RunTime:0.012022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241106 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
select * from pdf where partno='P6KE43CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.012188s ]
SELECT `id` FROM `stock` WHERE `id` <> 42241106 AND `partno` = 'P6KE43CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812026 [ RunTime:0.005204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42233758 LIMIT 5 [ RunTime:0.027018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233758 ORDER BY `minOrder` ASC [ RunTime:0.012391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42233758 ORDER BY `unit` DESC [ RunTime:0.017519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42233758 LIMIT 2 [ RunTime:0.017795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233758 ORDER BY `minOrder` ASC [ RunTime:0.003644s ]
select * from pdf where partno='P6KE43CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.020666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.012253s ]
SELECT `id` FROM `stock` WHERE `id` <> 42233758 AND `partno` = 'P6KE43CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.005470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914946 [ RunTime:0.072837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42233753 LIMIT 5 [ RunTime:0.015989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233753 ORDER BY `minOrder` ASC [ RunTime:0.018094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42233753 ORDER BY `unit` DESC [ RunTime:0.038807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42233753 LIMIT 2 [ RunTime:0.040078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233753 ORDER BY `minOrder` ASC [ RunTime:0.009347s ]
select * from pdf where partno='P6KE43CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.023613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.016037s ]
SELECT `id` FROM `stock` WHERE `id` <> 42233753 AND `partno` = 'P6KE43CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.004811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811958 [ RunTime:0.027688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222348 LIMIT 5 [ RunTime:0.012857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222348 ORDER BY `minOrder` ASC [ RunTime:0.012563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222348 ORDER BY `unit` DESC [ RunTime:0.003762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222348 LIMIT 2 [ RunTime:0.002021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222348 ORDER BY `minOrder` ASC [ RunTime:0.010130s ]
select * from pdf where partno='P6KE43CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.029364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.015755s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222348 AND `partno` = 'P6KE43CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.013223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913187 [ RunTime:0.032652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222278 LIMIT 5 [ RunTime:0.005641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222278 ORDER BY `minOrder` ASC [ RunTime:0.013778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222278 ORDER BY `unit` DESC [ RunTime:0.016051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222278 LIMIT 2 [ RunTime:0.015570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222278 ORDER BY `minOrder` ASC [ RunTime:0.026337s ]
select * from pdf where partno='P6KE43C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.029964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.030229s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222278 AND `partno` = 'P6KE43C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.028420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810442 [ RunTime:0.029204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222240 LIMIT 5 [ RunTime:0.026969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222240 ORDER BY `minOrder` ASC [ RunTime:0.024947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222240 ORDER BY `unit` DESC [ RunTime:0.022098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222240 LIMIT 2 [ RunTime:0.052539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222240 ORDER BY `minOrder` ASC [ RunTime:0.019641s ]
select * from pdf where partno='P6KE43CH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.039529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.006765s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222240 AND `partno` = 'P6KE43CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.028349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670365 [ RunTime:0.016645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42209405 LIMIT 5 [ RunTime:0.014157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209405 ORDER BY `minOrder` ASC [ RunTime:0.020287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42209405 ORDER BY `unit` DESC [ RunTime:0.009995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42209405 LIMIT 2 [ RunTime:0.009147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209405 ORDER BY `minOrder` ASC [ RunTime:0.005494s ]
select * from pdf where partno='P6KE43CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.025268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.011409s ]
SELECT `id` FROM `stock` WHERE `id` <> 42209405 AND `partno` = 'P6KE43CA-BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.014985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911779 [ RunTime:0.032127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42208539 LIMIT 5 [ RunTime:0.013582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42208539 ORDER BY `minOrder` ASC [ RunTime:0.021370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42208539 ORDER BY `unit` DESC [ RunTime:0.011356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42208539 LIMIT 2 [ RunTime:0.010176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42208539 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
select * from pdf where partno='P6KE43CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.007726s ]
SELECT `id` FROM `stock` WHERE `id` <> 42208539 AND `partno` = 'P6KE43CA-AP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.010466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911706 [ RunTime:0.013103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42207004 LIMIT 5 [ RunTime:0.016250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207004 ORDER BY `minOrder` ASC [ RunTime:0.004765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42207004 ORDER BY `unit` DESC [ RunTime:0.005699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42207004 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207004 ORDER BY `minOrder` ASC [ RunTime:0.001616s ]
select * from pdf where partno='P6KE43CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.025861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE43CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.006063s ]
SELECT `id` FROM `stock` WHERE `id` <> 42207004 AND `partno` = 'P6KE43CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.007848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818297 [ RunTime:0.003451s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003330s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002621s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009962s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013884s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001445s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005182s ]
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 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011126s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6KE43C%' OR `brand` LIKE 'P6KE43C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006086s ]