SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003877s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.177' , `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=WTK&search=1' [ RunTime:0.002988s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002200s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002674s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.177' ) [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002241s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000382s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002409s ]
SELECT * FROM `stock_search` WHERE `partno` = 'WTK' LIMIT 1 [ RunTime:0.003695s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-07-28 13:05:56' WHERE `partno` = 'WTK' [ RunTime:0.001825s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003785s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020301s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828581 LIMIT 5 [ RunTime:0.001079s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828581 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13828581 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13828581 LIMIT 2 [ RunTime:0.001504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828581 ORDER BY `minOrder` ASC [ RunTime:0.005024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13306559 LIMIT 5 [ RunTime:0.001668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13306559 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13306559 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13306559 LIMIT 2 [ RunTime:0.008520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13306559 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13305948 LIMIT 5 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305948 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13305948 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13305948 LIMIT 2 [ RunTime:0.002591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305948 ORDER BY `minOrder` ASC [ RunTime:0.005436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293526 LIMIT 5 [ RunTime:0.007599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293526 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13293526 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13293526 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293526 ORDER BY `minOrder` ASC [ RunTime:0.004604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290844 LIMIT 5 [ RunTime:0.010984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290844 ORDER BY `minOrder` ASC [ RunTime:0.005765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290844 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290844 LIMIT 2 [ RunTime:0.009241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290844 ORDER BY `minOrder` ASC [ RunTime:0.002750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290694 LIMIT 5 [ RunTime:0.001490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290694 ORDER BY `minOrder` ASC [ RunTime:0.003393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290694 ORDER BY `unit` DESC [ RunTime:0.001702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290694 LIMIT 2 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290694 ORDER BY `minOrder` ASC [ RunTime:0.002292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290638 LIMIT 5 [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290638 ORDER BY `minOrder` ASC [ RunTime:0.009629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290638 ORDER BY `unit` DESC [ RunTime:0.004009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290638 LIMIT 2 [ RunTime:0.009800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290638 ORDER BY `minOrder` ASC [ RunTime:0.002521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290612 LIMIT 5 [ RunTime:0.003675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290612 ORDER BY `minOrder` ASC [ RunTime:0.005755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290612 ORDER BY `unit` DESC [ RunTime:0.011048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290612 LIMIT 2 [ RunTime:0.005300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290612 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290463 LIMIT 5 [ RunTime:0.015508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290463 ORDER BY `minOrder` ASC [ RunTime:0.013558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290463 ORDER BY `unit` DESC [ RunTime:0.004165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290463 LIMIT 2 [ RunTime:0.004705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290463 ORDER BY `minOrder` ASC [ RunTime:0.003441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290261 LIMIT 5 [ RunTime:0.002480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290261 ORDER BY `minOrder` ASC [ RunTime:0.007842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290261 ORDER BY `unit` DESC [ RunTime:0.006706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290261 LIMIT 2 [ RunTime:0.004513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290261 ORDER BY `minOrder` ASC [ RunTime:0.006086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290065 LIMIT 5 [ RunTime:0.010445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290065 ORDER BY `minOrder` ASC [ RunTime:0.005823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290065 ORDER BY `unit` DESC [ RunTime:0.002934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290065 LIMIT 2 [ RunTime:0.011190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290065 ORDER BY `minOrder` ASC [ RunTime:0.006694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289879 LIMIT 5 [ RunTime:0.005889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289879 ORDER BY `minOrder` ASC [ RunTime:0.002085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289879 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289879 LIMIT 2 [ RunTime:0.001253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289879 ORDER BY `minOrder` ASC [ RunTime:0.007269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289878 LIMIT 5 [ RunTime:0.002673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289878 ORDER BY `minOrder` ASC [ RunTime:0.000872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289878 ORDER BY `unit` DESC [ RunTime:0.008620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289878 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289878 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289877 LIMIT 5 [ RunTime:0.003565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289877 ORDER BY `minOrder` ASC [ RunTime:0.005912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289877 ORDER BY `unit` DESC [ RunTime:0.001559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289877 LIMIT 2 [ RunTime:0.000834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289877 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289876 LIMIT 5 [ RunTime:0.002958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289876 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289876 ORDER BY `unit` DESC [ RunTime:0.009002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289876 LIMIT 2 [ RunTime:0.004221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289876 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289109 LIMIT 5 [ RunTime:0.006898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289109 ORDER BY `minOrder` ASC [ RunTime:0.004667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289109 ORDER BY `unit` DESC [ RunTime:0.002034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289109 LIMIT 2 [ RunTime:0.007556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289109 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288918 LIMIT 5 [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288918 ORDER BY `minOrder` ASC [ RunTime:0.008192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288918 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288918 LIMIT 2 [ RunTime:0.014350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288918 ORDER BY `minOrder` ASC [ RunTime:0.001278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288669 LIMIT 5 [ RunTime:0.003119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288669 ORDER BY `minOrder` ASC [ RunTime:0.001619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288669 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288669 LIMIT 2 [ RunTime:0.006324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288669 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288545 LIMIT 5 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288545 ORDER BY `minOrder` ASC [ RunTime:0.008137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288545 ORDER BY `unit` DESC [ RunTime:0.002869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288545 LIMIT 2 [ RunTime:0.012373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288545 ORDER BY `minOrder` ASC [ RunTime:0.007812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288451 LIMIT 5 [ RunTime:0.023219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288451 ORDER BY `minOrder` ASC [ RunTime:0.022610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288451 ORDER BY `unit` DESC [ RunTime:0.073692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288451 LIMIT 2 [ RunTime:0.036268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288451 ORDER BY `minOrder` ASC [ RunTime:0.031642s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32265925 LIMIT 5 [ RunTime:0.015763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265925 ORDER BY `minOrder` ASC [ RunTime:0.022020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32265925 ORDER BY `unit` DESC [ RunTime:0.034879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32265925 LIMIT 2 [ RunTime:0.008887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265925 ORDER BY `minOrder` ASC [ RunTime:0.004663s ]
select * from pdf where partno='wtka20sj' and brandshort='molex / airborn' limit 1 [ RunTime:0.007116s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'wtka20sj' OR `brand` LIKE 'molex / airborn%' ) ) LIMIT 1 [ RunTime:0.014482s ]
SELECT `id` FROM `stock` WHERE `id` <> 32265925 AND `partno` = 'wtka20sj' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%molex / airborn%' ) [ RunTime:0.034213s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423112 LIMIT 5 [ RunTime:0.027864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423112 ORDER BY `minOrder` ASC [ RunTime:0.014879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423112 ORDER BY `unit` DESC [ RunTime:0.016117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423112 LIMIT 2 [ RunTime:0.011216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423112 ORDER BY `minOrder` ASC [ RunTime:0.004702s ]
select * from pdf where partno='WTK-6-60' and brandshort='Omega' limit 1 [ RunTime:0.005450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-6-60' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002611s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423112 AND `partno` = 'WTK-6-60' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423385 LIMIT 5 [ RunTime:0.010635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423385 ORDER BY `minOrder` ASC [ RunTime:0.013303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423385 ORDER BY `unit` DESC [ RunTime:0.000744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423385 LIMIT 2 [ RunTime:0.009383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423385 ORDER BY `minOrder` ASC [ RunTime:0.006437s ]
select * from pdf where partno='WTK-6-12' and brandshort='Omega' limit 1 [ RunTime:0.004087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-6-12' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.004996s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423385 AND `partno` = 'WTK-6-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265649 [ RunTime:0.016507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423389 LIMIT 5 [ RunTime:0.003003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423389 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423389 ORDER BY `unit` DESC [ RunTime:0.000515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423389 LIMIT 2 [ RunTime:0.006214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423389 ORDER BY `minOrder` ASC [ RunTime:0.004317s ]
select * from pdf where partno='WTK-8-24' and brandshort='Omega' limit 1 [ RunTime:0.012848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-8-24' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.010594s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423389 AND `partno` = 'WTK-8-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.011232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992399 [ RunTime:0.002051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423135 LIMIT 5 [ RunTime:0.031443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423135 ORDER BY `minOrder` ASC [ RunTime:0.009033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423135 ORDER BY `unit` DESC [ RunTime:0.014562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423135 LIMIT 2 [ RunTime:0.012067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423135 ORDER BY `minOrder` ASC [ RunTime:0.006820s ]
select * from pdf where partno='WTK-HD-72-S' and brandshort='Omega' limit 1 [ RunTime:0.003698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-HD-72-S' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002318s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423135 AND `partno` = 'WTK-HD-72-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.008757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13264298 [ RunTime:0.005006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423486 LIMIT 5 [ RunTime:0.018622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423486 ORDER BY `minOrder` ASC [ RunTime:0.004522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423486 ORDER BY `unit` DESC [ RunTime:0.008103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423486 LIMIT 2 [ RunTime:0.002612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423486 ORDER BY `minOrder` ASC [ RunTime:0.001594s ]
select * from pdf where partno='WTK-HD-72-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.008277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-HD-72-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002635s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423486 AND `partno` = 'WTK-HD-72-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.003340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991380 [ RunTime:0.001836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423397 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423397 ORDER BY `minOrder` ASC [ RunTime:0.010304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423397 ORDER BY `unit` DESC [ RunTime:0.001400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423397 LIMIT 2 [ RunTime:0.002905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423397 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='WTK-10-60' and brandshort='Omega' limit 1 [ RunTime:0.001256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-10-60' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.007838s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423397 AND `partno` = 'WTK-10-60' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266360 [ RunTime:0.002902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423396 LIMIT 5 [ RunTime:0.001123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423396 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423396 ORDER BY `unit` DESC [ RunTime:0.002954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423396 LIMIT 2 [ RunTime:0.004545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423396 ORDER BY `minOrder` ASC [ RunTime:0.002325s ]
select * from pdf where partno='WTK-8-60' and brandshort='Omega' limit 1 [ RunTime:0.003917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-8-60' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.000580s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423396 AND `partno` = 'WTK-8-60' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266358 [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423391 LIMIT 5 [ RunTime:0.003707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423391 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423391 ORDER BY `unit` DESC [ RunTime:0.002068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423391 LIMIT 2 [ RunTime:0.003403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423391 ORDER BY `minOrder` ASC [ RunTime:0.002269s ]
select * from pdf where partno='WTK-14-36' and brandshort='Omega' limit 1 [ RunTime:0.004106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-14-36' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001933s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423391 AND `partno` = 'WTK-14-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.000656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992405 [ RunTime:0.002753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423384 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423384 ORDER BY `minOrder` ASC [ RunTime:0.014239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423384 ORDER BY `unit` DESC [ RunTime:0.007966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423384 LIMIT 2 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423384 ORDER BY `minOrder` ASC [ RunTime:0.000813s ]
select * from pdf where partno='WTK-6-36' and brandshort='Omega' limit 1 [ RunTime:0.015321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-6-36' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.009933s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423384 AND `partno` = 'WTK-6-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.005518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992013 [ RunTime:0.013470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56423383 LIMIT 5 [ RunTime:0.008612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423383 ORDER BY `minOrder` ASC [ RunTime:0.003574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56423383 ORDER BY `unit` DESC [ RunTime:0.006076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56423383 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56423383 ORDER BY `minOrder` ASC [ RunTime:0.003198s ]
select * from pdf where partno='WTK-8-12' and brandshort='Omega' limit 1 [ RunTime:0.002730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-8-12' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002928s ]
SELECT `id` FROM `stock` WHERE `id` <> 56423383 AND `partno` = 'WTK-8-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.007487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265635 [ RunTime:0.009924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56426325 LIMIT 5 [ RunTime:0.002991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56426325 ORDER BY `minOrder` ASC [ RunTime:0.005777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56426325 ORDER BY `unit` DESC [ RunTime:0.006210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56426325 LIMIT 2 [ RunTime:0.002718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56426325 ORDER BY `minOrder` ASC [ RunTime:0.006385s ]
select * from pdf where partno='WTK-14-36-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.002400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-14-36-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.007176s ]
SELECT `id` FROM `stock` WHERE `id` <> 56426325 AND `partno` = 'WTK-14-36-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.006638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425290 LIMIT 5 [ RunTime:0.006465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425290 ORDER BY `minOrder` ASC [ RunTime:0.001854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425290 ORDER BY `unit` DESC [ RunTime:0.006268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425290 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425290 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
select * from pdf where partno='WTK-6-60-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.000758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-6-60-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.004559s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425290 AND `partno` = 'WTK-6-60-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.003471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263495 [ RunTime:0.003204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425289 LIMIT 5 [ RunTime:0.004834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425289 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425289 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425289 LIMIT 2 [ RunTime:0.007781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425289 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
select * from pdf where partno='WTK-10-60-TT-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.000743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-10-60-TT-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.000661s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425289 AND `partno` = 'WTK-10-60-TT-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263494 [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425288 LIMIT 5 [ RunTime:0.001499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425288 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425288 ORDER BY `unit` DESC [ RunTime:0.005617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425288 LIMIT 2 [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425288 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
select * from pdf where partno='WTK-14-60-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.002428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-14-60-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002570s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425288 AND `partno` = 'WTK-14-60-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.002043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263493 [ RunTime:0.001235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425287 LIMIT 5 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425287 ORDER BY `minOrder` ASC [ RunTime:0.012242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425287 ORDER BY `unit` DESC [ RunTime:0.002783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425287 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425287 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
select * from pdf where partno='WTK-6-60-TT-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.001502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-6-60-TT-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002979s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425287 AND `partno` = 'WTK-6-60-TT-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263492 [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425286 LIMIT 5 [ RunTime:0.005019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425286 ORDER BY `minOrder` ASC [ RunTime:0.000827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425286 ORDER BY `unit` DESC [ RunTime:0.000333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425286 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425286 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
select * from pdf where partno='WTK-8-60-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.000726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-8-60-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002149s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425286 AND `partno` = 'WTK-8-60-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11990578 [ RunTime:0.001112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425285 LIMIT 5 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425285 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425285 ORDER BY `unit` DESC [ RunTime:0.001969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425285 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425285 ORDER BY `minOrder` ASC [ RunTime:0.004953s ]
select * from pdf where partno='WTK-14-60-TT-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-14-60-TT-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.000491s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425285 AND `partno` = 'WTK-14-60-TT-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263491 [ RunTime:0.000823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425284 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425284 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425284 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425284 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425284 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
select * from pdf where partno='WTK-14-60-OSTW-M' and brandshort='Omega' limit 1 [ RunTime:0.000558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-14-60-OSTW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002991s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425284 AND `partno` = 'WTK-14-60-OSTW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11990577 [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56425006 LIMIT 5 [ RunTime:0.002269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425006 ORDER BY `minOrder` ASC [ RunTime:0.006100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56425006 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56425006 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56425006 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='WTK-6-60-OSTW-M' and brandshort='Omega' limit 1 [ RunTime:0.001251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-6-60-OSTW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001211s ]
SELECT `id` FROM `stock` WHERE `id` <> 56425006 AND `partno` = 'WTK-6-60-OSTW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56424649 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56424649 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56424649 ORDER BY `unit` DESC [ RunTime:0.002507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56424649 LIMIT 2 [ RunTime:0.003009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56424649 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
select * from pdf where partno='WTK-6-36-SMPW-M' and brandshort='Omega' limit 1 [ RunTime:0.001643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTK-6-36-SMPW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.000467s ]
SELECT `id` FROM `stock` WHERE `id` <> 56424649 AND `partno` = 'WTK-6-36-SMPW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.010183s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004394s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002165s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007548s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007670s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008898s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000907s ]
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 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000690s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTK%' OR `brand` LIKE 'WTK%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002084s ]