SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002069s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016767s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12703158 LIMIT 5 [ RunTime:0.003019s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12703158 ORDER BY `minOrder` ASC [ RunTime:0.005820s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12703158 ORDER BY `unit` DESC [ RunTime:0.007546s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12703158 LIMIT 2 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12703158 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12702213 LIMIT 5 [ RunTime:0.009129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12702213 ORDER BY `minOrder` ASC [ RunTime:0.004111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12702213 ORDER BY `unit` DESC [ RunTime:0.017270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12702213 LIMIT 2 [ RunTime:0.020984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12702213 ORDER BY `minOrder` ASC [ RunTime:0.034039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12702053 LIMIT 5 [ RunTime:0.007668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12702053 ORDER BY `minOrder` ASC [ RunTime:0.011516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12702053 ORDER BY `unit` DESC [ RunTime:0.013441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12702053 LIMIT 2 [ RunTime:0.014713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12702053 ORDER BY `minOrder` ASC [ RunTime:0.010594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12696813 LIMIT 5 [ RunTime:0.010925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12696813 ORDER BY `minOrder` ASC [ RunTime:0.040313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12696813 ORDER BY `unit` DESC [ RunTime:0.034172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12696813 LIMIT 2 [ RunTime:0.003836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12696813 ORDER BY `minOrder` ASC [ RunTime:0.009863s ]
select * from pdf where partno='SSM-114-S-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12696137 LIMIT 5 [ RunTime:0.022874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12696137 ORDER BY `minOrder` ASC [ RunTime:0.012776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12696137 ORDER BY `unit` DESC [ RunTime:0.010004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12696137 LIMIT 2 [ RunTime:0.003550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12696137 ORDER BY `minOrder` ASC [ RunTime:0.003917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12695545 LIMIT 5 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695545 ORDER BY `minOrder` ASC [ RunTime:0.005700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12695545 ORDER BY `unit` DESC [ RunTime:0.002875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12695545 LIMIT 2 [ RunTime:0.008116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695545 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12695440 LIMIT 5 [ RunTime:0.006359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695440 ORDER BY `minOrder` ASC [ RunTime:0.005749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12695440 ORDER BY `unit` DESC [ RunTime:0.003287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12695440 LIMIT 2 [ RunTime:0.006373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695440 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='SSM-114-S-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12695439 LIMIT 5 [ RunTime:0.004392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695439 ORDER BY `minOrder` ASC [ RunTime:0.008923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12695439 ORDER BY `unit` DESC [ RunTime:0.005160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12695439 LIMIT 2 [ RunTime:0.015530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695439 ORDER BY `minOrder` ASC [ RunTime:0.009449s ]
select * from pdf where partno='SSM-114-S-DV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694732 LIMIT 5 [ RunTime:0.004841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694732 ORDER BY `minOrder` ASC [ RunTime:0.004126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12694732 ORDER BY `unit` DESC [ RunTime:0.019469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12694732 LIMIT 2 [ RunTime:0.007661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694732 ORDER BY `minOrder` ASC [ RunTime:0.005957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663038 LIMIT 5 [ RunTime:0.009773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663038 ORDER BY `minOrder` ASC [ RunTime:0.007895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12663038 ORDER BY `unit` DESC [ RunTime:0.004606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12663038 LIMIT 2 [ RunTime:0.029263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663038 ORDER BY `minOrder` ASC [ RunTime:0.004094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662339 LIMIT 5 [ RunTime:0.005943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662339 ORDER BY `minOrder` ASC [ RunTime:0.002293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12662339 ORDER BY `unit` DESC [ RunTime:0.009857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12662339 LIMIT 2 [ RunTime:0.002256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662339 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='SSM-114-S-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11543892 LIMIT 5 [ RunTime:0.017451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11543892 ORDER BY `minOrder` ASC [ RunTime:0.007828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11543892 ORDER BY `unit` DESC [ RunTime:0.004781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11543892 LIMIT 2 [ RunTime:0.014559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11543892 ORDER BY `minOrder` ASC [ RunTime:0.008622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517449 LIMIT 5 [ RunTime:0.008030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517449 ORDER BY `minOrder` ASC [ RunTime:0.018397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11517449 ORDER BY `unit` DESC [ RunTime:0.006611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11517449 LIMIT 2 [ RunTime:0.017081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517449 ORDER BY `minOrder` ASC [ RunTime:0.005925s ]
select * from pdf where partno='SSM-114-S-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517434 LIMIT 5 [ RunTime:0.001786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517434 ORDER BY `minOrder` ASC [ RunTime:0.004168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11517434 ORDER BY `unit` DESC [ RunTime:0.000311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11517434 LIMIT 2 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517434 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001023s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59845304 LIMIT 5 [ RunTime:0.002852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845304 ORDER BY `minOrder` ASC [ RunTime:0.001618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59845304 ORDER BY `unit` DESC [ RunTime:0.000334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59845304 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845304 ORDER BY `minOrder` ASC [ RunTime:0.000201s ]
select * from pdf where partno='SSM-114-S-DV-BE-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000521s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003835s ]
SELECT `id` FROM `stock` WHERE `id` <> 59845304 AND `partno` = 'SSM-114-S-DV-BE-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59845303 LIMIT 5 [ RunTime:0.002276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845303 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59845303 ORDER BY `unit` DESC [ RunTime:0.000497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59845303 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845303 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='SSM-114-S-DV-BE-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004695s ]
SELECT `id` FROM `stock` WHERE `id` <> 59845303 AND `partno` = 'SSM-114-S-DV-BE-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59845302 LIMIT 5 [ RunTime:0.001114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845302 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59845302 ORDER BY `unit` DESC [ RunTime:0.007937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59845302 LIMIT 2 [ RunTime:0.002777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845302 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='SSM-114-S-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000794s ]
SELECT `id` FROM `stock` WHERE `id` <> 59845302 AND `partno` = 'SSM-114-S-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12703158 [ RunTime:0.006498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59844523 LIMIT 5 [ RunTime:0.004260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59844523 ORDER BY `minOrder` ASC [ RunTime:0.001171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59844523 ORDER BY `unit` DESC [ RunTime:0.008642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59844523 LIMIT 2 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59844523 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
select * from pdf where partno='SSM-114-S-DV-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000980s ]
SELECT `id` FROM `stock` WHERE `id` <> 59844523 AND `partno` = 'SSM-114-S-DV-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59843459 LIMIT 5 [ RunTime:0.003904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843459 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59843459 ORDER BY `unit` DESC [ RunTime:0.001398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59843459 LIMIT 2 [ RunTime:0.001424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843459 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='SSM-114-S-DV-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001064s ]
SELECT `id` FROM `stock` WHERE `id` <> 59843459 AND `partno` = 'SSM-114-S-DV-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12702213 [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59842961 LIMIT 5 [ RunTime:0.002812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842961 ORDER BY `minOrder` ASC [ RunTime:0.004249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59842961 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59842961 LIMIT 2 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842961 ORDER BY `minOrder` ASC [ RunTime:0.001126s ]
select * from pdf where partno='SSM-114-S-DV-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008947s ]
SELECT `id` FROM `stock` WHERE `id` <> 59842961 AND `partno` = 'SSM-114-S-DV-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12702053 [ RunTime:0.011212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59842564 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842564 ORDER BY `minOrder` ASC [ RunTime:0.001621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59842564 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59842564 LIMIT 2 [ RunTime:0.006597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842564 ORDER BY `minOrder` ASC [ RunTime:0.005119s ]
select * from pdf where partno='SSM-114-S-DV-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004326s ]
SELECT `id` FROM `stock` WHERE `id` <> 59842564 AND `partno` = 'SSM-114-S-DV-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59842563 LIMIT 5 [ RunTime:0.005977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842563 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59842563 ORDER BY `unit` DESC [ RunTime:0.005741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59842563 LIMIT 2 [ RunTime:0.001152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842563 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
select * from pdf where partno='SSM-114-S-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001294s ]
SELECT `id` FROM `stock` WHERE `id` <> 59842563 AND `partno` = 'SSM-114-S-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59841319 LIMIT 5 [ RunTime:0.008417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841319 ORDER BY `minOrder` ASC [ RunTime:0.004807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59841319 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59841319 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841319 ORDER BY `minOrder` ASC [ RunTime:0.001712s ]
select * from pdf where partno='SSM-114-S-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002385s ]
SELECT `id` FROM `stock` WHERE `id` <> 59841319 AND `partno` = 'SSM-114-S-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12696813 [ RunTime:0.004170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840802 LIMIT 5 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840802 ORDER BY `minOrder` ASC [ RunTime:0.002542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840802 ORDER BY `unit` DESC [ RunTime:0.001062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840802 LIMIT 2 [ RunTime:0.006747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840802 ORDER BY `minOrder` ASC [ RunTime:0.003519s ]
select * from pdf where partno='SSM-114-S-DV-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000772s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840802 AND `partno` = 'SSM-114-S-DV-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11543892 [ RunTime:0.011715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840125 LIMIT 5 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840125 ORDER BY `minOrder` ASC [ RunTime:0.001764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840125 ORDER BY `unit` DESC [ RunTime:0.001204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840125 LIMIT 2 [ RunTime:0.009380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840125 ORDER BY `minOrder` ASC [ RunTime:0.005768s ]
select * from pdf where partno='SSM-114-S-DV-006-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-006-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004142s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840125 AND `partno` = 'SSM-114-S-DV-006-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12696137 [ RunTime:0.002991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59839543 LIMIT 5 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839543 ORDER BY `minOrder` ASC [ RunTime:0.001933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59839543 ORDER BY `unit` DESC [ RunTime:0.002986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59839543 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839543 ORDER BY `minOrder` ASC [ RunTime:0.004394s ]
select * from pdf where partno='SSM-114-S-DV-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001322s ]
SELECT `id` FROM `stock` WHERE `id` <> 59839543 AND `partno` = 'SSM-114-S-DV-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59838924 LIMIT 5 [ RunTime:0.002328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59838924 ORDER BY `minOrder` ASC [ RunTime:0.001082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59838924 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59838924 LIMIT 2 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59838924 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
select * from pdf where partno='SSM-114-S-DV-BE-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000549s ]
SELECT `id` FROM `stock` WHERE `id` <> 59838924 AND `partno` = 'SSM-114-S-DV-BE-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12695545 [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59838662 LIMIT 5 [ RunTime:0.003725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59838662 ORDER BY `minOrder` ASC [ RunTime:0.004431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59838662 ORDER BY `unit` DESC [ RunTime:0.001578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59838662 LIMIT 2 [ RunTime:0.001563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59838662 ORDER BY `minOrder` ASC [ RunTime:0.001969s ]
select * from pdf where partno='SSM-114-S-DV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000452s ]
SELECT `id` FROM `stock` WHERE `id` <> 59838662 AND `partno` = 'SSM-114-S-DV-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12695439 [ RunTime:0.001586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59837410 LIMIT 5 [ RunTime:0.002518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59837410 ORDER BY `minOrder` ASC [ RunTime:0.003131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59837410 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59837410 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59837410 ORDER BY `minOrder` ASC [ RunTime:0.001662s ]
select * from pdf where partno='SSM-114-S-DV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001654s ]
SELECT `id` FROM `stock` WHERE `id` <> 59837410 AND `partno` = 'SSM-114-S-DV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694732 [ RunTime:0.001079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59836984 LIMIT 5 [ RunTime:0.001732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59836984 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59836984 ORDER BY `unit` DESC [ RunTime:0.001054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59836984 LIMIT 2 [ RunTime:0.002507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59836984 ORDER BY `minOrder` ASC [ RunTime:0.000175s ]
select * from pdf where partno='SSM-114-S-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000737s ]
SELECT `id` FROM `stock` WHERE `id` <> 59836984 AND `partno` = 'SSM-114-S-DV-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12695440 [ RunTime:0.000285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59780289 LIMIT 5 [ RunTime:0.000266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59780289 ORDER BY `minOrder` ASC [ RunTime:0.002144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59780289 ORDER BY `unit` DESC [ RunTime:0.004051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59780289 LIMIT 2 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59780289 ORDER BY `minOrder` ASC [ RunTime:0.000194s ]
select * from pdf where partno='SSM-114-S-DV-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000415s ]
SELECT `id` FROM `stock` WHERE `id` <> 59780289 AND `partno` = 'SSM-114-S-DV-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59766282 LIMIT 5 [ RunTime:0.001823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766282 ORDER BY `minOrder` ASC [ RunTime:0.001761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59766282 ORDER BY `unit` DESC [ RunTime:0.000258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59766282 LIMIT 2 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766282 ORDER BY `minOrder` ASC [ RunTime:0.000168s ]
select * from pdf where partno='SSM-114-S-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000383s ]
SELECT `id` FROM `stock` WHERE `id` <> 59766282 AND `partno` = 'SSM-114-S-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663038 [ RunTime:0.009448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59764594 LIMIT 5 [ RunTime:0.002276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59764594 ORDER BY `minOrder` ASC [ RunTime:0.001891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59764594 ORDER BY `unit` DESC [ RunTime:0.003391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59764594 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59764594 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
select * from pdf where partno='SSM-114-S-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002504s ]
SELECT `id` FROM `stock` WHERE `id` <> 59764594 AND `partno` = 'SSM-114-S-DV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517449 [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59764552 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59764552 ORDER BY `minOrder` ASC [ RunTime:0.001510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59764552 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59764552 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59764552 ORDER BY `minOrder` ASC [ RunTime:0.000199s ]
select * from pdf where partno='SSM-114-S-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-114-S-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001708s ]
SELECT `id` FROM `stock` WHERE `id` <> 59764552 AND `partno` = 'SSM-114-S-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517434 [ RunTime:0.011372s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000832s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001553s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001442s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001006s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000996s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000804s ]
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-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001825s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSM-114-S-DV%' OR `brand` LIKE 'SSM-114-S-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001167s ]