SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001163s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=LSS-150&search=1' [ RunTime:0.001831s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002745s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001475s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.007735s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001140s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010708s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001320s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LSS-150' LIMIT 1 [ RunTime:0.011179s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-15 23:17:08' WHERE `partno` = 'LSS-150' [ RunTime:0.011950s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001348s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.096408s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791586 LIMIT 5 [ RunTime:0.017055s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791586 ORDER BY `minOrder` ASC [ RunTime:0.010418s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791586 ORDER BY `unit` DESC [ RunTime:0.045878s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.033631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791586 LIMIT 2 [ RunTime:0.079577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791586 ORDER BY `minOrder` ASC [ RunTime:0.037319s ]
select * from pdf where partno='LSS-150-01-F-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.064912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792069 LIMIT 5 [ RunTime:0.061568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792069 ORDER BY `minOrder` ASC [ RunTime:0.077378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792069 ORDER BY `unit` DESC [ RunTime:0.077671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792069 LIMIT 2 [ RunTime:0.039276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792069 ORDER BY `minOrder` ASC [ RunTime:0.067804s ]
select * from pdf where partno='LSS-150-01-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.059896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12784260 LIMIT 5 [ RunTime:0.072315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784260 ORDER BY `minOrder` ASC [ RunTime:0.015791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12784260 ORDER BY `unit` DESC [ RunTime:0.182867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12784260 LIMIT 2 [ RunTime:0.054957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784260 ORDER BY `minOrder` ASC [ RunTime:0.023698s ]
select * from pdf where partno='LSS-150-03-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791665 LIMIT 5 [ RunTime:0.024613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791665 ORDER BY `minOrder` ASC [ RunTime:0.015769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791665 ORDER BY `unit` DESC [ RunTime:0.013686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791665 LIMIT 2 [ RunTime:0.010577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791665 ORDER BY `minOrder` ASC [ RunTime:0.012947s ]
select * from pdf where partno='LSS-150-02-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791648 LIMIT 5 [ RunTime:0.020392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791648 ORDER BY `minOrder` ASC [ RunTime:0.073548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791648 ORDER BY `unit` DESC [ RunTime:0.053792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791648 LIMIT 2 [ RunTime:0.035579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791648 ORDER BY `minOrder` ASC [ RunTime:0.005303s ]
select * from pdf where partno='LSS-150-02-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11610810 LIMIT 5 [ RunTime:0.088178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610810 ORDER BY `minOrder` ASC [ RunTime:0.019093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11610810 ORDER BY `unit` DESC [ RunTime:0.076088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11610810 LIMIT 2 [ RunTime:0.025059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610810 ORDER BY `minOrder` ASC [ RunTime:0.038959s ]
select * from pdf where partno='LSS-150-03-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793291 LIMIT 5 [ RunTime:0.031868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793291 ORDER BY `minOrder` ASC [ RunTime:0.009482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793291 ORDER BY `unit` DESC [ RunTime:0.056592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793291 LIMIT 2 [ RunTime:0.028617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793291 ORDER BY `minOrder` ASC [ RunTime:0.020714s ]
select * from pdf where partno='LSS-150-01-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791096 LIMIT 5 [ RunTime:0.017766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791096 ORDER BY `minOrder` ASC [ RunTime:0.039377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791096 ORDER BY `unit` DESC [ RunTime:0.004612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791096 LIMIT 2 [ RunTime:0.013107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791096 ORDER BY `minOrder` ASC [ RunTime:0.003005s ]
select * from pdf where partno='LSS-150-02-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792589 LIMIT 5 [ RunTime:0.016691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792589 ORDER BY `minOrder` ASC [ RunTime:0.008175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792589 ORDER BY `unit` DESC [ RunTime:0.019589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792589 LIMIT 2 [ RunTime:0.021478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792589 ORDER BY `minOrder` ASC [ RunTime:0.010056s ]
select * from pdf where partno='LSS-150-02-L-DV-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792544 LIMIT 5 [ RunTime:0.006370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792544 ORDER BY `minOrder` ASC [ RunTime:0.003052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792544 ORDER BY `unit` DESC [ RunTime:0.004199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792544 LIMIT 2 [ RunTime:0.006560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792544 ORDER BY `minOrder` ASC [ RunTime:0.010303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792522 LIMIT 5 [ RunTime:0.014047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792522 ORDER BY `minOrder` ASC [ RunTime:0.042086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792522 ORDER BY `unit` DESC [ RunTime:0.039621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792522 LIMIT 2 [ RunTime:0.014756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792522 ORDER BY `minOrder` ASC [ RunTime:0.007221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792433 LIMIT 5 [ RunTime:0.017766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792433 ORDER BY `minOrder` ASC [ RunTime:0.053395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792433 ORDER BY `unit` DESC [ RunTime:0.042094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792433 LIMIT 2 [ RunTime:0.020946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792433 ORDER BY `minOrder` ASC [ RunTime:0.022802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786741 LIMIT 5 [ RunTime:0.039241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786741 ORDER BY `minOrder` ASC [ RunTime:0.003601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12786741 ORDER BY `unit` DESC [ RunTime:0.005863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12786741 LIMIT 2 [ RunTime:0.026887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786741 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12785498 LIMIT 5 [ RunTime:0.003524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785498 ORDER BY `minOrder` ASC [ RunTime:0.008640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12785498 ORDER BY `unit` DESC [ RunTime:0.042981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12785498 LIMIT 2 [ RunTime:0.028790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785498 ORDER BY `minOrder` ASC [ RunTime:0.004712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12784414 LIMIT 5 [ RunTime:0.027790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784414 ORDER BY `minOrder` ASC [ RunTime:0.033202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12784414 ORDER BY `unit` DESC [ RunTime:0.004784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12784414 LIMIT 2 [ RunTime:0.019106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784414 ORDER BY `minOrder` ASC [ RunTime:0.002206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12784127 LIMIT 5 [ RunTime:0.001427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784127 ORDER BY `minOrder` ASC [ RunTime:0.009385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12784127 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12784127 LIMIT 2 [ RunTime:0.002769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784127 ORDER BY `minOrder` ASC [ RunTime:0.000991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12783846 LIMIT 5 [ RunTime:0.039471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12783846 ORDER BY `minOrder` ASC [ RunTime:0.003136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12783846 ORDER BY `unit` DESC [ RunTime:0.058328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12783846 LIMIT 2 [ RunTime:0.017031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12783846 ORDER BY `minOrder` ASC [ RunTime:0.003797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12783671 LIMIT 5 [ RunTime:0.048822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12783671 ORDER BY `minOrder` ASC [ RunTime:0.026180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12783671 ORDER BY `unit` DESC [ RunTime:0.040696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12783671 LIMIT 2 [ RunTime:0.032900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12783671 ORDER BY `minOrder` ASC [ RunTime:0.021009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11610284 LIMIT 5 [ RunTime:0.022097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610284 ORDER BY `minOrder` ASC [ RunTime:0.023322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11610284 ORDER BY `unit` DESC [ RunTime:0.028655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11610284 LIMIT 2 [ RunTime:0.019080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610284 ORDER BY `minOrder` ASC [ RunTime:0.011202s ]
select * from pdf where partno='LSS-150-03-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11608790 LIMIT 5 [ RunTime:0.029729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608790 ORDER BY `minOrder` ASC [ RunTime:0.025847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11608790 ORDER BY `unit` DESC [ RunTime:0.018977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11608790 LIMIT 2 [ RunTime:0.003648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608790 ORDER BY `minOrder` ASC [ RunTime:0.037253s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017469s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59356351 LIMIT 5 [ RunTime:0.023004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59356351 ORDER BY `minOrder` ASC [ RunTime:0.021129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59356351 ORDER BY `unit` DESC [ RunTime:0.025786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59356351 LIMIT 2 [ RunTime:0.029007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59356351 ORDER BY `minOrder` ASC [ RunTime:0.016041s ]
select * from pdf where partno='LSS-150-01-L-DV-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025535s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-01-L-DV-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011968s ]
SELECT `id` FROM `stock` WHERE `id` <> 59356351 AND `partno` = 'LSS-150-01-L-DV-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59358986 LIMIT 5 [ RunTime:0.032384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358986 ORDER BY `minOrder` ASC [ RunTime:0.014620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59358986 ORDER BY `unit` DESC [ RunTime:0.012941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59358986 LIMIT 2 [ RunTime:0.014645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358986 ORDER BY `minOrder` ASC [ RunTime:0.044600s ]
select * from pdf where partno='LSS-150-01-F-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-01-F-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010274s ]
SELECT `id` FROM `stock` WHERE `id` <> 59358986 AND `partno` = 'LSS-150-01-F-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791586 [ RunTime:0.014386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359817 LIMIT 5 [ RunTime:0.022127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359817 ORDER BY `minOrder` ASC [ RunTime:0.038016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359817 ORDER BY `unit` DESC [ RunTime:0.029316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359817 LIMIT 2 [ RunTime:0.016741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359817 ORDER BY `minOrder` ASC [ RunTime:0.000794s ]
select * from pdf where partno='LSS-150-01-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-01-L-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013156s ]
SELECT `id` FROM `stock` WHERE `id` <> 59359817 AND `partno` = 'LSS-150-01-L-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.042283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792069 [ RunTime:0.011535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59358062 LIMIT 5 [ RunTime:0.019167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358062 ORDER BY `minOrder` ASC [ RunTime:0.016797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59358062 ORDER BY `unit` DESC [ RunTime:0.010091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59358062 LIMIT 2 [ RunTime:0.007406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358062 ORDER BY `minOrder` ASC [ RunTime:0.005390s ]
select * from pdf where partno='LSS-150-02-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-02-L-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005027s ]
SELECT `id` FROM `stock` WHERE `id` <> 59358062 AND `partno` = 'LSS-150-02-L-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791665 [ RunTime:0.007169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59358009 LIMIT 5 [ RunTime:0.001171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358009 ORDER BY `minOrder` ASC [ RunTime:0.012526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59358009 ORDER BY `unit` DESC [ RunTime:0.008879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59358009 LIMIT 2 [ RunTime:0.037042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358009 ORDER BY `minOrder` ASC [ RunTime:0.004239s ]
select * from pdf where partno='LSS-150-03-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-03-L-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013563s ]
SELECT `id` FROM `stock` WHERE `id` <> 59358009 AND `partno` = 'LSS-150-03-L-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12784260 [ RunTime:0.027822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59357842 LIMIT 5 [ RunTime:0.012387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59357842 ORDER BY `minOrder` ASC [ RunTime:0.011265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59357842 ORDER BY `unit` DESC [ RunTime:0.018747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59357842 LIMIT 2 [ RunTime:0.003166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59357842 ORDER BY `minOrder` ASC [ RunTime:0.008187s ]
select * from pdf where partno='LSS-150-02-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-02-F-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004281s ]
SELECT `id` FROM `stock` WHERE `id` <> 59357842 AND `partno` = 'LSS-150-02-F-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791648 [ RunTime:0.011793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59357819 LIMIT 5 [ RunTime:0.005814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59357819 ORDER BY `minOrder` ASC [ RunTime:0.000922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59357819 ORDER BY `unit` DESC [ RunTime:0.015806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59357819 LIMIT 2 [ RunTime:0.036384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59357819 ORDER BY `minOrder` ASC [ RunTime:0.002315s ]
select * from pdf where partno='LSS-150-01-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-01-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032203s ]
SELECT `id` FROM `stock` WHERE `id` <> 59357819 AND `partno` = 'LSS-150-01-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793291 [ RunTime:0.009375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59362492 LIMIT 5 [ RunTime:0.015734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362492 ORDER BY `minOrder` ASC [ RunTime:0.030366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59362492 ORDER BY `unit` DESC [ RunTime:0.007249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59362492 LIMIT 2 [ RunTime:0.027850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362492 ORDER BY `minOrder` ASC [ RunTime:0.017752s ]
select * from pdf where partno='LSS-150-03-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-03-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023433s ]
SELECT `id` FROM `stock` WHERE `id` <> 59362492 AND `partno` = 'LSS-150-03-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11610810 [ RunTime:0.009697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59362838 LIMIT 5 [ RunTime:0.019607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362838 ORDER BY `minOrder` ASC [ RunTime:0.041827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59362838 ORDER BY `unit` DESC [ RunTime:0.021531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59362838 LIMIT 2 [ RunTime:0.044149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362838 ORDER BY `minOrder` ASC [ RunTime:0.008705s ]
select * from pdf where partno='LSS-150-02-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-02-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018600s ]
SELECT `id` FROM `stock` WHERE `id` <> 59362838 AND `partno` = 'LSS-150-02-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791096 [ RunTime:0.014387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59376306 LIMIT 5 [ RunTime:0.026232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59376306 ORDER BY `minOrder` ASC [ RunTime:0.039727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59376306 ORDER BY `unit` DESC [ RunTime:0.031751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59376306 LIMIT 2 [ RunTime:0.013835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59376306 ORDER BY `minOrder` ASC [ RunTime:0.006341s ]
select * from pdf where partno='LSS-150-02-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-02-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035821s ]
SELECT `id` FROM `stock` WHERE `id` <> 59376306 AND `partno` = 'LSS-150-02-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786741 [ RunTime:0.014274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59375190 LIMIT 5 [ RunTime:0.025353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59375190 ORDER BY `minOrder` ASC [ RunTime:0.011365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59375190 ORDER BY `unit` DESC [ RunTime:0.003891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59375190 LIMIT 2 [ RunTime:0.024213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59375190 ORDER BY `minOrder` ASC [ RunTime:0.003358s ]
select * from pdf where partno='LSS-150-02-H-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-02-H-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011017s ]
SELECT `id` FROM `stock` WHERE `id` <> 59375190 AND `partno` = 'LSS-150-02-H-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59375033 LIMIT 5 [ RunTime:0.013054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59375033 ORDER BY `minOrder` ASC [ RunTime:0.020173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59375033 ORDER BY `unit` DESC [ RunTime:0.011071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59375033 LIMIT 2 [ RunTime:0.075978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59375033 ORDER BY `minOrder` ASC [ RunTime:0.037228s ]
select * from pdf where partno='LSS-150-02-H-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.045848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-02-H-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018875s ]
SELECT `id` FROM `stock` WHERE `id` <> 59375033 AND `partno` = 'LSS-150-02-H-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.041787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605457 [ RunTime:0.016027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374964 LIMIT 5 [ RunTime:0.050806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374964 ORDER BY `minOrder` ASC [ RunTime:0.037744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374964 ORDER BY `unit` DESC [ RunTime:0.012332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374964 LIMIT 2 [ RunTime:0.008388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374964 ORDER BY `minOrder` ASC [ RunTime:0.008601s ]
select * from pdf where partno='LSS-150-03-F-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-03-F-DV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019129s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374964 AND `partno` = 'LSS-150-03-F-DV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374578 LIMIT 5 [ RunTime:0.016091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374578 ORDER BY `minOrder` ASC [ RunTime:0.011873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374578 ORDER BY `unit` DESC [ RunTime:0.016709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374578 LIMIT 2 [ RunTime:0.010654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374578 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
select * from pdf where partno='LSS-150-03-H-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-03-H-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021853s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374578 AND `partno` = 'LSS-150-03-H-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374300 LIMIT 5 [ RunTime:0.020351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374300 ORDER BY `minOrder` ASC [ RunTime:0.020538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374300 ORDER BY `unit` DESC [ RunTime:0.035181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374300 LIMIT 2 [ RunTime:0.030925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374300 ORDER BY `minOrder` ASC [ RunTime:0.043284s ]
select * from pdf where partno='LSS-150-01-H-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-01-H-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017419s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374300 AND `partno` = 'LSS-150-01-H-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374128 LIMIT 5 [ RunTime:0.012137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374128 ORDER BY `minOrder` ASC [ RunTime:0.020445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374128 ORDER BY `unit` DESC [ RunTime:0.064628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374128 LIMIT 2 [ RunTime:0.124522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374128 ORDER BY `minOrder` ASC [ RunTime:0.057402s ]
select * from pdf where partno='LSS-150-01-H-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-01-H-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017633s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374128 AND `partno` = 'LSS-150-01-H-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12785498 [ RunTime:0.005413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374063 LIMIT 5 [ RunTime:0.043141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374063 ORDER BY `minOrder` ASC [ RunTime:0.085299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374063 ORDER BY `unit` DESC [ RunTime:0.129481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374063 LIMIT 2 [ RunTime:0.046168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374063 ORDER BY `minOrder` ASC [ RunTime:0.043726s ]
select * from pdf where partno='LSS-150-03-F-DV-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.062508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-03-F-DV-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012426s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374063 AND `partno` = 'LSS-150-03-F-DV-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.059389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59373524 LIMIT 5 [ RunTime:0.014897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59373524 ORDER BY `minOrder` ASC [ RunTime:0.019092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59373524 ORDER BY `unit` DESC [ RunTime:0.081037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59373524 LIMIT 2 [ RunTime:0.070796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59373524 ORDER BY `minOrder` ASC [ RunTime:0.032640s ]
select * from pdf where partno='LSS-150-03-H-DV-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-03-H-DV-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033520s ]
SELECT `id` FROM `stock` WHERE `id` <> 59373524 AND `partno` = 'LSS-150-03-H-DV-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.070010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59373188 LIMIT 5 [ RunTime:0.070180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59373188 ORDER BY `minOrder` ASC [ RunTime:0.093337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59373188 ORDER BY `unit` DESC [ RunTime:0.020935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59373188 LIMIT 2 [ RunTime:0.017318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59373188 ORDER BY `minOrder` ASC [ RunTime:0.020342s ]
select * from pdf where partno='LSS-150-01-H-DV-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-01-H-DV-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017822s ]
SELECT `id` FROM `stock` WHERE `id` <> 59373188 AND `partno` = 'LSS-150-01-H-DV-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59372490 LIMIT 5 [ RunTime:0.017523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59372490 ORDER BY `minOrder` ASC [ RunTime:0.022926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59372490 ORDER BY `unit` DESC [ RunTime:0.033197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59372490 LIMIT 2 [ RunTime:0.010301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59372490 ORDER BY `minOrder` ASC [ RunTime:0.021181s ]
select * from pdf where partno='LSS-150-02-F-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LSS-150-02-F-DV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019351s ]
SELECT `id` FROM `stock` WHERE `id` <> 59372490 AND `partno` = 'LSS-150-02-F-DV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12784414 [ RunTime:0.023937s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033482s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029555s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019652s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017887s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004018s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001864s ]
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 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022760s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LSS-150%' OR `brand` LIKE 'LSS-150%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030832s ]