SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001429s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030495s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193526 LIMIT 5 [ RunTime:0.032297s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193526 ORDER BY `minOrder` ASC [ RunTime:0.037069s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16193526 ORDER BY `unit` DESC [ RunTime:0.002874s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16193526 LIMIT 2 [ RunTime:0.016370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193526 ORDER BY `minOrder` ASC [ RunTime:0.011769s ]
select * from pdf where partno='EHF-110-01-F-D-SM-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767584 LIMIT 5 [ RunTime:0.034253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767584 ORDER BY `minOrder` ASC [ RunTime:0.050208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19767584 ORDER BY `unit` DESC [ RunTime:0.038840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19767584 LIMIT 2 [ RunTime:0.031209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767584 ORDER BY `minOrder` ASC [ RunTime:0.047232s ]
select * from pdf where partno='EHF-110-01-F-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191813 LIMIT 5 [ RunTime:0.025649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191813 ORDER BY `minOrder` ASC [ RunTime:0.017947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16191813 ORDER BY `unit` DESC [ RunTime:0.066596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16191813 LIMIT 2 [ RunTime:0.038654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191813 ORDER BY `minOrder` ASC [ RunTime:0.010157s ]
select * from pdf where partno='EHF-110-01-F-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19840690 LIMIT 5 [ RunTime:0.010607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19840690 ORDER BY `minOrder` ASC [ RunTime:0.022029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19840690 ORDER BY `unit` DESC [ RunTime:0.049008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19840690 LIMIT 2 [ RunTime:0.045357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19840690 ORDER BY `minOrder` ASC [ RunTime:0.022638s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.057739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236264 LIMIT 5 [ RunTime:0.012769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236264 ORDER BY `minOrder` ASC [ RunTime:0.018197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16236264 ORDER BY `unit` DESC [ RunTime:0.006866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16236264 LIMIT 2 [ RunTime:0.016045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236264 ORDER BY `minOrder` ASC [ RunTime:0.004045s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19765607 LIMIT 5 [ RunTime:0.020193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19765607 ORDER BY `minOrder` ASC [ RunTime:0.008226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19765607 ORDER BY `unit` DESC [ RunTime:0.001082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19765607 LIMIT 2 [ RunTime:0.004634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19765607 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='EHF-110-01-F-D-SM-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19800294 LIMIT 5 [ RunTime:0.011262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19800294 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19800294 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19800294 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19800294 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16216340 LIMIT 5 [ RunTime:0.003997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216340 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16216340 ORDER BY `unit` DESC [ RunTime:0.003444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16216340 LIMIT 2 [ RunTime:0.008194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216340 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484900 LIMIT 5 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484900 ORDER BY `minOrder` ASC [ RunTime:0.004458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15484900 ORDER BY `unit` DESC [ RunTime:0.006251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15484900 LIMIT 2 [ RunTime:0.006765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484900 ORDER BY `minOrder` ASC [ RunTime:0.004847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759314 LIMIT 5 [ RunTime:0.006487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759314 ORDER BY `minOrder` ASC [ RunTime:0.003779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759314 ORDER BY `unit` DESC [ RunTime:0.001249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759314 LIMIT 2 [ RunTime:0.008772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759314 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759313 LIMIT 5 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759313 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759313 ORDER BY `unit` DESC [ RunTime:0.003584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759313 LIMIT 2 [ RunTime:0.006540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759313 ORDER BY `minOrder` ASC [ RunTime:0.008644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758461 LIMIT 5 [ RunTime:0.002155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758461 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12758461 ORDER BY `unit` DESC [ RunTime:0.002170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12758461 LIMIT 2 [ RunTime:0.006408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758461 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758460 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758460 ORDER BY `minOrder` ASC [ RunTime:0.007559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12758460 ORDER BY `unit` DESC [ RunTime:0.001794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12758460 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758460 ORDER BY `minOrder` ASC [ RunTime:0.005869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758459 LIMIT 5 [ RunTime:0.007367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758459 ORDER BY `minOrder` ASC [ RunTime:0.016340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12758459 ORDER BY `unit` DESC [ RunTime:0.002916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12758459 LIMIT 2 [ RunTime:0.001907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758459 ORDER BY `minOrder` ASC [ RunTime:0.007141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758458 LIMIT 5 [ RunTime:0.009585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758458 ORDER BY `minOrder` ASC [ RunTime:0.007889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12758458 ORDER BY `unit` DESC [ RunTime:0.003129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12758458 LIMIT 2 [ RunTime:0.001722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758458 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758457 LIMIT 5 [ RunTime:0.006018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758457 ORDER BY `minOrder` ASC [ RunTime:0.006758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12758457 ORDER BY `unit` DESC [ RunTime:0.001765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12758457 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758457 ORDER BY `minOrder` ASC [ RunTime:0.002192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740003 LIMIT 5 [ RunTime:0.001390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740003 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740003 ORDER BY `unit` DESC [ RunTime:0.002604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740003 LIMIT 2 [ RunTime:0.020069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740003 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC-01-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738893 LIMIT 5 [ RunTime:0.006172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738893 ORDER BY `minOrder` ASC [ RunTime:0.007440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12738893 ORDER BY `unit` DESC [ RunTime:0.011828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12738893 LIMIT 2 [ RunTime:0.003473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738893 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738062 LIMIT 5 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738062 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12738062 ORDER BY `unit` DESC [ RunTime:0.002224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12738062 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738062 ORDER BY `minOrder` ASC [ RunTime:0.003365s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571246 LIMIT 5 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571246 ORDER BY `minOrder` ASC [ RunTime:0.008017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11571246 ORDER BY `unit` DESC [ RunTime:0.003073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11571246 LIMIT 2 [ RunTime:0.006449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571246 ORDER BY `minOrder` ASC [ RunTime:0.003005s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC-05-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012691s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015792s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59447027 LIMIT 5 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447027 ORDER BY `minOrder` ASC [ RunTime:0.011188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59447027 ORDER BY `unit` DESC [ RunTime:0.011358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59447027 LIMIT 2 [ RunTime:0.003602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447027 ORDER BY `minOrder` ASC [ RunTime:0.006475s ]
select * from pdf where partno='EHF-110-01-F-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008461s ]
SELECT `id` FROM `stock` WHERE `id` <> 59447027 AND `partno` = 'EHF-110-01-F-D-SM-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767584 [ RunTime:0.000826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446983 LIMIT 5 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446983 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446983 ORDER BY `unit` DESC [ RunTime:0.003129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446983 LIMIT 2 [ RunTime:0.011548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446983 ORDER BY `minOrder` ASC [ RunTime:0.001482s ]
select * from pdf where partno='EHF-110-01-F-D-SM-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000874s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446983 AND `partno` = 'EHF-110-01-F-D-SM-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193526 [ RunTime:0.000404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59538744 LIMIT 5 [ RunTime:0.002191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538744 ORDER BY `minOrder` ASC [ RunTime:0.000813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59538744 ORDER BY `unit` DESC [ RunTime:0.002926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59538744 LIMIT 2 [ RunTime:0.002729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59538744 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000438s ]
SELECT `id` FROM `stock` WHERE `id` <> 59538744 AND `partno` = 'EHF-110-01-F-D-SM-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236264 [ RunTime:0.003254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446410 LIMIT 5 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446410 ORDER BY `minOrder` ASC [ RunTime:0.010237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446410 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446410 LIMIT 2 [ RunTime:0.001917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446410 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='EHF-110-01-F-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000276s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446410 AND `partno` = 'EHF-110-01-F-D-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191813 [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725765 LIMIT 5 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725765 ORDER BY `minOrder` ASC [ RunTime:0.012327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725765 ORDER BY `unit` DESC [ RunTime:0.001517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725765 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725765 ORDER BY `minOrder` ASC [ RunTime:0.000183s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC-15' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-LC-15' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009346s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725765 AND `partno` = 'EHF-110-01-F-D-SM-LC-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725763 LIMIT 5 [ RunTime:0.001740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725763 ORDER BY `minOrder` ASC [ RunTime:0.001237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725763 ORDER BY `unit` DESC [ RunTime:0.007415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725763 LIMIT 2 [ RunTime:0.002576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725763 ORDER BY `minOrder` ASC [ RunTime:0.010510s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC-14' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-LC-14' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001625s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725763 AND `partno` = 'EHF-110-01-F-D-SM-LC-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759314 [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725761 LIMIT 5 [ RunTime:0.006443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725761 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725761 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725761 LIMIT 2 [ RunTime:0.002881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725761 ORDER BY `minOrder` ASC [ RunTime:0.005321s ]
select * from pdf where partno='EHF-110-01-F-D-SM-LC-06' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-LC-06' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008247s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725761 AND `partno` = 'EHF-110-01-F-D-SM-LC-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759313 [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725162 LIMIT 5 [ RunTime:0.003486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725162 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725162 ORDER BY `unit` DESC [ RunTime:0.001750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725162 LIMIT 2 [ RunTime:0.008830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725162 ORDER BY `minOrder` ASC [ RunTime:0.009370s ]
select * from pdf where partno='EHF-110-01-F-D-SM-06-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-06-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003132s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725162 AND `partno` = 'EHF-110-01-F-D-SM-06-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725161 LIMIT 5 [ RunTime:0.004642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725161 ORDER BY `minOrder` ASC [ RunTime:0.012275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725161 ORDER BY `unit` DESC [ RunTime:0.005779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725161 LIMIT 2 [ RunTime:0.004322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725161 ORDER BY `minOrder` ASC [ RunTime:0.004930s ]
select * from pdf where partno='EHF-110-01-F-D-SM-01-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-01-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000560s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725161 AND `partno` = 'EHF-110-01-F-D-SM-01-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59724657 LIMIT 5 [ RunTime:0.004738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724657 ORDER BY `minOrder` ASC [ RunTime:0.000965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59724657 ORDER BY `unit` DESC [ RunTime:0.017598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59724657 LIMIT 2 [ RunTime:0.005393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724657 ORDER BY `minOrder` ASC [ RunTime:0.002403s ]
select * from pdf where partno='EHF-110-01-F-D-SM-07-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-07-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000742s ]
SELECT `id` FROM `stock` WHERE `id` <> 59724657 AND `partno` = 'EHF-110-01-F-D-SM-07-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59724655 LIMIT 5 [ RunTime:0.005392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724655 ORDER BY `minOrder` ASC [ RunTime:0.004040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59724655 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59724655 LIMIT 2 [ RunTime:0.005394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724655 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
select * from pdf where partno='EHF-110-01-F-D-SM-02-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-02-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003391s ]
SELECT `id` FROM `stock` WHERE `id` <> 59724655 AND `partno` = 'EHF-110-01-F-D-SM-02-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59724268 LIMIT 5 [ RunTime:0.010828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724268 ORDER BY `minOrder` ASC [ RunTime:0.001866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59724268 ORDER BY `unit` DESC [ RunTime:0.003993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59724268 LIMIT 2 [ RunTime:0.005139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724268 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
select * from pdf where partno='EHF-110-01-F-D-SM-01-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-01-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005925s ]
SELECT `id` FROM `stock` WHERE `id` <> 59724268 AND `partno` = 'EHF-110-01-F-D-SM-01-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59723714 LIMIT 5 [ RunTime:0.002122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723714 ORDER BY `minOrder` ASC [ RunTime:0.001411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59723714 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59723714 LIMIT 2 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723714 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
select * from pdf where partno='EHF-110-01-F-D-SM-06' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-06' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007527s ]
SELECT `id` FROM `stock` WHERE `id` <> 59723714 AND `partno` = 'EHF-110-01-F-D-SM-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758461 [ RunTime:0.004344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59723713 LIMIT 5 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723713 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59723713 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59723713 LIMIT 2 [ RunTime:0.001779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723713 ORDER BY `minOrder` ASC [ RunTime:0.000214s ]
select * from pdf where partno='EHF-110-01-F-D-SM-09' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-09' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004094s ]
SELECT `id` FROM `stock` WHERE `id` <> 59723713 AND `partno` = 'EHF-110-01-F-D-SM-09' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758459 [ RunTime:0.003225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59723712 LIMIT 5 [ RunTime:0.002369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723712 ORDER BY `minOrder` ASC [ RunTime:0.001744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59723712 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59723712 LIMIT 2 [ RunTime:0.002628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723712 ORDER BY `minOrder` ASC [ RunTime:0.004431s ]
select * from pdf where partno='EHF-110-01-F-D-SM-04' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-04' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000719s ]
SELECT `id` FROM `stock` WHERE `id` <> 59723712 AND `partno` = 'EHF-110-01-F-D-SM-04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758458 [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59723711 LIMIT 5 [ RunTime:0.006167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723711 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59723711 ORDER BY `unit` DESC [ RunTime:0.001161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59723711 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723711 ORDER BY `minOrder` ASC [ RunTime:0.003277s ]
select * from pdf where partno='EHF-110-01-F-D-SM-08' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-08' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT `id` FROM `stock` WHERE `id` <> 59723711 AND `partno` = 'EHF-110-01-F-D-SM-08' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758457 [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59721333 LIMIT 5 [ RunTime:0.004006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59721333 ORDER BY `minOrder` ASC [ RunTime:0.001962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59721333 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59721333 LIMIT 2 [ RunTime:0.003109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59721333 ORDER BY `minOrder` ASC [ RunTime:0.001470s ]
select * from pdf where partno='EHF-110-01-F-D-SM-04-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-04-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001040s ]
SELECT `id` FROM `stock` WHERE `id` <> 59721333 AND `partno` = 'EHF-110-01-F-D-SM-04-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59720523 LIMIT 5 [ RunTime:0.005789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59720523 ORDER BY `minOrder` ASC [ RunTime:0.001786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59720523 ORDER BY `unit` DESC [ RunTime:0.000738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59720523 LIMIT 2 [ RunTime:0.003526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59720523 ORDER BY `minOrder` ASC [ RunTime:0.007017s ]
select * from pdf where partno='EHF-110-01-F-D-SM-01-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-01-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012306s ]
SELECT `id` FROM `stock` WHERE `id` <> 59720523 AND `partno` = 'EHF-110-01-F-D-SM-01-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59719404 LIMIT 5 [ RunTime:0.006023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59719404 ORDER BY `minOrder` ASC [ RunTime:0.011410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59719404 ORDER BY `unit` DESC [ RunTime:0.006794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59719404 LIMIT 2 [ RunTime:0.001010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59719404 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='EHF-110-01-F-D-SM-15' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-15' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000556s ]
SELECT `id` FROM `stock` WHERE `id` <> 59719404 AND `partno` = 'EHF-110-01-F-D-SM-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758460 [ RunTime:0.010762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59719403 LIMIT 5 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59719403 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59719403 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59719403 LIMIT 2 [ RunTime:0.001096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59719403 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='EHF-110-01-F-D-SM-10' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-F-D-SM-10' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004876s ]
SELECT `id` FROM `stock` WHERE `id` <> 59719403 AND `partno` = 'EHF-110-01-F-D-SM-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013212s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021165s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020868s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012907s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010784s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020910s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002914s ]
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 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013109s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EHF-110-01-F-D-SM%' OR `brand` LIKE 'EHF-110-01-F-D-SM%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005526s ]