SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001202s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070547s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11891454 LIMIT 5 [ RunTime:0.004249s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11891454 ORDER BY `minOrder` ASC [ RunTime:0.017986s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11891454 ORDER BY `unit` DESC [ RunTime:0.023479s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11891454 LIMIT 2 [ RunTime:0.021671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11891454 ORDER BY `minOrder` ASC [ RunTime:0.003822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11897647 LIMIT 5 [ RunTime:0.025450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11897647 ORDER BY `minOrder` ASC [ RunTime:0.031148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11897647 ORDER BY `unit` DESC [ RunTime:0.037931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11897647 LIMIT 2 [ RunTime:0.017676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11897647 ORDER BY `minOrder` ASC [ RunTime:0.004152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11897656 LIMIT 5 [ RunTime:0.029714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11897656 ORDER BY `minOrder` ASC [ RunTime:0.030772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11897656 ORDER BY `unit` DESC [ RunTime:0.010733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11897656 LIMIT 2 [ RunTime:0.024437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11897656 ORDER BY `minOrder` ASC [ RunTime:0.026539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11897646 LIMIT 5 [ RunTime:0.015239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11897646 ORDER BY `minOrder` ASC [ RunTime:0.010644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11897646 ORDER BY `unit` DESC [ RunTime:0.028762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11897646 LIMIT 2 [ RunTime:0.017475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11897646 ORDER BY `minOrder` ASC [ RunTime:0.012983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127707 LIMIT 5 [ RunTime:0.023254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127707 ORDER BY `minOrder` ASC [ RunTime:0.027917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127707 ORDER BY `unit` DESC [ RunTime:0.048770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127707 LIMIT 2 [ RunTime:0.014649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127707 ORDER BY `minOrder` ASC [ RunTime:0.017699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127519 LIMIT 5 [ RunTime:0.022193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127519 ORDER BY `minOrder` ASC [ RunTime:0.027228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127519 ORDER BY `unit` DESC [ RunTime:0.016597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127519 LIMIT 2 [ RunTime:0.008784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127519 ORDER BY `minOrder` ASC [ RunTime:0.015481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127424 LIMIT 5 [ RunTime:0.028591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127424 ORDER BY `minOrder` ASC [ RunTime:0.022212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127424 ORDER BY `unit` DESC [ RunTime:0.005509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127424 LIMIT 2 [ RunTime:0.029325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127424 ORDER BY `minOrder` ASC [ RunTime:0.015594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127135 LIMIT 5 [ RunTime:0.048156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127135 ORDER BY `minOrder` ASC [ RunTime:0.045164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127135 ORDER BY `unit` DESC [ RunTime:0.055178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127135 LIMIT 2 [ RunTime:0.056229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127135 ORDER BY `minOrder` ASC [ RunTime:0.003419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11906152 LIMIT 5 [ RunTime:0.036261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11906152 ORDER BY `minOrder` ASC [ RunTime:0.040833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11906152 ORDER BY `unit` DESC [ RunTime:0.079154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11906152 LIMIT 2 [ RunTime:0.011946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11906152 ORDER BY `minOrder` ASC [ RunTime:0.022536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870963 LIMIT 5 [ RunTime:0.030763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870963 ORDER BY `minOrder` ASC [ RunTime:0.031175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870963 ORDER BY `unit` DESC [ RunTime:0.033680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870963 LIMIT 2 [ RunTime:0.036056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870963 ORDER BY `minOrder` ASC [ RunTime:0.024182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870817 LIMIT 5 [ RunTime:0.004324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870817 ORDER BY `minOrder` ASC [ RunTime:0.026560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870817 ORDER BY `unit` DESC [ RunTime:0.009997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870817 LIMIT 2 [ RunTime:0.016560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870817 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870816 LIMIT 5 [ RunTime:0.000826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870816 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870816 ORDER BY `unit` DESC [ RunTime:0.007065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870816 LIMIT 2 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870816 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870815 LIMIT 5 [ RunTime:0.017923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870815 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870815 ORDER BY `unit` DESC [ RunTime:0.002960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870815 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870815 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870637 LIMIT 5 [ RunTime:0.003718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870637 ORDER BY `minOrder` ASC [ RunTime:0.007511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870637 ORDER BY `unit` DESC [ RunTime:0.004955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870637 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870637 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870210 LIMIT 5 [ RunTime:0.003696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870210 ORDER BY `minOrder` ASC [ RunTime:0.004289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870210 ORDER BY `unit` DESC [ RunTime:0.002960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870210 LIMIT 2 [ RunTime:0.003616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870210 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009674s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55116241 LIMIT 5 [ RunTime:0.003490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55116241 ORDER BY `minOrder` ASC [ RunTime:0.003075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55116241 ORDER BY `unit` DESC [ RunTime:0.004736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55116241 LIMIT 2 [ RunTime:0.003189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55116241 ORDER BY `minOrder` ASC [ RunTime:0.004250s ]
select * from pdf where partno='MDM-51SCBRPT' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.006064s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRPT' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.017052s ]
SELECT `id` FROM `stock` WHERE `id` <> 55116241 AND `partno` = 'MDM-51SCBRPT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.029578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11891454 [ RunTime:0.010612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55120011 LIMIT 5 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55120011 ORDER BY `minOrder` ASC [ RunTime:0.006780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55120011 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55120011 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55120011 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='MDM-51SCBRP-L56-A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.000814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-L56-A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.000472s ]
SELECT `id` FROM `stock` WHERE `id` <> 55120011 AND `partno` = 'MDM-51SCBRP-L56-A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55119887 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55119887 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55119887 ORDER BY `unit` DESC [ RunTime:0.006549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55119887 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55119887 ORDER BY `minOrder` ASC [ RunTime:0.001930s ]
select * from pdf where partno='MDM-51SCBRP-L56' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-L56' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.012698s ]
SELECT `id` FROM `stock` WHERE `id` <> 55119887 AND `partno` = 'MDM-51SCBRP-L56' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.003685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11897647 [ RunTime:0.002739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55126784 LIMIT 5 [ RunTime:0.012625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55126784 ORDER BY `minOrder` ASC [ RunTime:0.001376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55126784 ORDER BY `unit` DESC [ RunTime:0.007057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55126784 LIMIT 2 [ RunTime:0.002275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55126784 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='MDM-51SCBRP-L61-A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.003858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-L61-A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.000779s ]
SELECT `id` FROM `stock` WHERE `id` <> 55126784 AND `partno` = 'MDM-51SCBRP-L61-A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.002610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11897656 [ RunTime:0.003935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55119886 LIMIT 5 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55119886 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55119886 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55119886 LIMIT 2 [ RunTime:0.002450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55119886 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='MDM-51SCBRP-L61' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-L61' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004131s ]
SELECT `id` FROM `stock` WHERE `id` <> 55119886 AND `partno` = 'MDM-51SCBRP-L61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.004364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11897646 [ RunTime:0.001793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55115238 LIMIT 5 [ RunTime:0.001778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55115238 ORDER BY `minOrder` ASC [ RunTime:0.008692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55115238 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55115238 LIMIT 2 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55115238 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='MDM-51SCBRP' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.000592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT `id` FROM `stock` WHERE `id` <> 55115238 AND `partno` = 'MDM-51SCBRP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55296053 LIMIT 5 [ RunTime:0.001146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55296053 ORDER BY `minOrder` ASC [ RunTime:0.006846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55296053 ORDER BY `unit` DESC [ RunTime:0.002988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55296053 LIMIT 2 [ RunTime:0.005194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55296053 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='MDM-51SCBRP-A141' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-A141' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.006374s ]
SELECT `id` FROM `stock` WHERE `id` <> 55296053 AND `partno` = 'MDM-51SCBRP-A141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55295768 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295768 ORDER BY `minOrder` ASC [ RunTime:0.000909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55295768 ORDER BY `unit` DESC [ RunTime:0.008708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55295768 LIMIT 2 [ RunTime:0.002904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295768 ORDER BY `minOrder` ASC [ RunTime:0.002297s ]
select * from pdf where partno='MDM-51SCBRP-F222' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.005357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-F222' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.000999s ]
SELECT `id` FROM `stock` WHERE `id` <> 55295768 AND `partno` = 'MDM-51SCBRP-F222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.003525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55295627 LIMIT 5 [ RunTime:0.001905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295627 ORDER BY `minOrder` ASC [ RunTime:0.002431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55295627 ORDER BY `unit` DESC [ RunTime:0.000829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55295627 LIMIT 2 [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295627 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='MDM-51SCBRPTL67' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRPTL67' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.000436s ]
SELECT `id` FROM `stock` WHERE `id` <> 55295627 AND `partno` = 'MDM-51SCBRPTL67' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.000742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55295221 LIMIT 5 [ RunTime:0.003050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295221 ORDER BY `minOrder` ASC [ RunTime:0.006001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55295221 ORDER BY `unit` DESC [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55295221 LIMIT 2 [ RunTime:0.002840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295221 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='MDM-51SCBRPT-A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRPT-A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.001400s ]
SELECT `id` FROM `stock` WHERE `id` <> 55295221 AND `partno` = 'MDM-51SCBRPT-A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55295165 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295165 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55295165 ORDER BY `unit` DESC [ RunTime:0.002316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55295165 LIMIT 2 [ RunTime:0.004724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295165 ORDER BY `minOrder` ASC [ RunTime:0.004891s ]
select * from pdf where partno='MDM-51SCBRP-3' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-3' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.001248s ]
SELECT `id` FROM `stock` WHERE `id` <> 55295165 AND `partno` = 'MDM-51SCBRP-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.000613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870637 [ RunTime:0.002529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55294370 LIMIT 5 [ RunTime:0.016102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55294370 ORDER BY `minOrder` ASC [ RunTime:0.016162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55294370 ORDER BY `unit` DESC [ RunTime:0.006054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55294370 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55294370 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
select * from pdf where partno='MDM-51SCBRP-14' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.000785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-14' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.012981s ]
SELECT `id` FROM `stock` WHERE `id` <> 55294370 AND `partno` = 'MDM-51SCBRP-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.024504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55294319 LIMIT 5 [ RunTime:0.018989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55294319 ORDER BY `minOrder` ASC [ RunTime:0.022271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55294319 ORDER BY `unit` DESC [ RunTime:0.024209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55294319 LIMIT 2 [ RunTime:0.022288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55294319 ORDER BY `minOrder` ASC [ RunTime:0.004022s ]
select * from pdf where partno='MDM-51SCBRP-15' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-15' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005061s ]
SELECT `id` FROM `stock` WHERE `id` <> 55294319 AND `partno` = 'MDM-51SCBRP-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.021730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55293778 LIMIT 5 [ RunTime:0.018548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55293778 ORDER BY `minOrder` ASC [ RunTime:0.012405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55293778 ORDER BY `unit` DESC [ RunTime:0.012171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55293778 LIMIT 2 [ RunTime:0.004613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55293778 ORDER BY `minOrder` ASC [ RunTime:0.025475s ]
select * from pdf where partno='MDM-51SCBRP-13' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.027010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-13' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004049s ]
SELECT `id` FROM `stock` WHERE `id` <> 55293778 AND `partno` = 'MDM-51SCBRP-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.017352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122107 LIMIT 5 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122107 ORDER BY `minOrder` ASC [ RunTime:0.005078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122107 ORDER BY `unit` DESC [ RunTime:0.008345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122107 LIMIT 2 [ RunTime:0.014380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122107 ORDER BY `minOrder` ASC [ RunTime:0.007624s ]
select * from pdf where partno='MDM-51SCBRP-A30' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.002049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-A30' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004366s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122107 AND `partno` = 'MDM-51SCBRP-A30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.004698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127707 [ RunTime:0.000743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122084 LIMIT 5 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122084 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122084 ORDER BY `unit` DESC [ RunTime:0.001688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122084 LIMIT 2 [ RunTime:0.002928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122084 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
select * from pdf where partno='MDM-51SCBRP-A172' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.002914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRP-A172' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.002633s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122084 AND `partno` = 'MDM-51SCBRP-A172' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.015163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870963 [ RunTime:0.003117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122071 LIMIT 5 [ RunTime:0.000759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122071 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122071 ORDER BY `unit` DESC [ RunTime:0.002350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122071 LIMIT 2 [ RunTime:0.014620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122071 ORDER BY `minOrder` ASC [ RunTime:0.015495s ]
select * from pdf where partno='MDM-51SCBRPTL57-A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.004287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRPTL57-A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.000883s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122071 AND `partno` = 'MDM-51SCBRPTL57-A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.004459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127519 [ RunTime:0.013012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122031 LIMIT 5 [ RunTime:0.008584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122031 ORDER BY `minOrder` ASC [ RunTime:0.001016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122031 ORDER BY `unit` DESC [ RunTime:0.007616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122031 LIMIT 2 [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122031 ORDER BY `minOrder` ASC [ RunTime:0.007878s ]
select * from pdf where partno='MDM-51SCBRPTL58' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.002607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRPTL58' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.003188s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122031 AND `partno` = 'MDM-51SCBRPTL58' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.018330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127424 [ RunTime:0.001536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122026 LIMIT 5 [ RunTime:0.005029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122026 ORDER BY `minOrder` ASC [ RunTime:0.008680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122026 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122026 LIMIT 2 [ RunTime:0.010191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122026 ORDER BY `minOrder` ASC [ RunTime:0.003377s ]
select * from pdf where partno='MDM-51SCBRPTL57' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.004336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRPTL57' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.007741s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122026 AND `partno` = 'MDM-51SCBRPTL57' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.017517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870817 [ RunTime:0.008080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122025 LIMIT 5 [ RunTime:0.004144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122025 ORDER BY `minOrder` ASC [ RunTime:0.003602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122025 ORDER BY `unit` DESC [ RunTime:0.006033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122025 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122025 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='MDM-51SCBRPL57' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM-51SCBRPL57' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.006898s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122025 AND `partno` = 'MDM-51SCBRPL57' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.004026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870816 [ RunTime:0.000723s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005259s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002951s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001407s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002938s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005059s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003245s ]
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 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005388s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MDM-51SCBRP%' OR `brand` LIKE 'MDM-51SCBRP%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002910s ]