SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001275s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026882s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20010477 LIMIT 5 [ RunTime:0.036857s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20010477 ORDER BY `minOrder` ASC [ RunTime:0.008192s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20010477 ORDER BY `unit` DESC [ RunTime:0.014489s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20010477 LIMIT 2 [ RunTime:0.018437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20010477 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
select * from pdf where partno='MEC6-110-02-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.043679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17363611 LIMIT 5 [ RunTime:0.026066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17363611 ORDER BY `minOrder` ASC [ RunTime:0.013071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17363611 ORDER BY `unit` DESC [ RunTime:0.031352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17363611 LIMIT 2 [ RunTime:0.071489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17363611 ORDER BY `minOrder` ASC [ RunTime:0.036383s ]
select * from pdf where partno='MEC6-110-02-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17367177 LIMIT 5 [ RunTime:0.034453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17367177 ORDER BY `minOrder` ASC [ RunTime:0.062653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17367177 ORDER BY `unit` DESC [ RunTime:0.019305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17367177 LIMIT 2 [ RunTime:0.035017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17367177 ORDER BY `minOrder` ASC [ RunTime:0.033939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16245484 LIMIT 5 [ RunTime:0.047356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16245484 ORDER BY `minOrder` ASC [ RunTime:0.040850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16245484 ORDER BY `unit` DESC [ RunTime:0.045400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16245484 LIMIT 2 [ RunTime:0.025699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16245484 ORDER BY `minOrder` ASC [ RunTime:0.014693s ]
select * from pdf where partno='MEC6-110-02-L-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12847843 LIMIT 5 [ RunTime:0.030594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12847843 ORDER BY `minOrder` ASC [ RunTime:0.008914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12847843 ORDER BY `unit` DESC [ RunTime:0.014629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12847843 LIMIT 2 [ RunTime:0.015699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12847843 ORDER BY `minOrder` ASC [ RunTime:0.019851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12833905 LIMIT 5 [ RunTime:0.007499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12833905 ORDER BY `minOrder` ASC [ RunTime:0.026261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12833905 ORDER BY `unit` DESC [ RunTime:0.034445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12833905 LIMIT 2 [ RunTime:0.034066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12833905 ORDER BY `minOrder` ASC [ RunTime:0.009304s ]
select * from pdf where partno='MEC6-110-02-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11649079 LIMIT 5 [ RunTime:0.024227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11649079 ORDER BY `minOrder` ASC [ RunTime:0.010689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11649079 ORDER BY `unit` DESC [ RunTime:0.010672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11649079 LIMIT 2 [ RunTime:0.030352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11649079 ORDER BY `minOrder` ASC [ RunTime:0.019476s ]
select * from pdf where partno='MEC6-110-02-L-DV-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11647010 LIMIT 5 [ RunTime:0.028608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11647010 ORDER BY `minOrder` ASC [ RunTime:0.033801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11647010 ORDER BY `unit` DESC [ RunTime:0.009535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11647010 LIMIT 2 [ RunTime:0.026683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11647010 ORDER BY `minOrder` ASC [ RunTime:0.003243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11647009 LIMIT 5 [ RunTime:0.003327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11647009 ORDER BY `minOrder` ASC [ RunTime:0.025355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11647009 ORDER BY `unit` DESC [ RunTime:0.013498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11647009 LIMIT 2 [ RunTime:0.005757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11647009 ORDER BY `minOrder` ASC [ RunTime:0.009059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11640644 LIMIT 5 [ RunTime:0.024111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11640644 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11640644 ORDER BY `unit` DESC [ RunTime:0.013862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11640644 LIMIT 2 [ RunTime:0.011110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11640644 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008253s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58734808 LIMIT 5 [ RunTime:0.002397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734808 ORDER BY `minOrder` ASC [ RunTime:0.008983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58734808 ORDER BY `unit` DESC [ RunTime:0.000777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58734808 LIMIT 2 [ RunTime:0.002718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734808 ORDER BY `minOrder` ASC [ RunTime:0.002943s ]
select * from pdf where partno='MEC6-110-02-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002098s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001054s ]
SELECT `id` FROM `stock` WHERE `id` <> 58734808 AND `partno` = 'MEC6-110-02-L-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17363611 [ RunTime:0.016994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58734722 LIMIT 5 [ RunTime:0.003191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734722 ORDER BY `minOrder` ASC [ RunTime:0.000961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58734722 ORDER BY `unit` DESC [ RunTime:0.003632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58734722 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734722 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='MEC6-110-02-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006732s ]
SELECT `id` FROM `stock` WHERE `id` <> 58734722 AND `partno` = 'MEC6-110-02-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20010477 [ RunTime:0.007183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58766721 LIMIT 5 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58766721 ORDER BY `minOrder` ASC [ RunTime:0.003442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58766721 ORDER BY `unit` DESC [ RunTime:0.001289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58766721 LIMIT 2 [ RunTime:0.001458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58766721 ORDER BY `minOrder` ASC [ RunTime:0.001665s ]
select * from pdf where partno='MEC6-110-02-L-DV-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000542s ]
SELECT `id` FROM `stock` WHERE `id` <> 58766721 AND `partno` = 'MEC6-110-02-L-DV-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11649079 [ RunTime:0.005276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58765614 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58765614 ORDER BY `minOrder` ASC [ RunTime:0.003681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58765614 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58765614 LIMIT 2 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58765614 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
select * from pdf where partno='MEC6-110-02-L-DV-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-LC-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002153s ]
SELECT `id` FROM `stock` WHERE `id` <> 58765614 AND `partno` = 'MEC6-110-02-L-DV-LC-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58762803 LIMIT 5 [ RunTime:0.005933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762803 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58762803 ORDER BY `unit` DESC [ RunTime:0.005609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58762803 LIMIT 2 [ RunTime:0.003645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762803 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='MEC6-110-02-L-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000683s ]
SELECT `id` FROM `stock` WHERE `id` <> 58762803 AND `partno` = 'MEC6-110-02-L-DV-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11640644 [ RunTime:0.002574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58762783 LIMIT 5 [ RunTime:0.012248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762783 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58762783 ORDER BY `unit` DESC [ RunTime:0.011828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58762783 LIMIT 2 [ RunTime:0.002216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762783 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='MEC6-110-02-L-DV-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000822s ]
SELECT `id` FROM `stock` WHERE `id` <> 58762783 AND `partno` = 'MEC6-110-02-L-DV-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58762540 LIMIT 5 [ RunTime:0.008877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762540 ORDER BY `minOrder` ASC [ RunTime:0.009864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58762540 ORDER BY `unit` DESC [ RunTime:0.002877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58762540 LIMIT 2 [ RunTime:0.001229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762540 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='MEC6-110-02-L-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003521s ]
SELECT `id` FROM `stock` WHERE `id` <> 58762540 AND `partno` = 'MEC6-110-02-L-DV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12847843 [ RunTime:0.001679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58761249 LIMIT 5 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761249 ORDER BY `minOrder` ASC [ RunTime:0.010450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58761249 ORDER BY `unit` DESC [ RunTime:0.002053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58761249 LIMIT 2 [ RunTime:0.002575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761249 ORDER BY `minOrder` ASC [ RunTime:0.003476s ]
select * from pdf where partno='MEC6-110-02-L-DV-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001167s ]
SELECT `id` FROM `stock` WHERE `id` <> 58761249 AND `partno` = 'MEC6-110-02-L-DV-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11647010 [ RunTime:0.008127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58761248 LIMIT 5 [ RunTime:0.002865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761248 ORDER BY `minOrder` ASC [ RunTime:0.008932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58761248 ORDER BY `unit` DESC [ RunTime:0.001513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58761248 LIMIT 2 [ RunTime:0.002116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761248 ORDER BY `minOrder` ASC [ RunTime:0.014719s ]
select * from pdf where partno='MEC6-110-02-L-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006927s ]
SELECT `id` FROM `stock` WHERE `id` <> 58761248 AND `partno` = 'MEC6-110-02-L-DV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.026346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11647009 [ RunTime:0.024434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58760180 LIMIT 5 [ RunTime:0.036378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58760180 ORDER BY `minOrder` ASC [ RunTime:0.006720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58760180 ORDER BY `unit` DESC [ RunTime:0.004818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58760180 LIMIT 2 [ RunTime:0.022605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58760180 ORDER BY `minOrder` ASC [ RunTime:0.016381s ]
select * from pdf where partno='MEC6-110-02-L-DV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005569s ]
SELECT `id` FROM `stock` WHERE `id` <> 58760180 AND `partno` = 'MEC6-110-02-L-DV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58760139 LIMIT 5 [ RunTime:0.011565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58760139 ORDER BY `minOrder` ASC [ RunTime:0.036183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58760139 ORDER BY `unit` DESC [ RunTime:0.003309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58760139 LIMIT 2 [ RunTime:0.008190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58760139 ORDER BY `minOrder` ASC [ RunTime:0.017079s ]
select * from pdf where partno='MEC6-110-02-L-DV-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025092s ]
SELECT `id` FROM `stock` WHERE `id` <> 58760139 AND `partno` = 'MEC6-110-02-L-DV-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58760138 LIMIT 5 [ RunTime:0.017076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58760138 ORDER BY `minOrder` ASC [ RunTime:0.008495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58760138 ORDER BY `unit` DESC [ RunTime:0.007284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58760138 LIMIT 2 [ RunTime:0.010177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58760138 ORDER BY `minOrder` ASC [ RunTime:0.004232s ]
select * from pdf where partno='MEC6-110-02-L-DV-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021124s ]
SELECT `id` FROM `stock` WHERE `id` <> 58760138 AND `partno` = 'MEC6-110-02-L-DV-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58758415 LIMIT 5 [ RunTime:0.016729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58758415 ORDER BY `minOrder` ASC [ RunTime:0.017653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58758415 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58758415 LIMIT 2 [ RunTime:0.008779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58758415 ORDER BY `minOrder` ASC [ RunTime:0.004497s ]
select * from pdf where partno='MEC6-110-02-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003820s ]
SELECT `id` FROM `stock` WHERE `id` <> 58758415 AND `partno` = 'MEC6-110-02-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12833905 [ RunTime:0.018062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58751081 LIMIT 5 [ RunTime:0.006873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58751081 ORDER BY `minOrder` ASC [ RunTime:0.003936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58751081 ORDER BY `unit` DESC [ RunTime:0.008617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58751081 LIMIT 2 [ RunTime:0.034583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58751081 ORDER BY `minOrder` ASC [ RunTime:0.010634s ]
select * from pdf where partno='MEC6-110-02-L-DV-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005598s ]
SELECT `id` FROM `stock` WHERE `id` <> 58751081 AND `partno` = 'MEC6-110-02-L-DV-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17367177 [ RunTime:0.011256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58735933 LIMIT 5 [ RunTime:0.043942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58735933 ORDER BY `minOrder` ASC [ RunTime:0.017673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58735933 ORDER BY `unit` DESC [ RunTime:0.017560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58735933 LIMIT 2 [ RunTime:0.034186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58735933 ORDER BY `minOrder` ASC [ RunTime:0.014983s ]
select * from pdf where partno='MEC6-110-02-L-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC6-110-02-L-DV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019347s ]
SELECT `id` FROM `stock` WHERE `id` <> 58735933 AND `partno` = 'MEC6-110-02-L-DV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16245484 [ RunTime:0.030168s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019141s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048537s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031101s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016459s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013151s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016932s ]
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 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017480s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MEC6-110-02-L-DV%' OR `brand` LIKE 'MEC6-110-02-L-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034643s ]