SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002947s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031877s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833966 LIMIT 5 [ RunTime:0.035503s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833966 ORDER BY `minOrder` ASC [ RunTime:0.009034s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833966 ORDER BY `unit` DESC [ RunTime:0.004220s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833966 LIMIT 2 [ RunTime:0.015609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833966 ORDER BY `minOrder` ASC [ RunTime:0.009869s ]
select * from pdf where partno='FTSH-125-01-LM-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812055 LIMIT 5 [ RunTime:0.016278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812055 ORDER BY `minOrder` ASC [ RunTime:0.010103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19812055 ORDER BY `unit` DESC [ RunTime:0.020982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19812055 LIMIT 2 [ RunTime:0.034947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812055 ORDER BY `minOrder` ASC [ RunTime:0.003125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759478 LIMIT 5 [ RunTime:0.006115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759478 ORDER BY `minOrder` ASC [ RunTime:0.004071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759478 ORDER BY `unit` DESC [ RunTime:0.020875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759478 LIMIT 2 [ RunTime:0.020624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759478 ORDER BY `minOrder` ASC [ RunTime:0.006265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12752477 LIMIT 5 [ RunTime:0.033211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12752477 ORDER BY `minOrder` ASC [ RunTime:0.013341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12752477 ORDER BY `unit` DESC [ RunTime:0.010995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12752477 LIMIT 2 [ RunTime:0.014623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12752477 ORDER BY `minOrder` ASC [ RunTime:0.009316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12751387 LIMIT 5 [ RunTime:0.018190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751387 ORDER BY `minOrder` ASC [ RunTime:0.024461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12751387 ORDER BY `unit` DESC [ RunTime:0.026945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12751387 LIMIT 2 [ RunTime:0.016394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751387 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749841 LIMIT 5 [ RunTime:0.016837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749841 ORDER BY `minOrder` ASC [ RunTime:0.020851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12749841 ORDER BY `unit` DESC [ RunTime:0.013853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12749841 LIMIT 2 [ RunTime:0.008141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749841 ORDER BY `minOrder` ASC [ RunTime:0.011071s ]
select * from pdf where partno='FTSH-125-01-LM-DH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749697 LIMIT 5 [ RunTime:0.017909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749697 ORDER BY `minOrder` ASC [ RunTime:0.003516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12749697 ORDER BY `unit` DESC [ RunTime:0.017692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12749697 LIMIT 2 [ RunTime:0.010857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749697 ORDER BY `minOrder` ASC [ RunTime:0.008877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748840 LIMIT 5 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748840 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12748840 ORDER BY `unit` DESC [ RunTime:0.002623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12748840 LIMIT 2 [ RunTime:0.012011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748840 ORDER BY `minOrder` ASC [ RunTime:0.003959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748839 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748839 ORDER BY `minOrder` ASC [ RunTime:0.002646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12748839 ORDER BY `unit` DESC [ RunTime:0.006719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12748839 LIMIT 2 [ RunTime:0.002815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748839 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12747638 LIMIT 5 [ RunTime:0.002089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12747638 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12747638 ORDER BY `unit` DESC [ RunTime:0.000313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12747638 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12747638 ORDER BY `minOrder` ASC [ RunTime:0.002895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746296 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746296 ORDER BY `minOrder` ASC [ RunTime:0.000991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12746296 ORDER BY `unit` DESC [ RunTime:0.006318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12746296 LIMIT 2 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746296 ORDER BY `minOrder` ASC [ RunTime:0.003289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12745140 LIMIT 5 [ RunTime:0.003340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745140 ORDER BY `minOrder` ASC [ RunTime:0.003878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12745140 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12745140 LIMIT 2 [ RunTime:0.007406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745140 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12745139 LIMIT 5 [ RunTime:0.004657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745139 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12745139 ORDER BY `unit` DESC [ RunTime:0.009742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12745139 LIMIT 2 [ RunTime:0.004363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745139 ORDER BY `minOrder` ASC [ RunTime:0.008534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12742204 LIMIT 5 [ RunTime:0.005728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742204 ORDER BY `minOrder` ASC [ RunTime:0.008966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12742204 ORDER BY `unit` DESC [ RunTime:0.002445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12742204 LIMIT 2 [ RunTime:0.007154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742204 ORDER BY `minOrder` ASC [ RunTime:0.001771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741113 LIMIT 5 [ RunTime:0.003042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741113 ORDER BY `minOrder` ASC [ RunTime:0.012578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12741113 ORDER BY `unit` DESC [ RunTime:0.010284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12741113 LIMIT 2 [ RunTime:0.006065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741113 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738015 LIMIT 5 [ RunTime:0.004027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738015 ORDER BY `minOrder` ASC [ RunTime:0.020828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12738015 ORDER BY `unit` DESC [ RunTime:0.000783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12738015 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738015 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579611 LIMIT 5 [ RunTime:0.001076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579611 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11579611 ORDER BY `unit` DESC [ RunTime:0.009607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11579611 LIMIT 2 [ RunTime:0.010291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579611 ORDER BY `minOrder` ASC [ RunTime:0.002258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579610 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579610 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11579610 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11579610 LIMIT 2 [ RunTime:0.008759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579610 ORDER BY `minOrder` ASC [ RunTime:0.001624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579482 LIMIT 5 [ RunTime:0.009563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579482 ORDER BY `minOrder` ASC [ RunTime:0.002639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11579482 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11579482 LIMIT 2 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579482 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11578820 LIMIT 5 [ RunTime:0.003516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11578820 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11578820 ORDER BY `unit` DESC [ RunTime:0.026354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11578820 LIMIT 2 [ RunTime:0.026037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11578820 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001263s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59727500 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59727500 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59727500 ORDER BY `unit` DESC [ RunTime:0.002934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59727500 LIMIT 2 [ RunTime:0.003189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59727500 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001851s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000814s ]
SELECT `id` FROM `stock` WHERE `id` <> 59727500 AND `partno` = 'FTSH-125-01-LM-DV-EJ-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59717925 LIMIT 5 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59717925 ORDER BY `minOrder` ASC [ RunTime:0.003367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59717925 ORDER BY `unit` DESC [ RunTime:0.006119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59717925 LIMIT 2 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59717925 ORDER BY `minOrder` ASC [ RunTime:0.002826s ]
select * from pdf where partno='FTSH-125-01-LM-DH-C' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DH-C' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009160s ]
SELECT `id` FROM `stock` WHERE `id` <> 59717925 AND `partno` = 'FTSH-125-01-LM-DH-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759478 [ RunTime:0.001547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59713285 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59713285 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59713285 ORDER BY `unit` DESC [ RunTime:0.002509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59713285 LIMIT 2 [ RunTime:0.004602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59713285 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004168s ]
SELECT `id` FROM `stock` WHERE `id` <> 59713285 AND `partno` = 'FTSH-125-01-LM-DV-EJ-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12752477 [ RunTime:0.003793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59711394 LIMIT 5 [ RunTime:0.003509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711394 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59711394 ORDER BY `unit` DESC [ RunTime:0.003079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59711394 LIMIT 2 [ RunTime:0.003798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711394 ORDER BY `minOrder` ASC [ RunTime:0.004667s ]
select * from pdf where partno='FTSH-125-01-LM-DH-A-C' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DH-A-C' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014913s ]
SELECT `id` FROM `stock` WHERE `id` <> 59711394 AND `partno` = 'FTSH-125-01-LM-DH-A-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12751387 [ RunTime:0.000395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710368 LIMIT 5 [ RunTime:0.003156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710368 ORDER BY `minOrder` ASC [ RunTime:0.004181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710368 ORDER BY `unit` DESC [ RunTime:0.002180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710368 LIMIT 2 [ RunTime:0.008667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710368 ORDER BY `minOrder` ASC [ RunTime:0.003815s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005600s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710368 AND `partno` = 'FTSH-125-01-LM-DV-EJ-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579610 [ RunTime:0.000854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710319 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710319 ORDER BY `minOrder` ASC [ RunTime:0.022927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710319 ORDER BY `unit` DESC [ RunTime:0.003740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710319 LIMIT 2 [ RunTime:0.012887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710319 ORDER BY `minOrder` ASC [ RunTime:0.006448s ]
select * from pdf where partno='FTSH-125-01-LM-D-EJ-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-D-EJ-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002472s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710319 AND `partno` = 'FTSH-125-01-LM-D-EJ-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579611 [ RunTime:0.001236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710067 LIMIT 5 [ RunTime:0.000991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710067 ORDER BY `minOrder` ASC [ RunTime:0.021940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710067 ORDER BY `unit` DESC [ RunTime:0.001350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710067 LIMIT 2 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710067 ORDER BY `minOrder` ASC [ RunTime:0.002599s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004011s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710067 AND `partno` = 'FTSH-125-01-LM-DV-EJ-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576999 [ RunTime:0.017084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710021 LIMIT 5 [ RunTime:0.003541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710021 ORDER BY `minOrder` ASC [ RunTime:0.003963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710021 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710021 LIMIT 2 [ RunTime:0.002599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710021 ORDER BY `minOrder` ASC [ RunTime:0.006600s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000739s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710021 AND `partno` = 'FTSH-125-01-LM-DV-EJ-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579482 [ RunTime:0.001496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59708793 LIMIT 5 [ RunTime:0.010156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708793 ORDER BY `minOrder` ASC [ RunTime:0.003337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59708793 ORDER BY `unit` DESC [ RunTime:0.001293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59708793 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708793 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='FTSH-125-01-LM-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011826s ]
SELECT `id` FROM `stock` WHERE `id` <> 59708793 AND `partno` = 'FTSH-125-01-LM-DV-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11578820 [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59708721 LIMIT 5 [ RunTime:0.007618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708721 ORDER BY `minOrder` ASC [ RunTime:0.003826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59708721 ORDER BY `unit` DESC [ RunTime:0.002247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59708721 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708721 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
select * from pdf where partno='FTSH-125-01-LM-DH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000625s ]
SELECT `id` FROM `stock` WHERE `id` <> 59708721 AND `partno` = 'FTSH-125-01-LM-DH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749841 [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59708562 LIMIT 5 [ RunTime:0.005052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708562 ORDER BY `minOrder` ASC [ RunTime:0.016955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59708562 ORDER BY `unit` DESC [ RunTime:0.005837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59708562 LIMIT 2 [ RunTime:0.003004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708562 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000906s ]
SELECT `id` FROM `stock` WHERE `id` <> 59708562 AND `partno` = 'FTSH-125-01-LM-DV-EJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749697 [ RunTime:0.001699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59708483 LIMIT 5 [ RunTime:0.003581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708483 ORDER BY `minOrder` ASC [ RunTime:0.005139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59708483 ORDER BY `unit` DESC [ RunTime:0.003043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59708483 LIMIT 2 [ RunTime:0.001522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708483 ORDER BY `minOrder` ASC [ RunTime:0.001901s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000572s ]
SELECT `id` FROM `stock` WHERE `id` <> 59708483 AND `partno` = 'FTSH-125-01-LM-DV-EJ-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59707240 LIMIT 5 [ RunTime:0.001208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707240 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59707240 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59707240 LIMIT 2 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707240 ORDER BY `minOrder` ASC [ RunTime:0.005588s ]
select * from pdf where partno='FTSH-125-01-LM-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000764s ]
SELECT `id` FROM `stock` WHERE `id` <> 59707240 AND `partno` = 'FTSH-125-01-LM-DV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748840 [ RunTime:0.001223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59707239 LIMIT 5 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707239 ORDER BY `minOrder` ASC [ RunTime:0.003958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59707239 ORDER BY `unit` DESC [ RunTime:0.004590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59707239 LIMIT 2 [ RunTime:0.015892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707239 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
select * from pdf where partno='FTSH-125-01-LM-D-RA-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-D-RA-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000828s ]
SELECT `id` FROM `stock` WHERE `id` <> 59707239 AND `partno` = 'FTSH-125-01-LM-D-RA-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748839 [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705277 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705277 ORDER BY `minOrder` ASC [ RunTime:0.002846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705277 ORDER BY `unit` DESC [ RunTime:0.002558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705277 LIMIT 2 [ RunTime:0.001909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705277 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
select * from pdf where partno='FTSH-125-01-LM-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000473s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705277 AND `partno` = 'FTSH-125-01-LM-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12747638 [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59703599 LIMIT 5 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703599 ORDER BY `minOrder` ASC [ RunTime:0.007982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59703599 ORDER BY `unit` DESC [ RunTime:0.000843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59703599 LIMIT 2 [ RunTime:0.003399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703599 ORDER BY `minOrder` ASC [ RunTime:0.003583s ]
select * from pdf where partno='FTSH-125-01-LM-DV-EJ-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-EJ-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002469s ]
SELECT `id` FROM `stock` WHERE `id` <> 59703599 AND `partno` = 'FTSH-125-01-LM-DV-EJ-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573796 [ RunTime:0.001354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59703369 LIMIT 5 [ RunTime:0.009746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703369 ORDER BY `minOrder` ASC [ RunTime:0.007190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59703369 ORDER BY `unit` DESC [ RunTime:0.002476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59703369 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703369 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='FTSH-125-01-LM-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007163s ]
SELECT `id` FROM `stock` WHERE `id` <> 59703369 AND `partno` = 'FTSH-125-01-LM-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576482 [ RunTime:0.006312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59702946 LIMIT 5 [ RunTime:0.001716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702946 ORDER BY `minOrder` ASC [ RunTime:0.002177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59702946 ORDER BY `unit` DESC [ RunTime:0.001793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59702946 LIMIT 2 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702946 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='FTSH-125-01-LM-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000922s ]
SELECT `id` FROM `stock` WHERE `id` <> 59702946 AND `partno` = 'FTSH-125-01-LM-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746296 [ RunTime:0.003131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59701966 LIMIT 5 [ RunTime:0.002704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701966 ORDER BY `minOrder` ASC [ RunTime:0.021143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59701966 ORDER BY `unit` DESC [ RunTime:0.031830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59701966 LIMIT 2 [ RunTime:0.007389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701966 ORDER BY `minOrder` ASC [ RunTime:0.008055s ]
select * from pdf where partno='FTSH-125-01-LM-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000947s ]
SELECT `id` FROM `stock` WHERE `id` <> 59701966 AND `partno` = 'FTSH-125-01-LM-DV-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12742204 [ RunTime:0.010604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59700890 LIMIT 5 [ RunTime:0.012070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700890 ORDER BY `minOrder` ASC [ RunTime:0.012506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59700890 ORDER BY `unit` DESC [ RunTime:0.005763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59700890 LIMIT 2 [ RunTime:0.004178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700890 ORDER BY `minOrder` ASC [ RunTime:0.001508s ]
select * from pdf where partno='FTSH-125-01-LM-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-125-01-LM-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014211s ]
SELECT `id` FROM `stock` WHERE `id` <> 59700890 AND `partno` = 'FTSH-125-01-LM-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12745140 [ RunTime:0.000582s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002598s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001644s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002830s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001344s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002140s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000846s ]
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 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000929s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-125-01-LM-D%' OR `brand` LIKE 'FTSH-125-01-LM-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007435s ]