SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001525s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036039s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208877 LIMIT 5 [ RunTime:0.021171s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208877 ORDER BY `minOrder` ASC [ RunTime:0.037586s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16208877 ORDER BY `unit` DESC [ RunTime:0.040977s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16208877 LIMIT 2 [ RunTime:0.004271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208877 ORDER BY `minOrder` ASC [ RunTime:0.010735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12773115 LIMIT 5 [ RunTime:0.012138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12773115 ORDER BY `minOrder` ASC [ RunTime:0.031630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12773115 ORDER BY `unit` DESC [ RunTime:0.018154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12773115 LIMIT 2 [ RunTime:0.032794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12773115 ORDER BY `minOrder` ASC [ RunTime:0.013219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749825 LIMIT 5 [ RunTime:0.025007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749825 ORDER BY `minOrder` ASC [ RunTime:0.048262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12749825 ORDER BY `unit` DESC [ RunTime:0.040428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12749825 LIMIT 2 [ RunTime:0.015467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749825 ORDER BY `minOrder` ASC [ RunTime:0.012159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749787 LIMIT 5 [ RunTime:0.018760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749787 ORDER BY `minOrder` ASC [ RunTime:0.020620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12749787 ORDER BY `unit` DESC [ RunTime:0.006049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12749787 LIMIT 2 [ RunTime:0.019915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749787 ORDER BY `minOrder` ASC [ RunTime:0.005546s ]
select * from pdf where partno='FTS-125-03-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740091 LIMIT 5 [ RunTime:0.024869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740091 ORDER BY `minOrder` ASC [ RunTime:0.025662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740091 ORDER BY `unit` DESC [ RunTime:0.026651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740091 LIMIT 2 [ RunTime:0.013668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740091 ORDER BY `minOrder` ASC [ RunTime:0.007644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11580234 LIMIT 5 [ RunTime:0.029456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11580234 ORDER BY `minOrder` ASC [ RunTime:0.013894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11580234 ORDER BY `unit` DESC [ RunTime:0.015359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11580234 LIMIT 2 [ RunTime:0.010706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11580234 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11578331 LIMIT 5 [ RunTime:0.006301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11578331 ORDER BY `minOrder` ASC [ RunTime:0.010497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11578331 ORDER BY `unit` DESC [ RunTime:0.017761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11578331 LIMIT 2 [ RunTime:0.022225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11578331 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577556 LIMIT 5 [ RunTime:0.008515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577556 ORDER BY `minOrder` ASC [ RunTime:0.004670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11577556 ORDER BY `unit` DESC [ RunTime:0.022599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11577556 LIMIT 2 [ RunTime:0.015944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577556 ORDER BY `minOrder` ASC [ RunTime:0.004668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577074 LIMIT 5 [ RunTime:0.016210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577074 ORDER BY `minOrder` ASC [ RunTime:0.013054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11577074 ORDER BY `unit` DESC [ RunTime:0.011380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11577074 LIMIT 2 [ RunTime:0.026872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577074 ORDER BY `minOrder` ASC [ RunTime:0.004895s ]
select * from pdf where partno='FTS-125-03-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576720 LIMIT 5 [ RunTime:0.004509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576720 ORDER BY `minOrder` ASC [ RunTime:0.006174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11576720 ORDER BY `unit` DESC [ RunTime:0.002422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11576720 LIMIT 2 [ RunTime:0.004244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576720 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014422s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59717178 LIMIT 5 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59717178 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59717178 ORDER BY `unit` DESC [ RunTime:0.005793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59717178 LIMIT 2 [ RunTime:0.004054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59717178 ORDER BY `minOrder` ASC [ RunTime:0.001840s ]
select * from pdf where partno='FTS-125-03-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001857s ]
SELECT `id` FROM `stock` WHERE `id` <> 59717178 AND `partno` = 'FTS-125-03-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749787 [ RunTime:0.002052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59714052 LIMIT 5 [ RunTime:0.001326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59714052 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59714052 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59714052 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59714052 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
select * from pdf where partno='FTS-125-03-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000346s ]
SELECT `id` FROM `stock` WHERE `id` <> 59714052 AND `partno` = 'FTS-125-03-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577074 [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59706070 LIMIT 5 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706070 ORDER BY `minOrder` ASC [ RunTime:0.007738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59706070 ORDER BY `unit` DESC [ RunTime:0.005973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59706070 LIMIT 2 [ RunTime:0.004679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706070 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
select * from pdf where partno='FTS-125-03-L-DV-SA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV-SA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000778s ]
SELECT `id` FROM `stock` WHERE `id` <> 59706070 AND `partno` = 'FTS-125-03-L-DV-SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59706062 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706062 ORDER BY `minOrder` ASC [ RunTime:0.005384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59706062 ORDER BY `unit` DESC [ RunTime:0.007896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59706062 LIMIT 2 [ RunTime:0.005850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706062 ORDER BY `minOrder` ASC [ RunTime:0.004174s ]
select * from pdf where partno='FTS-125-03-L-DV-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010503s ]
SELECT `id` FROM `stock` WHERE `id` <> 59706062 AND `partno` = 'FTS-125-03-L-DV-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11580234 [ RunTime:0.006900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59702214 LIMIT 5 [ RunTime:0.034566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702214 ORDER BY `minOrder` ASC [ RunTime:0.033982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59702214 ORDER BY `unit` DESC [ RunTime:0.029289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59702214 LIMIT 2 [ RunTime:0.017626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702214 ORDER BY `minOrder` ASC [ RunTime:0.004322s ]
select * from pdf where partno='FTS-125-03-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008986s ]
SELECT `id` FROM `stock` WHERE `id` <> 59702214 AND `partno` = 'FTS-125-03-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577556 [ RunTime:0.027573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59702176 LIMIT 5 [ RunTime:0.006984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702176 ORDER BY `minOrder` ASC [ RunTime:0.016019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59702176 ORDER BY `unit` DESC [ RunTime:0.015080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59702176 LIMIT 2 [ RunTime:0.006856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702176 ORDER BY `minOrder` ASC [ RunTime:0.003376s ]
select * from pdf where partno='FTS-125-03-L-D-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-D-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007087s ]
SELECT `id` FROM `stock` WHERE `id` <> 59702176 AND `partno` = 'FTS-125-03-L-D-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749825 [ RunTime:0.004876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59701830 LIMIT 5 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701830 ORDER BY `minOrder` ASC [ RunTime:0.024419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59701830 ORDER BY `unit` DESC [ RunTime:0.023557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59701830 LIMIT 2 [ RunTime:0.013607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701830 ORDER BY `minOrder` ASC [ RunTime:0.002250s ]
select * from pdf where partno='FTS-125-03-L-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009232s ]
SELECT `id` FROM `stock` WHERE `id` <> 59701830 AND `partno` = 'FTS-125-03-L-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11578331 [ RunTime:0.008993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59699743 LIMIT 5 [ RunTime:0.013790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59699743 ORDER BY `minOrder` ASC [ RunTime:0.010644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59699743 ORDER BY `unit` DESC [ RunTime:0.025277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59699743 LIMIT 2 [ RunTime:0.021664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59699743 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
select * from pdf where partno='FTS-125-03-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012151s ]
SELECT `id` FROM `stock` WHERE `id` <> 59699743 AND `partno` = 'FTS-125-03-L-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740091 [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59697321 LIMIT 5 [ RunTime:0.011381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697321 ORDER BY `minOrder` ASC [ RunTime:0.012450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59697321 ORDER BY `unit` DESC [ RunTime:0.006976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59697321 LIMIT 2 [ RunTime:0.032574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697321 ORDER BY `minOrder` ASC [ RunTime:0.001933s ]
select * from pdf where partno='FTS-125-03-L-D-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-D-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006917s ]
SELECT `id` FROM `stock` WHERE `id` <> 59697321 AND `partno` = 'FTS-125-03-L-D-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576720 [ RunTime:0.004621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59695005 LIMIT 5 [ RunTime:0.002378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59695005 ORDER BY `minOrder` ASC [ RunTime:0.018745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59695005 ORDER BY `unit` DESC [ RunTime:0.035037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59695005 LIMIT 2 [ RunTime:0.031355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59695005 ORDER BY `minOrder` ASC [ RunTime:0.033404s ]
select * from pdf where partno='FTS-125-03-L-DV-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020871s ]
SELECT `id` FROM `stock` WHERE `id` <> 59695005 AND `partno` = 'FTS-125-03-L-DV-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59672466 LIMIT 5 [ RunTime:0.042420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59672466 ORDER BY `minOrder` ASC [ RunTime:0.062411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59672466 ORDER BY `unit` DESC [ RunTime:0.054606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59672466 LIMIT 2 [ RunTime:0.017906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59672466 ORDER BY `minOrder` ASC [ RunTime:0.051428s ]
select * from pdf where partno='FTS-125-03-L-DV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.057481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-125-03-L-DV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.038523s ]
SELECT `id` FROM `stock` WHERE `id` <> 59672466 AND `partno` = 'FTS-125-03-L-DV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.049523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208877 [ RunTime:0.030783s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019818s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026914s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029960s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027713s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023699s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031538s ]
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 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021417s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTS-125-03-L-D%' OR `brand` LIKE 'FTS-125-03-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.053831s ]