SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004171s ]
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=KTR10EZPJ&search=1' [ RunTime:0.010113s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002240s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008199s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002562s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.008492s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002205s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.018474s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001432s ]
SELECT * FROM `stock_search` WHERE `partno` = 'KTR10EZPJ' LIMIT 1 [ RunTime:0.021807s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-20 03:46:23' WHERE `partno` = 'KTR10EZPJ' [ RunTime:0.010718s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002320s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051693s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15723448 LIMIT 5 [ RunTime:0.020775s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15723448 ORDER BY `minOrder` ASC [ RunTime:0.018654s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15723448 ORDER BY `unit` DESC [ RunTime:0.013431s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15723448 LIMIT 2 [ RunTime:0.013064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15723448 ORDER BY `minOrder` ASC [ RunTime:0.013094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15055575 LIMIT 5 [ RunTime:0.010354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15055575 ORDER BY `minOrder` ASC [ RunTime:0.021198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15055575 ORDER BY `unit` DESC [ RunTime:0.015102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15055575 LIMIT 2 [ RunTime:0.007927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15055575 ORDER BY `minOrder` ASC [ RunTime:0.015984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18005062 LIMIT 5 [ RunTime:0.022487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18005062 ORDER BY `minOrder` ASC [ RunTime:0.017777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18005062 ORDER BY `unit` DESC [ RunTime:0.031804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18005062 LIMIT 2 [ RunTime:0.007004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18005062 ORDER BY `minOrder` ASC [ RunTime:0.006447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16849800 LIMIT 5 [ RunTime:0.012368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16849800 ORDER BY `minOrder` ASC [ RunTime:0.013387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16849800 ORDER BY `unit` DESC [ RunTime:0.004510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16849800 LIMIT 2 [ RunTime:0.024402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16849800 ORDER BY `minOrder` ASC [ RunTime:0.010508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233762 LIMIT 5 [ RunTime:0.013792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233762 ORDER BY `minOrder` ASC [ RunTime:0.008775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18233762 ORDER BY `unit` DESC [ RunTime:0.004771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18233762 LIMIT 2 [ RunTime:0.028132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233762 ORDER BY `minOrder` ASC [ RunTime:0.003835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15763150 LIMIT 5 [ RunTime:0.003456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15763150 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15763150 ORDER BY `unit` DESC [ RunTime:0.003384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15763150 LIMIT 2 [ RunTime:0.009990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15763150 ORDER BY `minOrder` ASC [ RunTime:0.002436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233775 LIMIT 5 [ RunTime:0.019522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233775 ORDER BY `minOrder` ASC [ RunTime:0.015759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18233775 ORDER BY `unit` DESC [ RunTime:0.032678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18233775 LIMIT 2 [ RunTime:0.030521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233775 ORDER BY `minOrder` ASC [ RunTime:0.018707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16872648 LIMIT 5 [ RunTime:0.011232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16872648 ORDER BY `minOrder` ASC [ RunTime:0.011016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16872648 ORDER BY `unit` DESC [ RunTime:0.006145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16872648 LIMIT 2 [ RunTime:0.012661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16872648 ORDER BY `minOrder` ASC [ RunTime:0.007738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351935 LIMIT 5 [ RunTime:0.019385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351935 ORDER BY `minOrder` ASC [ RunTime:0.016278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351935 ORDER BY `unit` DESC [ RunTime:0.008613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351935 LIMIT 2 [ RunTime:0.012134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351935 ORDER BY `minOrder` ASC [ RunTime:0.002845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351934 LIMIT 5 [ RunTime:0.012946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351934 ORDER BY `minOrder` ASC [ RunTime:0.008083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351934 ORDER BY `unit` DESC [ RunTime:0.006444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351934 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351934 ORDER BY `minOrder` ASC [ RunTime:0.002328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351933 LIMIT 5 [ RunTime:0.008774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351933 ORDER BY `minOrder` ASC [ RunTime:0.005411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351933 ORDER BY `unit` DESC [ RunTime:0.008172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351933 LIMIT 2 [ RunTime:0.013625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351933 ORDER BY `minOrder` ASC [ RunTime:0.006002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351929 LIMIT 5 [ RunTime:0.022780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351929 ORDER BY `minOrder` ASC [ RunTime:0.014613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351929 ORDER BY `unit` DESC [ RunTime:0.049863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351929 LIMIT 2 [ RunTime:0.013924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351929 ORDER BY `minOrder` ASC [ RunTime:0.010652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18234244 LIMIT 5 [ RunTime:0.011539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18234244 ORDER BY `minOrder` ASC [ RunTime:0.006054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18234244 ORDER BY `unit` DESC [ RunTime:0.023329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18234244 LIMIT 2 [ RunTime:0.028846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18234244 ORDER BY `minOrder` ASC [ RunTime:0.028717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17964528 LIMIT 5 [ RunTime:0.017073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17964528 ORDER BY `minOrder` ASC [ RunTime:0.034853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17964528 ORDER BY `unit` DESC [ RunTime:0.030738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17964528 LIMIT 2 [ RunTime:0.032234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17964528 ORDER BY `minOrder` ASC [ RunTime:0.030020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879069 LIMIT 5 [ RunTime:0.038330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879069 ORDER BY `minOrder` ASC [ RunTime:0.031607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15879069 ORDER BY `unit` DESC [ RunTime:0.027283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15879069 LIMIT 2 [ RunTime:0.026094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879069 ORDER BY `minOrder` ASC [ RunTime:0.004618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879068 LIMIT 5 [ RunTime:0.028228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879068 ORDER BY `minOrder` ASC [ RunTime:0.052169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15879068 ORDER BY `unit` DESC [ RunTime:0.018068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15879068 LIMIT 2 [ RunTime:0.035454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879068 ORDER BY `minOrder` ASC [ RunTime:0.051870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879067 LIMIT 5 [ RunTime:0.070098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879067 ORDER BY `minOrder` ASC [ RunTime:0.081762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15879067 ORDER BY `unit` DESC [ RunTime:0.081982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15879067 LIMIT 2 [ RunTime:0.032804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879067 ORDER BY `minOrder` ASC [ RunTime:0.030625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15854347 LIMIT 5 [ RunTime:0.045727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15854347 ORDER BY `minOrder` ASC [ RunTime:0.013259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15854347 ORDER BY `unit` DESC [ RunTime:0.066934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15854347 LIMIT 2 [ RunTime:0.017714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15854347 ORDER BY `minOrder` ASC [ RunTime:0.012315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816825 LIMIT 5 [ RunTime:0.063110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816825 ORDER BY `minOrder` ASC [ RunTime:0.047592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15816825 ORDER BY `unit` DESC [ RunTime:0.077501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15816825 LIMIT 2 [ RunTime:0.069634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816825 ORDER BY `minOrder` ASC [ RunTime:0.020431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816823 LIMIT 5 [ RunTime:0.019645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816823 ORDER BY `minOrder` ASC [ RunTime:0.070508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15816823 ORDER BY `unit` DESC [ RunTime:0.027538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15816823 LIMIT 2 [ RunTime:0.029663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816823 ORDER BY `minOrder` ASC [ RunTime:0.006036s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014154s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33264303 LIMIT 5 [ RunTime:0.006739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264303 ORDER BY `minOrder` ASC [ RunTime:0.018452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33264303 ORDER BY `unit` DESC [ RunTime:0.016027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33264303 LIMIT 2 [ RunTime:0.014022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264303 ORDER BY `minOrder` ASC [ RunTime:0.005594s ]
select * from pdf where partno='KTR10EZPJ5R1' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.031516s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ5R1' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.030268s ]
SELECT `id` FROM `stock` WHERE `id` <> 33264303 AND `partno` = 'KTR10EZPJ5R1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.043396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15094380 [ RunTime:0.018568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33059900 LIMIT 5 [ RunTime:0.009873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33059900 ORDER BY `minOrder` ASC [ RunTime:0.003407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33059900 ORDER BY `unit` DESC [ RunTime:0.014180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33059900 LIMIT 2 [ RunTime:0.038601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33059900 ORDER BY `minOrder` ASC [ RunTime:0.016650s ]
select * from pdf where partno='KTR10EZPJ302' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.016367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ302' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007819s ]
SELECT `id` FROM `stock` WHERE `id` <> 33059900 AND `partno` = 'KTR10EZPJ302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.017165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16849800 [ RunTime:0.025877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32984368 LIMIT 5 [ RunTime:0.026669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32984368 ORDER BY `minOrder` ASC [ RunTime:0.029884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32984368 ORDER BY `unit` DESC [ RunTime:0.019773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32984368 LIMIT 2 [ RunTime:0.038101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32984368 ORDER BY `minOrder` ASC [ RunTime:0.018388s ]
select * from pdf where partno='KTR10EZPJ306' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.021854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ306' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.016580s ]
SELECT `id` FROM `stock` WHERE `id` <> 32984368 AND `partno` = 'KTR10EZPJ306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.019166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18005062 [ RunTime:0.004180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33324569 LIMIT 5 [ RunTime:0.014522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324569 ORDER BY `minOrder` ASC [ RunTime:0.021322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33324569 ORDER BY `unit` DESC [ RunTime:0.010974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33324569 LIMIT 2 [ RunTime:0.017022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324569 ORDER BY `minOrder` ASC [ RunTime:0.005394s ]
select * from pdf where partno='KTR10EZPJ334' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.020492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ334' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012769s ]
SELECT `id` FROM `stock` WHERE `id` <> 33324569 AND `partno` = 'KTR10EZPJ334' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.012957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233762 [ RunTime:0.020399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33324572 LIMIT 5 [ RunTime:0.003769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324572 ORDER BY `minOrder` ASC [ RunTime:0.012936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33324572 ORDER BY `unit` DESC [ RunTime:0.005424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33324572 LIMIT 2 [ RunTime:0.012406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324572 ORDER BY `minOrder` ASC [ RunTime:0.010834s ]
select * from pdf where partno='KTR10EZPJ205' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.007903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ205' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009280s ]
SELECT `id` FROM `stock` WHERE `id` <> 33324572 AND `partno` = 'KTR10EZPJ205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.025597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233775 [ RunTime:0.015828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33325648 LIMIT 5 [ RunTime:0.013595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33325648 ORDER BY `minOrder` ASC [ RunTime:0.021019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33325648 ORDER BY `unit` DESC [ RunTime:0.033691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33325648 LIMIT 2 [ RunTime:0.029234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33325648 ORDER BY `minOrder` ASC [ RunTime:0.027662s ]
select * from pdf where partno='KTR10EZPJ223' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.028637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ223' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.028074s ]
SELECT `id` FROM `stock` WHERE `id` <> 33325648 AND `partno` = 'KTR10EZPJ223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.029759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16872648 [ RunTime:0.011027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33299305 LIMIT 5 [ RunTime:0.011045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33299305 ORDER BY `minOrder` ASC [ RunTime:0.025496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33299305 ORDER BY `unit` DESC [ RunTime:0.006836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33299305 LIMIT 2 [ RunTime:0.033059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33299305 ORDER BY `minOrder` ASC [ RunTime:0.004237s ]
select * from pdf where partno='KTR10EZPJ471' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.026529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ471' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.014734s ]
SELECT `id` FROM `stock` WHERE `id` <> 33299305 AND `partno` = 'KTR10EZPJ471' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.018780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14128040 [ RunTime:0.001715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273166 LIMIT 5 [ RunTime:0.041461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273166 ORDER BY `minOrder` ASC [ RunTime:0.031720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273166 ORDER BY `unit` DESC [ RunTime:0.025581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273166 LIMIT 2 [ RunTime:0.008200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273166 ORDER BY `minOrder` ASC [ RunTime:0.015799s ]
select * from pdf where partno='KTR10EZPJ122' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.022507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ122' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.022570s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273166 AND `partno` = 'KTR10EZPJ122' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.006701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351933 [ RunTime:0.007542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273165 LIMIT 5 [ RunTime:0.014453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273165 ORDER BY `minOrder` ASC [ RunTime:0.027943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273165 ORDER BY `unit` DESC [ RunTime:0.025450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273165 LIMIT 2 [ RunTime:0.024024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273165 ORDER BY `minOrder` ASC [ RunTime:0.005807s ]
select * from pdf where partno='KTR10EZPJ392' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.010618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ392' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009323s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273165 AND `partno` = 'KTR10EZPJ392' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.004475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17964529 [ RunTime:0.029758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273164 LIMIT 5 [ RunTime:0.017299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273164 ORDER BY `minOrder` ASC [ RunTime:0.009205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273164 ORDER BY `unit` DESC [ RunTime:0.006433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273164 LIMIT 2 [ RunTime:0.025761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273164 ORDER BY `minOrder` ASC [ RunTime:0.013137s ]
select * from pdf where partno='KTR10EZPJ181' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.012952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ181' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012737s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273164 AND `partno` = 'KTR10EZPJ181' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.015783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17964528 [ RunTime:0.012306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273163 LIMIT 5 [ RunTime:0.007756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273163 ORDER BY `minOrder` ASC [ RunTime:0.037742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273163 ORDER BY `unit` DESC [ RunTime:0.023216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273163 LIMIT 2 [ RunTime:0.019122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273163 ORDER BY `minOrder` ASC [ RunTime:0.009875s ]
select * from pdf where partno='KTR10EZPJ154' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.007711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ154' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.011376s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273163 AND `partno` = 'KTR10EZPJ154' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.020353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879067 [ RunTime:0.023891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273157 LIMIT 5 [ RunTime:0.012545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273157 ORDER BY `minOrder` ASC [ RunTime:0.014572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273157 ORDER BY `unit` DESC [ RunTime:0.003832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273157 LIMIT 2 [ RunTime:0.003794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273157 ORDER BY `minOrder` ASC [ RunTime:0.005140s ]
select * from pdf where partno='KTR10EZPJ681' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.005399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ681' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.016759s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273157 AND `partno` = 'KTR10EZPJ681' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.011437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879069 [ RunTime:0.021801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273155 LIMIT 5 [ RunTime:0.010171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273155 ORDER BY `minOrder` ASC [ RunTime:0.010860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273155 ORDER BY `unit` DESC [ RunTime:0.011635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273155 LIMIT 2 [ RunTime:0.022114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273155 ORDER BY `minOrder` ASC [ RunTime:0.002483s ]
select * from pdf where partno='KTR10EZPJ124' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.008138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ124' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.026501s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273155 AND `partno` = 'KTR10EZPJ124' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.013897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18049254 [ RunTime:0.002846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273150 LIMIT 5 [ RunTime:0.012012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273150 ORDER BY `minOrder` ASC [ RunTime:0.007895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273150 ORDER BY `unit` DESC [ RunTime:0.002931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273150 LIMIT 2 [ RunTime:0.026593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273150 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
select * from pdf where partno='KTR10EZPJ475' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.014466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ475' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007837s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273150 AND `partno` = 'KTR10EZPJ475' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351930 [ RunTime:0.003901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33264305 LIMIT 5 [ RunTime:0.001216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264305 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33264305 ORDER BY `unit` DESC [ RunTime:0.000282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33264305 LIMIT 2 [ RunTime:0.002391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264305 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
select * from pdf where partno='KTR10EZPJ511' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.006676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ511' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000792s ]
SELECT `id` FROM `stock` WHERE `id` <> 33264305 AND `partno` = 'KTR10EZPJ511' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15094379 [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33264304 LIMIT 5 [ RunTime:0.008895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264304 ORDER BY `minOrder` ASC [ RunTime:0.012582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33264304 ORDER BY `unit` DESC [ RunTime:0.023383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33264304 LIMIT 2 [ RunTime:0.009254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264304 ORDER BY `minOrder` ASC [ RunTime:0.005862s ]
select * from pdf where partno='KTR10EZPJ155' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.014618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ155' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.006343s ]
SELECT `id` FROM `stock` WHERE `id` <> 33264304 AND `partno` = 'KTR10EZPJ155' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.012445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15854347 [ RunTime:0.007070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33231251 LIMIT 5 [ RunTime:0.014365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231251 ORDER BY `minOrder` ASC [ RunTime:0.012807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33231251 ORDER BY `unit` DESC [ RunTime:0.026323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33231251 LIMIT 2 [ RunTime:0.012728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231251 ORDER BY `minOrder` ASC [ RunTime:0.010050s ]
select * from pdf where partno='KTR10EZPJ121' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.009826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ121' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.016708s ]
SELECT `id` FROM `stock` WHERE `id` <> 33231251 AND `partno` = 'KTR10EZPJ121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.010104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18234244 [ RunTime:0.016536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33231250 LIMIT 5 [ RunTime:0.020333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231250 ORDER BY `minOrder` ASC [ RunTime:0.008161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33231250 ORDER BY `unit` DESC [ RunTime:0.032692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33231250 LIMIT 2 [ RunTime:0.018663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231250 ORDER BY `minOrder` ASC [ RunTime:0.031613s ]
select * from pdf where partno='KTR10EZPJ202' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.020082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ202' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.008475s ]
SELECT `id` FROM `stock` WHERE `id` <> 33231250 AND `partno` = 'KTR10EZPJ202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.010918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816825 [ RunTime:0.011065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33324967 LIMIT 5 [ RunTime:0.005750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324967 ORDER BY `minOrder` ASC [ RunTime:0.001847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33324967 ORDER BY `unit` DESC [ RunTime:0.002729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33324967 LIMIT 2 [ RunTime:0.005765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324967 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
select * from pdf where partno='KTR10EZPJ391' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.009236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ391' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.013084s ]
SELECT `id` FROM `stock` WHERE `id` <> 33324967 AND `partno` = 'KTR10EZPJ391' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.005738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816823 [ RunTime:0.005761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33231281 LIMIT 5 [ RunTime:0.028167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231281 ORDER BY `minOrder` ASC [ RunTime:0.016450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33231281 ORDER BY `unit` DESC [ RunTime:0.008916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33231281 LIMIT 2 [ RunTime:0.016920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231281 ORDER BY `minOrder` ASC [ RunTime:0.015309s ]
select * from pdf where partno='KTR10EZPJ272' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.029010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ272' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.015670s ]
SELECT `id` FROM `stock` WHERE `id` <> 33231281 AND `partno` = 'KTR10EZPJ272' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.006477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18234266 [ RunTime:0.010606s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010698s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016303s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014163s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010139s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004489s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012046s ]
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 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015771s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'KTR10EZPJ%' OR `brand` LIKE 'KTR10EZPJ%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012880s ]