SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001458s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019853s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667205 LIMIT 5 [ RunTime:0.011466s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667205 ORDER BY `minOrder` ASC [ RunTime:0.014916s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12667205 ORDER BY `unit` DESC [ RunTime:0.003022s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12667205 LIMIT 2 [ RunTime:0.001920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667205 ORDER BY `minOrder` ASC [ RunTime:0.005849s ]
select * from pdf where partno='SSM-120-L-SV-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688661 LIMIT 5 [ RunTime:0.024348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688661 ORDER BY `minOrder` ASC [ RunTime:0.012262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12688661 ORDER BY `unit` DESC [ RunTime:0.043603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12688661 LIMIT 2 [ RunTime:0.036695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688661 ORDER BY `minOrder` ASC [ RunTime:0.001849s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688163 LIMIT 5 [ RunTime:0.050659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688163 ORDER BY `minOrder` ASC [ RunTime:0.056774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12688163 ORDER BY `unit` DESC [ RunTime:0.034039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12688163 LIMIT 2 [ RunTime:0.025496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688163 ORDER BY `minOrder` ASC [ RunTime:0.019123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672497 LIMIT 5 [ RunTime:0.077063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672497 ORDER BY `minOrder` ASC [ RunTime:0.129880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12672497 ORDER BY `unit` DESC [ RunTime:0.056005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12672497 LIMIT 2 [ RunTime:0.083269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672497 ORDER BY `minOrder` ASC [ RunTime:0.008998s ]
select * from pdf where partno='SSM-120-L-SV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.049533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12668906 LIMIT 5 [ RunTime:0.026390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12668906 ORDER BY `minOrder` ASC [ RunTime:0.082898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12668906 ORDER BY `unit` DESC [ RunTime:0.066218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12668906 LIMIT 2 [ RunTime:0.029901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12668906 ORDER BY `minOrder` ASC [ RunTime:0.012047s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663250 LIMIT 5 [ RunTime:0.035413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663250 ORDER BY `minOrder` ASC [ RunTime:0.022397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12663250 ORDER BY `unit` DESC [ RunTime:0.035838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12663250 LIMIT 2 [ RunTime:0.028916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663250 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
select * from pdf where partno='SSM-120-L-SV-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.049518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534686 LIMIT 5 [ RunTime:0.041554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534686 ORDER BY `minOrder` ASC [ RunTime:0.036298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11534686 ORDER BY `unit` DESC [ RunTime:0.018648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11534686 LIMIT 2 [ RunTime:0.006420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534686 ORDER BY `minOrder` ASC [ RunTime:0.006999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533477 LIMIT 5 [ RunTime:0.026341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533477 ORDER BY `minOrder` ASC [ RunTime:0.018342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11533477 ORDER BY `unit` DESC [ RunTime:0.058794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11533477 LIMIT 2 [ RunTime:0.049499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533477 ORDER BY `minOrder` ASC [ RunTime:0.016710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517846 LIMIT 5 [ RunTime:0.019847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517846 ORDER BY `minOrder` ASC [ RunTime:0.008347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11517846 ORDER BY `unit` DESC [ RunTime:0.015928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11517846 LIMIT 2 [ RunTime:0.074787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517846 ORDER BY `minOrder` ASC [ RunTime:0.008986s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.045314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11513586 LIMIT 5 [ RunTime:0.023746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11513586 ORDER BY `minOrder` ASC [ RunTime:0.034368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11513586 ORDER BY `unit` DESC [ RunTime:0.031122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11513586 LIMIT 2 [ RunTime:0.055040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11513586 ORDER BY `minOrder` ASC [ RunTime:0.023104s ]
select * from pdf where partno='SSM-120-L-SV-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039493s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034253s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753094 LIMIT 5 [ RunTime:0.025825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753094 ORDER BY `minOrder` ASC [ RunTime:0.043747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753094 ORDER BY `unit` DESC [ RunTime:0.052699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753094 LIMIT 2 [ RunTime:0.047883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753094 ORDER BY `minOrder` ASC [ RunTime:0.009834s ]
select * from pdf where partno='SSM-120-L-SV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008070s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003459s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753094 AND `partno` = 'SSM-120-L-SV-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672497 [ RunTime:0.066608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59774998 LIMIT 5 [ RunTime:0.015791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59774998 ORDER BY `minOrder` ASC [ RunTime:0.051830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59774998 ORDER BY `unit` DESC [ RunTime:0.031579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59774998 LIMIT 2 [ RunTime:0.059897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59774998 ORDER BY `minOrder` ASC [ RunTime:0.014501s ]
select * from pdf where partno='SSM-120-L-SV-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030197s ]
SELECT `id` FROM `stock` WHERE `id` <> 59774998 AND `partno` = 'SSM-120-L-SV-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.068080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667205 [ RunTime:0.031792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59820733 LIMIT 5 [ RunTime:0.050396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820733 ORDER BY `minOrder` ASC [ RunTime:0.020931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59820733 ORDER BY `unit` DESC [ RunTime:0.038442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59820733 LIMIT 2 [ RunTime:0.031285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820733 ORDER BY `minOrder` ASC [ RunTime:0.001291s ]
select * from pdf where partno='SSM-120-L-SV-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015374s ]
SELECT `id` FROM `stock` WHERE `id` <> 59820733 AND `partno` = 'SSM-120-L-SV-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59820215 LIMIT 5 [ RunTime:0.031443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820215 ORDER BY `minOrder` ASC [ RunTime:0.015251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59820215 ORDER BY `unit` DESC [ RunTime:0.024210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59820215 LIMIT 2 [ RunTime:0.043019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820215 ORDER BY `minOrder` ASC [ RunTime:0.033546s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023469s ]
SELECT `id` FROM `stock` WHERE `id` <> 59820215 AND `partno` = 'SSM-120-L-SV-BE-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.046262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688661 [ RunTime:0.068405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59818678 LIMIT 5 [ RunTime:0.011537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59818678 ORDER BY `minOrder` ASC [ RunTime:0.033309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59818678 ORDER BY `unit` DESC [ RunTime:0.039227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59818678 LIMIT 2 [ RunTime:0.053863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59818678 ORDER BY `minOrder` ASC [ RunTime:0.017362s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028278s ]
SELECT `id` FROM `stock` WHERE `id` <> 59818678 AND `partno` = 'SSM-120-L-SV-BE-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.038394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688163 [ RunTime:0.017698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59816932 LIMIT 5 [ RunTime:0.011413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59816932 ORDER BY `minOrder` ASC [ RunTime:0.011723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59816932 ORDER BY `unit` DESC [ RunTime:0.035091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59816932 LIMIT 2 [ RunTime:0.021790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59816932 ORDER BY `minOrder` ASC [ RunTime:0.004001s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-LC-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020830s ]
SELECT `id` FROM `stock` WHERE `id` <> 59816932 AND `partno` = 'SSM-120-L-SV-BE-LC-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534686 [ RunTime:0.007610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59813217 LIMIT 5 [ RunTime:0.014053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813217 ORDER BY `minOrder` ASC [ RunTime:0.026995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59813217 ORDER BY `unit` DESC [ RunTime:0.024215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59813217 LIMIT 2 [ RunTime:0.015061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813217 ORDER BY `minOrder` ASC [ RunTime:0.023132s ]
select * from pdf where partno='SSM-120-L-SV-BE-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007126s ]
SELECT `id` FROM `stock` WHERE `id` <> 59813217 AND `partno` = 'SSM-120-L-SV-BE-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533477 [ RunTime:0.017736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59778594 LIMIT 5 [ RunTime:0.014021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59778594 ORDER BY `minOrder` ASC [ RunTime:0.021646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59778594 ORDER BY `unit` DESC [ RunTime:0.008383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59778594 LIMIT 2 [ RunTime:0.006928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59778594 ORDER BY `minOrder` ASC [ RunTime:0.002017s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002949s ]
SELECT `id` FROM `stock` WHERE `id` <> 59778594 AND `partno` = 'SSM-120-L-SV-BE-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12668906 [ RunTime:0.017036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59766679 LIMIT 5 [ RunTime:0.014196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766679 ORDER BY `minOrder` ASC [ RunTime:0.003791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59766679 ORDER BY `unit` DESC [ RunTime:0.009999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59766679 LIMIT 2 [ RunTime:0.011153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766679 ORDER BY `minOrder` ASC [ RunTime:0.011271s ]
select * from pdf where partno='SSM-120-L-SV-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010862s ]
SELECT `id` FROM `stock` WHERE `id` <> 59766679 AND `partno` = 'SSM-120-L-SV-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663250 [ RunTime:0.007575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59766652 LIMIT 5 [ RunTime:0.011164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766652 ORDER BY `minOrder` ASC [ RunTime:0.023177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59766652 ORDER BY `unit` DESC [ RunTime:0.034688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59766652 LIMIT 2 [ RunTime:0.042041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766652 ORDER BY `minOrder` ASC [ RunTime:0.040224s ]
select * from pdf where partno='SSM-120-L-SV-BE-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010662s ]
SELECT `id` FROM `stock` WHERE `id` <> 59766652 AND `partno` = 'SSM-120-L-SV-BE-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517846 [ RunTime:0.028013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59762697 LIMIT 5 [ RunTime:0.007666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762697 ORDER BY `minOrder` ASC [ RunTime:0.009079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59762697 ORDER BY `unit` DESC [ RunTime:0.034814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59762697 LIMIT 2 [ RunTime:0.014089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762697 ORDER BY `minOrder` ASC [ RunTime:0.004241s ]
select * from pdf where partno='SSM-120-L-SV-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-120-L-SV-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014306s ]
SELECT `id` FROM `stock` WHERE `id` <> 59762697 AND `partno` = 'SSM-120-L-SV-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11513586 [ RunTime:0.004353s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018901s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005563s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025555s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007548s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003934s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003737s ]
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-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009551s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSM-120-L-SV-BE%' OR `brand` LIKE 'SSM-120-L-SV-BE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002312s ]