SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001780s ]
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.006414s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002843s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001664s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000384s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002283s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004122s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002559s ]
SELECT * FROM `stock_search` WHERE `partno` = 'KTR10EZPJ' LIMIT 1 [ RunTime:0.005965s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 23:19:36' WHERE `partno` = 'KTR10EZPJ' [ RunTime:0.019709s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001842s ]
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.023405s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15723448 LIMIT 5 [ RunTime:0.014201s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15723448 ORDER BY `minOrder` ASC [ RunTime:0.003240s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15723448 ORDER BY `unit` DESC [ RunTime:0.003271s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15723448 LIMIT 2 [ RunTime:0.004148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15723448 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15055575 LIMIT 5 [ RunTime:0.009485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15055575 ORDER BY `minOrder` ASC [ RunTime:0.040944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15055575 ORDER BY `unit` DESC [ RunTime:0.017669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15055575 LIMIT 2 [ RunTime:0.037104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15055575 ORDER BY `minOrder` ASC [ RunTime:0.018823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18005062 LIMIT 5 [ RunTime:0.033530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18005062 ORDER BY `minOrder` ASC [ RunTime:0.047536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18005062 ORDER BY `unit` DESC [ RunTime:0.014177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18005062 LIMIT 2 [ RunTime:0.014999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18005062 ORDER BY `minOrder` ASC [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16849800 LIMIT 5 [ RunTime:0.013839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16849800 ORDER BY `minOrder` ASC [ RunTime:0.003609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16849800 ORDER BY `unit` DESC [ RunTime:0.039568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16849800 LIMIT 2 [ RunTime:0.044755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16849800 ORDER BY `minOrder` ASC [ RunTime:0.005591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233762 LIMIT 5 [ RunTime:0.036864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233762 ORDER BY `minOrder` ASC [ RunTime:0.006164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18233762 ORDER BY `unit` DESC [ RunTime:0.022421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18233762 LIMIT 2 [ RunTime:0.021891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233762 ORDER BY `minOrder` ASC [ RunTime:0.011619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15763150 LIMIT 5 [ RunTime:0.046154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15763150 ORDER BY `minOrder` ASC [ RunTime:0.012118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15763150 ORDER BY `unit` DESC [ RunTime:0.007149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15763150 LIMIT 2 [ RunTime:0.009543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15763150 ORDER BY `minOrder` ASC [ RunTime:0.033140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233775 LIMIT 5 [ RunTime:0.004159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233775 ORDER BY `minOrder` ASC [ RunTime:0.006697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18233775 ORDER BY `unit` DESC [ RunTime:0.031848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18233775 LIMIT 2 [ RunTime:0.048820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18233775 ORDER BY `minOrder` ASC [ RunTime:0.018917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16872648 LIMIT 5 [ RunTime:0.016925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16872648 ORDER BY `minOrder` ASC [ RunTime:0.005681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16872648 ORDER BY `unit` DESC [ RunTime:0.003514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16872648 LIMIT 2 [ RunTime:0.008665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16872648 ORDER BY `minOrder` ASC [ RunTime:0.020601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351935 LIMIT 5 [ RunTime:0.006505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351935 ORDER BY `minOrder` ASC [ RunTime:0.001103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351935 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351935 LIMIT 2 [ RunTime:0.009665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351935 ORDER BY `minOrder` ASC [ RunTime:0.014924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351934 LIMIT 5 [ RunTime:0.044387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351934 ORDER BY `minOrder` ASC [ RunTime:0.031676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351934 ORDER BY `unit` DESC [ RunTime:0.025100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351934 LIMIT 2 [ RunTime:0.028798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351934 ORDER BY `minOrder` ASC [ RunTime:0.026510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351933 LIMIT 5 [ RunTime:0.004705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351933 ORDER BY `minOrder` ASC [ RunTime:0.004676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351933 ORDER BY `unit` DESC [ RunTime:0.008888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351933 LIMIT 2 [ RunTime:0.003211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351933 ORDER BY `minOrder` ASC [ RunTime:0.015499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351929 LIMIT 5 [ RunTime:0.018159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351929 ORDER BY `minOrder` ASC [ RunTime:0.036821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18351929 ORDER BY `unit` DESC [ RunTime:0.047917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18351929 LIMIT 2 [ RunTime:0.027211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18351929 ORDER BY `minOrder` ASC [ RunTime:0.016794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18234244 LIMIT 5 [ RunTime:0.030650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18234244 ORDER BY `minOrder` ASC [ RunTime:0.031189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18234244 ORDER BY `unit` DESC [ RunTime:0.007260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18234244 LIMIT 2 [ RunTime:0.030286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18234244 ORDER BY `minOrder` ASC [ RunTime:0.012514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17964528 LIMIT 5 [ RunTime:0.014585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17964528 ORDER BY `minOrder` ASC [ RunTime:0.011644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17964528 ORDER BY `unit` DESC [ RunTime:0.002992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17964528 LIMIT 2 [ RunTime:0.007217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17964528 ORDER BY `minOrder` ASC [ RunTime:0.004232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879069 LIMIT 5 [ RunTime:0.019580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879069 ORDER BY `minOrder` ASC [ RunTime:0.011722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15879069 ORDER BY `unit` DESC [ RunTime:0.025542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15879069 LIMIT 2 [ RunTime:0.029310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879069 ORDER BY `minOrder` ASC [ RunTime:0.003363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879068 LIMIT 5 [ RunTime:0.023169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879068 ORDER BY `minOrder` ASC [ RunTime:0.006486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15879068 ORDER BY `unit` DESC [ RunTime:0.014248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15879068 LIMIT 2 [ RunTime:0.031287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879068 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879067 LIMIT 5 [ RunTime:0.014167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879067 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15879067 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15879067 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15879067 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15854347 LIMIT 5 [ RunTime:0.009853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15854347 ORDER BY `minOrder` ASC [ RunTime:0.018735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15854347 ORDER BY `unit` DESC [ RunTime:0.013814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15854347 LIMIT 2 [ RunTime:0.013424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15854347 ORDER BY `minOrder` ASC [ RunTime:0.004935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816825 LIMIT 5 [ RunTime:0.005112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816825 ORDER BY `minOrder` ASC [ RunTime:0.003831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15816825 ORDER BY `unit` DESC [ RunTime:0.010070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15816825 LIMIT 2 [ RunTime:0.041256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816825 ORDER BY `minOrder` ASC [ RunTime:0.017405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816823 LIMIT 5 [ RunTime:0.008342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816823 ORDER BY `minOrder` ASC [ RunTime:0.005296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15816823 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15816823 LIMIT 2 [ RunTime:0.015991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15816823 ORDER BY `minOrder` ASC [ RunTime:0.017552s ]
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.025067s ]
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.068876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33264303 LIMIT 5 [ RunTime:0.024022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264303 ORDER BY `minOrder` ASC [ RunTime:0.010693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33264303 ORDER BY `unit` DESC [ RunTime:0.000787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33264303 LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264303 ORDER BY `minOrder` ASC [ RunTime:0.010185s ]
select * from pdf where partno='KTR10EZPJ5R1' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.016086s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ5R1' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009559s ]
SELECT `id` FROM `stock` WHERE `id` <> 33264303 AND `partno` = 'KTR10EZPJ5R1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.007839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15094380 [ RunTime:0.005548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33059900 LIMIT 5 [ RunTime:0.002461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33059900 ORDER BY `minOrder` ASC [ RunTime:0.010414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33059900 ORDER BY `unit` DESC [ RunTime:0.028283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33059900 LIMIT 2 [ RunTime:0.005007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33059900 ORDER BY `minOrder` ASC [ RunTime:0.002788s ]
select * from pdf where partno='KTR10EZPJ302' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.009638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ302' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.025364s ]
SELECT `id` FROM `stock` WHERE `id` <> 33059900 AND `partno` = 'KTR10EZPJ302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.017055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16849800 [ RunTime:0.007549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32984368 LIMIT 5 [ RunTime:0.026477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32984368 ORDER BY `minOrder` ASC [ RunTime:0.012530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32984368 ORDER BY `unit` DESC [ RunTime:0.005823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32984368 LIMIT 2 [ RunTime:0.022929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32984368 ORDER BY `minOrder` ASC [ RunTime:0.015027s ]
select * from pdf where partno='KTR10EZPJ306' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.029872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ306' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.011282s ]
SELECT `id` FROM `stock` WHERE `id` <> 32984368 AND `partno` = 'KTR10EZPJ306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.010627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18005062 [ RunTime:0.011880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33324569 LIMIT 5 [ RunTime:0.007551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324569 ORDER BY `minOrder` ASC [ RunTime:0.003454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33324569 ORDER BY `unit` DESC [ RunTime:0.004551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33324569 LIMIT 2 [ RunTime:0.023145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324569 ORDER BY `minOrder` ASC [ RunTime:0.003297s ]
select * from pdf where partno='KTR10EZPJ334' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.009286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ334' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003618s ]
SELECT `id` FROM `stock` WHERE `id` <> 33324569 AND `partno` = 'KTR10EZPJ334' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.010944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233762 [ RunTime:0.004870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33324572 LIMIT 5 [ RunTime:0.011954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324572 ORDER BY `minOrder` ASC [ RunTime:0.019314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33324572 ORDER BY `unit` DESC [ RunTime:0.008749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33324572 LIMIT 2 [ RunTime:0.010070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324572 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
select * from pdf where partno='KTR10EZPJ205' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.011691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ205' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.016660s ]
SELECT `id` FROM `stock` WHERE `id` <> 33324572 AND `partno` = 'KTR10EZPJ205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.009408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18233775 [ RunTime:0.023426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33325648 LIMIT 5 [ RunTime:0.035136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33325648 ORDER BY `minOrder` ASC [ RunTime:0.020561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33325648 ORDER BY `unit` DESC [ RunTime:0.019686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33325648 LIMIT 2 [ RunTime:0.006763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33325648 ORDER BY `minOrder` ASC [ RunTime:0.008893s ]
select * from pdf where partno='KTR10EZPJ223' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.011382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ223' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.045298s ]
SELECT `id` FROM `stock` WHERE `id` <> 33325648 AND `partno` = 'KTR10EZPJ223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.008645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16872648 [ RunTime:0.023236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33299305 LIMIT 5 [ RunTime:0.021431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33299305 ORDER BY `minOrder` ASC [ RunTime:0.017454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33299305 ORDER BY `unit` DESC [ RunTime:0.032251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33299305 LIMIT 2 [ RunTime:0.025707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33299305 ORDER BY `minOrder` ASC [ RunTime:0.015202s ]
select * from pdf where partno='KTR10EZPJ471' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.022369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ471' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.028215s ]
SELECT `id` FROM `stock` WHERE `id` <> 33299305 AND `partno` = 'KTR10EZPJ471' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.054589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14128040 [ RunTime:0.053049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273166 LIMIT 5 [ RunTime:0.022096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273166 ORDER BY `minOrder` ASC [ RunTime:0.016923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273166 ORDER BY `unit` DESC [ RunTime:0.005996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273166 LIMIT 2 [ RunTime:0.010793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273166 ORDER BY `minOrder` ASC [ RunTime:0.009487s ]
select * from pdf where partno='KTR10EZPJ122' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.012239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ122' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012743s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273166 AND `partno` = 'KTR10EZPJ122' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.015799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351933 [ RunTime:0.011636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273165 LIMIT 5 [ RunTime:0.036844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273165 ORDER BY `minOrder` ASC [ RunTime:0.037537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273165 ORDER BY `unit` DESC [ RunTime:0.062067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273165 LIMIT 2 [ RunTime:0.033066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273165 ORDER BY `minOrder` ASC [ RunTime:0.026800s ]
select * from pdf where partno='KTR10EZPJ392' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.020758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ392' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.010047s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273165 AND `partno` = 'KTR10EZPJ392' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.037063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17964529 [ RunTime:0.031000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273164 LIMIT 5 [ RunTime:0.045422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273164 ORDER BY `minOrder` ASC [ RunTime:0.005060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273164 ORDER BY `unit` DESC [ RunTime:0.000867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273164 LIMIT 2 [ RunTime:0.003979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273164 ORDER BY `minOrder` ASC [ RunTime:0.009388s ]
select * from pdf where partno='KTR10EZPJ181' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.000358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ181' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002416s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273164 AND `partno` = 'KTR10EZPJ181' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.010503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17964528 [ RunTime:0.001358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273163 LIMIT 5 [ RunTime:0.033855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273163 ORDER BY `minOrder` ASC [ RunTime:0.037891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273163 ORDER BY `unit` DESC [ RunTime:0.019952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273163 LIMIT 2 [ RunTime:0.029399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273163 ORDER BY `minOrder` ASC [ RunTime:0.003331s ]
select * from pdf where partno='KTR10EZPJ154' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.038179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ154' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.047518s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273163 AND `partno` = 'KTR10EZPJ154' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.024310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879067 [ RunTime:0.017817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273157 LIMIT 5 [ RunTime:0.054610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273157 ORDER BY `minOrder` ASC [ RunTime:0.043423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273157 ORDER BY `unit` DESC [ RunTime:0.071898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273157 LIMIT 2 [ RunTime:0.032997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273157 ORDER BY `minOrder` ASC [ RunTime:0.039839s ]
select * from pdf where partno='KTR10EZPJ681' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.034301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ681' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.031735s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273157 AND `partno` = 'KTR10EZPJ681' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.069358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15879069 [ RunTime:0.018443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273155 LIMIT 5 [ RunTime:0.068513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273155 ORDER BY `minOrder` ASC [ RunTime:0.056882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273155 ORDER BY `unit` DESC [ RunTime:0.028695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273155 LIMIT 2 [ RunTime:0.051525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273155 ORDER BY `minOrder` ASC [ RunTime:0.019417s ]
select * from pdf where partno='KTR10EZPJ124' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.014687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ124' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.047432s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273155 AND `partno` = 'KTR10EZPJ124' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.057652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18049254 [ RunTime:0.065061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33273150 LIMIT 5 [ RunTime:0.037795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273150 ORDER BY `minOrder` ASC [ RunTime:0.034644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33273150 ORDER BY `unit` DESC [ RunTime:0.056539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33273150 LIMIT 2 [ RunTime:0.021127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33273150 ORDER BY `minOrder` ASC [ RunTime:0.034222s ]
select * from pdf where partno='KTR10EZPJ475' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.031918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ475' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.019717s ]
SELECT `id` FROM `stock` WHERE `id` <> 33273150 AND `partno` = 'KTR10EZPJ475' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.033541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18351930 [ RunTime:0.042061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33264305 LIMIT 5 [ RunTime:0.017135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264305 ORDER BY `minOrder` ASC [ RunTime:0.047017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33264305 ORDER BY `unit` DESC [ RunTime:0.013518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33264305 LIMIT 2 [ RunTime:0.011533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264305 ORDER BY `minOrder` ASC [ RunTime:0.010402s ]
select * from pdf where partno='KTR10EZPJ511' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.034965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ511' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.033345s ]
SELECT `id` FROM `stock` WHERE `id` <> 33264305 AND `partno` = 'KTR10EZPJ511' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.030401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15094379 [ RunTime:0.020143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33264304 LIMIT 5 [ RunTime:0.030622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264304 ORDER BY `minOrder` ASC [ RunTime:0.032855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33264304 ORDER BY `unit` DESC [ RunTime:0.040265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33264304 LIMIT 2 [ RunTime:0.009479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33264304 ORDER BY `minOrder` ASC [ RunTime:0.001573s ]
select * from pdf where partno='KTR10EZPJ155' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.025671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ155' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003148s ]
SELECT `id` FROM `stock` WHERE `id` <> 33264304 AND `partno` = 'KTR10EZPJ155' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.007989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15854347 [ RunTime:0.012862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33231251 LIMIT 5 [ RunTime:0.025504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231251 ORDER BY `minOrder` ASC [ RunTime:0.019411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33231251 ORDER BY `unit` DESC [ RunTime:0.029151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33231251 LIMIT 2 [ RunTime:0.019435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231251 ORDER BY `minOrder` ASC [ RunTime:0.006867s ]
select * from pdf where partno='KTR10EZPJ121' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ121' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.052029s ]
SELECT `id` FROM `stock` WHERE `id` <> 33231251 AND `partno` = 'KTR10EZPJ121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.037053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18234244 [ RunTime:0.048846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33231250 LIMIT 5 [ RunTime:0.034423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231250 ORDER BY `minOrder` ASC [ RunTime:0.012026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33231250 ORDER BY `unit` DESC [ RunTime:0.017520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33231250 LIMIT 2 [ RunTime:0.011726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231250 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='KTR10EZPJ202' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.036722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ202' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.036879s ]
SELECT `id` FROM `stock` WHERE `id` <> 33231250 AND `partno` = 'KTR10EZPJ202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.032469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816825 [ RunTime:0.029341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33324967 LIMIT 5 [ RunTime:0.014387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324967 ORDER BY `minOrder` ASC [ RunTime:0.011703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33324967 ORDER BY `unit` DESC [ RunTime:0.011958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33324967 LIMIT 2 [ RunTime:0.032284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33324967 ORDER BY `minOrder` ASC [ RunTime:0.010279s ]
select * from pdf where partno='KTR10EZPJ391' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.016683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ391' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.006136s ]
SELECT `id` FROM `stock` WHERE `id` <> 33324967 AND `partno` = 'KTR10EZPJ391' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.004808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15816823 [ RunTime:0.007557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33231281 LIMIT 5 [ RunTime:0.035721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231281 ORDER BY `minOrder` ASC [ RunTime:0.044371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33231281 ORDER BY `unit` DESC [ RunTime:0.007354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33231281 LIMIT 2 [ RunTime:0.066554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33231281 ORDER BY `minOrder` ASC [ RunTime:0.014965s ]
select * from pdf where partno='KTR10EZPJ272' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.035430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KTR10EZPJ272' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.034214s ]
SELECT `id` FROM `stock` WHERE `id` <> 33231281 AND `partno` = 'KTR10EZPJ272' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.015056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18234266 [ RunTime:0.027675s ]
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.031660s ]
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.038783s ]
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.025761s ]
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.019115s ]
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.037616s ]
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.016086s ]
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.026559s ]
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.040210s ]