SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001618s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029775s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684319 LIMIT 5 [ RunTime:0.027282s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684319 ORDER BY `minOrder` ASC [ RunTime:0.031838s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684319 ORDER BY `unit` DESC [ RunTime:0.010632s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684319 LIMIT 2 [ RunTime:0.025631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684319 ORDER BY `minOrder` ASC [ RunTime:0.015837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683482 LIMIT 5 [ RunTime:0.026274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683482 ORDER BY `minOrder` ASC [ RunTime:0.024829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12683482 ORDER BY `unit` DESC [ RunTime:0.019315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12683482 LIMIT 2 [ RunTime:0.024974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683482 ORDER BY `minOrder` ASC [ RunTime:0.011957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683481 LIMIT 5 [ RunTime:0.020127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683481 ORDER BY `minOrder` ASC [ RunTime:0.020564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12683481 ORDER BY `unit` DESC [ RunTime:0.030880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12683481 LIMIT 2 [ RunTime:0.060826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683481 ORDER BY `minOrder` ASC [ RunTime:0.005315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681652 LIMIT 5 [ RunTime:0.022016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681652 ORDER BY `minOrder` ASC [ RunTime:0.045181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12681652 ORDER BY `unit` DESC [ RunTime:0.049769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12681652 LIMIT 2 [ RunTime:0.048497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681652 ORDER BY `minOrder` ASC [ RunTime:0.002724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681286 LIMIT 5 [ RunTime:0.009803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681286 ORDER BY `minOrder` ASC [ RunTime:0.031600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12681286 ORDER BY `unit` DESC [ RunTime:0.050210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12681286 LIMIT 2 [ RunTime:0.033539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681286 ORDER BY `minOrder` ASC [ RunTime:0.018913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678937 LIMIT 5 [ RunTime:0.027351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678937 ORDER BY `minOrder` ASC [ RunTime:0.040010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12678937 ORDER BY `unit` DESC [ RunTime:0.034718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12678937 LIMIT 2 [ RunTime:0.030083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678937 ORDER BY `minOrder` ASC [ RunTime:0.024602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678222 LIMIT 5 [ RunTime:0.016550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678222 ORDER BY `minOrder` ASC [ RunTime:0.024817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12678222 ORDER BY `unit` DESC [ RunTime:0.018792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12678222 LIMIT 2 [ RunTime:0.018162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678222 ORDER BY `minOrder` ASC [ RunTime:0.009872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678158 LIMIT 5 [ RunTime:0.035802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678158 ORDER BY `minOrder` ASC [ RunTime:0.007065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12678158 ORDER BY `unit` DESC [ RunTime:0.002524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12678158 LIMIT 2 [ RunTime:0.003084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678158 ORDER BY `minOrder` ASC [ RunTime:0.009892s ]
select * from pdf where partno='SSM-110-F-SV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662330 LIMIT 5 [ RunTime:0.003622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662330 ORDER BY `minOrder` ASC [ RunTime:0.004209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12662330 ORDER BY `unit` DESC [ RunTime:0.025143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12662330 LIMIT 2 [ RunTime:0.013382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662330 ORDER BY `minOrder` ASC [ RunTime:0.004633s ]
select * from pdf where partno='SSM-110-F-SV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517072 LIMIT 5 [ RunTime:0.002585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517072 ORDER BY `minOrder` ASC [ RunTime:0.007632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11517072 ORDER BY `unit` DESC [ RunTime:0.004533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11517072 LIMIT 2 [ RunTime:0.003094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517072 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11506000 LIMIT 5 [ RunTime:0.009786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11506000 ORDER BY `minOrder` ASC [ RunTime:0.005647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11506000 ORDER BY `unit` DESC [ RunTime:0.005678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11506000 LIMIT 2 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11506000 ORDER BY `minOrder` ASC [ RunTime:0.002014s ]
select * from pdf where partno='SSM-110-F-SV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11504932 LIMIT 5 [ RunTime:0.003083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11504932 ORDER BY `minOrder` ASC [ RunTime:0.001648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11504932 ORDER BY `unit` DESC [ RunTime:0.007936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11504932 LIMIT 2 [ RunTime:0.004641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11504932 ORDER BY `minOrder` ASC [ RunTime:0.001228s ]
select * from pdf where partno='SSM-110-F-SV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001387s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002384s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59808445 LIMIT 5 [ RunTime:0.001783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808445 ORDER BY `minOrder` ASC [ RunTime:0.004520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59808445 ORDER BY `unit` DESC [ RunTime:0.002426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59808445 LIMIT 2 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808445 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='SSM-110-F-SV-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003095s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001101s ]
SELECT `id` FROM `stock` WHERE `id` <> 59808445 AND `partno` = 'SSM-110-F-SV-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59808034 LIMIT 5 [ RunTime:0.005433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808034 ORDER BY `minOrder` ASC [ RunTime:0.006453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59808034 ORDER BY `unit` DESC [ RunTime:0.011277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59808034 LIMIT 2 [ RunTime:0.009906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808034 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
select * from pdf where partno='SSM-110-F-SV-BE-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-BE-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005289s ]
SELECT `id` FROM `stock` WHERE `id` <> 59808034 AND `partno` = 'SSM-110-F-SV-BE-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59806010 LIMIT 5 [ RunTime:0.003080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806010 ORDER BY `minOrder` ASC [ RunTime:0.011521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59806010 ORDER BY `unit` DESC [ RunTime:0.003130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59806010 LIMIT 2 [ RunTime:0.001679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806010 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='SSM-110-F-SV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011167s ]
SELECT `id` FROM `stock` WHERE `id` <> 59806010 AND `partno` = 'SSM-110-F-SV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684319 [ RunTime:0.004848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59804376 LIMIT 5 [ RunTime:0.002596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59804376 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59804376 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59804376 LIMIT 2 [ RunTime:0.002884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59804376 ORDER BY `minOrder` ASC [ RunTime:0.006252s ]
select * from pdf where partno='SSM-110-F-SV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001348s ]
SELECT `id` FROM `stock` WHERE `id` <> 59804376 AND `partno` = 'SSM-110-F-SV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683482 [ RunTime:0.013485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59804375 LIMIT 5 [ RunTime:0.004448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59804375 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59804375 ORDER BY `unit` DESC [ RunTime:0.004579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59804375 LIMIT 2 [ RunTime:0.000875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59804375 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='SSM-110-F-SV-BE-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-BE-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000517s ]
SELECT `id` FROM `stock` WHERE `id` <> 59804375 AND `partno` = 'SSM-110-F-SV-BE-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683481 [ RunTime:0.003967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59801422 LIMIT 5 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59801422 ORDER BY `minOrder` ASC [ RunTime:0.009266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59801422 ORDER BY `unit` DESC [ RunTime:0.002757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59801422 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59801422 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
select * from pdf where partno='SSM-110-F-SV-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003281s ]
SELECT `id` FROM `stock` WHERE `id` <> 59801422 AND `partno` = 'SSM-110-F-SV-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681652 [ RunTime:0.007399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59800712 LIMIT 5 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59800712 ORDER BY `minOrder` ASC [ RunTime:0.011996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59800712 ORDER BY `unit` DESC [ RunTime:0.006284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59800712 LIMIT 2 [ RunTime:0.002808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59800712 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='SSM-110-F-SV-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001977s ]
SELECT `id` FROM `stock` WHERE `id` <> 59800712 AND `partno` = 'SSM-110-F-SV-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681286 [ RunTime:0.002970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59799507 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59799507 ORDER BY `minOrder` ASC [ RunTime:0.007139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59799507 ORDER BY `unit` DESC [ RunTime:0.002104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59799507 LIMIT 2 [ RunTime:0.001531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59799507 ORDER BY `minOrder` ASC [ RunTime:0.005425s ]
select * from pdf where partno='SSM-110-F-SV-BE-LC-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-BE-LC-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005853s ]
SELECT `id` FROM `stock` WHERE `id` <> 59799507 AND `partno` = 'SSM-110-F-SV-BE-LC-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59797078 LIMIT 5 [ RunTime:0.005938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59797078 ORDER BY `minOrder` ASC [ RunTime:0.002641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59797078 ORDER BY `unit` DESC [ RunTime:0.002336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59797078 LIMIT 2 [ RunTime:0.001606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59797078 ORDER BY `minOrder` ASC [ RunTime:0.005563s ]
select * from pdf where partno='SSM-110-F-SV-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002711s ]
SELECT `id` FROM `stock` WHERE `id` <> 59797078 AND `partno` = 'SSM-110-F-SV-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678937 [ RunTime:0.012997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59797028 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59797028 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59797028 ORDER BY `unit` DESC [ RunTime:0.011179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59797028 LIMIT 2 [ RunTime:0.004786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59797028 ORDER BY `minOrder` ASC [ RunTime:0.002511s ]
select * from pdf where partno='SSM-110-F-SV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002254s ]
SELECT `id` FROM `stock` WHERE `id` <> 59797028 AND `partno` = 'SSM-110-F-SV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678222 [ RunTime:0.007347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59795877 LIMIT 5 [ RunTime:0.001905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59795877 ORDER BY `minOrder` ASC [ RunTime:0.017234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59795877 ORDER BY `unit` DESC [ RunTime:0.003099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59795877 LIMIT 2 [ RunTime:0.011399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59795877 ORDER BY `minOrder` ASC [ RunTime:0.002349s ]
select * from pdf where partno='SSM-110-F-SV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006088s ]
SELECT `id` FROM `stock` WHERE `id` <> 59795877 AND `partno` = 'SSM-110-F-SV-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678158 [ RunTime:0.001932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59765311 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765311 ORDER BY `minOrder` ASC [ RunTime:0.001547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59765311 ORDER BY `unit` DESC [ RunTime:0.003363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59765311 LIMIT 2 [ RunTime:0.006207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765311 ORDER BY `minOrder` ASC [ RunTime:0.004829s ]
select * from pdf where partno='SSM-110-F-SV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002932s ]
SELECT `id` FROM `stock` WHERE `id` <> 59765311 AND `partno` = 'SSM-110-F-SV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662330 [ RunTime:0.006553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59765185 LIMIT 5 [ RunTime:0.006232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765185 ORDER BY `minOrder` ASC [ RunTime:0.001313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59765185 ORDER BY `unit` DESC [ RunTime:0.003433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59765185 LIMIT 2 [ RunTime:0.004825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765185 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='SSM-110-F-SV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004539s ]
SELECT `id` FROM `stock` WHERE `id` <> 59765185 AND `partno` = 'SSM-110-F-SV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517072 [ RunTime:0.001839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59762337 LIMIT 5 [ RunTime:0.007253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762337 ORDER BY `minOrder` ASC [ RunTime:0.001149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59762337 ORDER BY `unit` DESC [ RunTime:0.008211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59762337 LIMIT 2 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762337 ORDER BY `minOrder` ASC [ RunTime:0.004406s ]
select * from pdf where partno='SSM-110-F-SV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004296s ]
SELECT `id` FROM `stock` WHERE `id` <> 59762337 AND `partno` = 'SSM-110-F-SV-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11506000 [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59762030 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762030 ORDER BY `minOrder` ASC [ RunTime:0.000988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59762030 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59762030 LIMIT 2 [ RunTime:0.002830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762030 ORDER BY `minOrder` ASC [ RunTime:0.000806s ]
select * from pdf where partno='SSM-110-F-SV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-110-F-SV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000614s ]
SELECT `id` FROM `stock` WHERE `id` <> 59762030 AND `partno` = 'SSM-110-F-SV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11504932 [ RunTime:0.011016s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002372s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002958s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003976s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002905s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002361s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007857s ]
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 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003732s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSM-110-F-SV%' OR `brand` LIKE 'SSM-110-F-SV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001914s ]