SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002158s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013345s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827520 LIMIT 5 [ RunTime:0.008116s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827520 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827520 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827520 LIMIT 2 [ RunTime:0.002999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827520 ORDER BY `minOrder` ASC [ RunTime:0.005261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827772 LIMIT 5 [ RunTime:0.006124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827772 ORDER BY `minOrder` ASC [ RunTime:0.007782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827772 ORDER BY `unit` DESC [ RunTime:0.011670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827772 LIMIT 2 [ RunTime:0.006465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827772 ORDER BY `minOrder` ASC [ RunTime:0.021181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827776 LIMIT 5 [ RunTime:0.004061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827776 ORDER BY `minOrder` ASC [ RunTime:0.022728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827776 ORDER BY `unit` DESC [ RunTime:0.029199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827776 LIMIT 2 [ RunTime:0.014026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827776 ORDER BY `minOrder` ASC [ RunTime:0.004603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14719481 LIMIT 5 [ RunTime:0.028422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14719481 ORDER BY `minOrder` ASC [ RunTime:0.037455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14719481 ORDER BY `unit` DESC [ RunTime:0.034417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14719481 LIMIT 2 [ RunTime:0.032686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14719481 ORDER BY `minOrder` ASC [ RunTime:0.009773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823903 LIMIT 5 [ RunTime:0.026330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823903 ORDER BY `minOrder` ASC [ RunTime:0.022597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13823903 ORDER BY `unit` DESC [ RunTime:0.022323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13823903 LIMIT 2 [ RunTime:0.027197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823903 ORDER BY `minOrder` ASC [ RunTime:0.014691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823495 LIMIT 5 [ RunTime:0.019187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823495 ORDER BY `minOrder` ASC [ RunTime:0.003552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13823495 ORDER BY `unit` DESC [ RunTime:0.021410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13823495 LIMIT 2 [ RunTime:0.013122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823495 ORDER BY `minOrder` ASC [ RunTime:0.007863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823498 LIMIT 5 [ RunTime:0.014820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823498 ORDER BY `minOrder` ASC [ RunTime:0.019718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13823498 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13823498 LIMIT 2 [ RunTime:0.020027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823498 ORDER BY `minOrder` ASC [ RunTime:0.011199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14714089 LIMIT 5 [ RunTime:0.006216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14714089 ORDER BY `minOrder` ASC [ RunTime:0.024903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14714089 ORDER BY `unit` DESC [ RunTime:0.020876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14714089 LIMIT 2 [ RunTime:0.016897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14714089 ORDER BY `minOrder` ASC [ RunTime:0.003204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826161 LIMIT 5 [ RunTime:0.006525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826161 ORDER BY `minOrder` ASC [ RunTime:0.017831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13826161 ORDER BY `unit` DESC [ RunTime:0.006615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13826161 LIMIT 2 [ RunTime:0.005263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826161 ORDER BY `minOrder` ASC [ RunTime:0.005071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826163 LIMIT 5 [ RunTime:0.001353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826163 ORDER BY `minOrder` ASC [ RunTime:0.007582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13826163 ORDER BY `unit` DESC [ RunTime:0.011619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13826163 LIMIT 2 [ RunTime:0.015882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826163 ORDER BY `minOrder` ASC [ RunTime:0.001722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16633335 LIMIT 5 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16633335 ORDER BY `minOrder` ASC [ RunTime:0.010093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16633335 ORDER BY `unit` DESC [ RunTime:0.001311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16633335 LIMIT 2 [ RunTime:0.009771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16633335 ORDER BY `minOrder` ASC [ RunTime:0.004231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14720291 LIMIT 5 [ RunTime:0.005073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14720291 ORDER BY `minOrder` ASC [ RunTime:0.002557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14720291 ORDER BY `unit` DESC [ RunTime:0.013235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14720291 LIMIT 2 [ RunTime:0.002662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14720291 ORDER BY `minOrder` ASC [ RunTime:0.003255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718429 LIMIT 5 [ RunTime:0.001595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718429 ORDER BY `minOrder` ASC [ RunTime:0.008945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14718429 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14718429 LIMIT 2 [ RunTime:0.006664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718429 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828322 LIMIT 5 [ RunTime:0.001777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828322 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13828322 ORDER BY `unit` DESC [ RunTime:0.006184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13828322 LIMIT 2 [ RunTime:0.011368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828322 ORDER BY `minOrder` ASC [ RunTime:0.006418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828321 LIMIT 5 [ RunTime:0.006762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828321 ORDER BY `minOrder` ASC [ RunTime:0.014313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13828321 ORDER BY `unit` DESC [ RunTime:0.021709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13828321 LIMIT 2 [ RunTime:0.003789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828321 ORDER BY `minOrder` ASC [ RunTime:0.003025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828320 LIMIT 5 [ RunTime:0.014317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828320 ORDER BY `minOrder` ASC [ RunTime:0.003932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13828320 ORDER BY `unit` DESC [ RunTime:0.003919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13828320 LIMIT 2 [ RunTime:0.003349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828320 ORDER BY `minOrder` ASC [ RunTime:0.003672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827050 LIMIT 5 [ RunTime:0.004102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827050 ORDER BY `minOrder` ASC [ RunTime:0.004291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827050 ORDER BY `unit` DESC [ RunTime:0.002588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827050 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827050 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006275s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58230149 LIMIT 5 [ RunTime:0.007471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230149 ORDER BY `minOrder` ASC [ RunTime:0.007407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58230149 ORDER BY `unit` DESC [ RunTime:0.006676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58230149 LIMIT 2 [ RunTime:0.003287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230149 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
select * from pdf where partno='ATDR15' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.008932s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR15' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.009176s ]
SELECT `id` FROM `stock` WHERE `id` <> 58230149 AND `partno` = 'ATDR15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.009066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827520 [ RunTime:0.010217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58230914 LIMIT 5 [ RunTime:0.008952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230914 ORDER BY `minOrder` ASC [ RunTime:0.015622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58230914 ORDER BY `unit` DESC [ RunTime:0.009394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58230914 LIMIT 2 [ RunTime:0.009051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230914 ORDER BY `minOrder` ASC [ RunTime:0.009125s ]
select * from pdf where partno='ATDR10' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.011961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR10' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.009546s ]
SELECT `id` FROM `stock` WHERE `id` <> 58230914 AND `partno` = 'ATDR10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827776 [ RunTime:0.013294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58230947 LIMIT 5 [ RunTime:0.002304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230947 ORDER BY `minOrder` ASC [ RunTime:0.003870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58230947 ORDER BY `unit` DESC [ RunTime:0.002812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58230947 LIMIT 2 [ RunTime:0.004398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230947 ORDER BY `minOrder` ASC [ RunTime:0.006105s ]
select * from pdf where partno='ATDR12' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.006526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR12' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.011786s ]
SELECT `id` FROM `stock` WHERE `id` <> 58230947 AND `partno` = 'ATDR12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.038874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827772 [ RunTime:0.009684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58230945 LIMIT 5 [ RunTime:0.008081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230945 ORDER BY `minOrder` ASC [ RunTime:0.011021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58230945 ORDER BY `unit` DESC [ RunTime:0.020678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58230945 LIMIT 2 [ RunTime:0.026924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58230945 ORDER BY `minOrder` ASC [ RunTime:0.020488s ]
select * from pdf where partno='ATDR1' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.022722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.010420s ]
SELECT `id` FROM `stock` WHERE `id` <> 58230945 AND `partno` = 'ATDR1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.012195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14719481 [ RunTime:0.004626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58231099 LIMIT 5 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231099 ORDER BY `minOrder` ASC [ RunTime:0.001413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58231099 ORDER BY `unit` DESC [ RunTime:0.018679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58231099 LIMIT 2 [ RunTime:0.004919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231099 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
select * from pdf where partno='ATDR1/2' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.001546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1/2' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.003321s ]
SELECT `id` FROM `stock` WHERE `id` <> 58231099 AND `partno` = 'ATDR1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.014322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826161 [ RunTime:0.009166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58231095 LIMIT 5 [ RunTime:0.002707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231095 ORDER BY `minOrder` ASC [ RunTime:0.003480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58231095 ORDER BY `unit` DESC [ RunTime:0.007009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58231095 LIMIT 2 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231095 ORDER BY `minOrder` ASC [ RunTime:0.003210s ]
select * from pdf where partno='ATDR17-1/2' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.004274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR17-1/2' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.007868s ]
SELECT `id` FROM `stock` WHERE `id` <> 58231095 AND `partno` = 'ATDR17-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.006278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823495 [ RunTime:0.012225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58231931 LIMIT 5 [ RunTime:0.002048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231931 ORDER BY `minOrder` ASC [ RunTime:0.011530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58231931 ORDER BY `unit` DESC [ RunTime:0.015977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58231931 LIMIT 2 [ RunTime:0.013672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231931 ORDER BY `minOrder` ASC [ RunTime:0.008525s ]
select * from pdf where partno='ATDR1/4' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.015840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1/4' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.007851s ]
SELECT `id` FROM `stock` WHERE `id` <> 58231931 AND `partno` = 'ATDR1/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.020836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823903 [ RunTime:0.019181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58231924 LIMIT 5 [ RunTime:0.006398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231924 ORDER BY `minOrder` ASC [ RunTime:0.013542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58231924 ORDER BY `unit` DESC [ RunTime:0.016072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58231924 LIMIT 2 [ RunTime:0.031405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231924 ORDER BY `minOrder` ASC [ RunTime:0.001588s ]
select * from pdf where partno='ATDR1-1/4' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.021411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1-1/4' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.008441s ]
SELECT `id` FROM `stock` WHERE `id` <> 58231924 AND `partno` = 'ATDR1-1/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.018608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823498 [ RunTime:0.003685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58239416 LIMIT 5 [ RunTime:0.018320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58239416 ORDER BY `minOrder` ASC [ RunTime:0.025679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58239416 ORDER BY `unit` DESC [ RunTime:0.035945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58239416 LIMIT 2 [ RunTime:0.052281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58239416 ORDER BY `minOrder` ASC [ RunTime:0.008653s ]
select * from pdf where partno='ATDR1-6PK' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.078926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1-6PK' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.027785s ]
SELECT `id` FROM `stock` WHERE `id` <> 58239416 AND `partno` = 'ATDR1-6PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.030910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14720291 [ RunTime:0.073545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58238863 LIMIT 5 [ RunTime:0.028113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58238863 ORDER BY `minOrder` ASC [ RunTime:0.037867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58238863 ORDER BY `unit` DESC [ RunTime:0.073129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58238863 LIMIT 2 [ RunTime:0.039916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58238863 ORDER BY `minOrder` ASC [ RunTime:0.020560s ]
select * from pdf where partno='ATDR15-6PK' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.034577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR15-6PK' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.012929s ]
SELECT `id` FROM `stock` WHERE `id` <> 58238863 AND `partno` = 'ATDR15-6PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.019741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828322 [ RunTime:0.026241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58238862 LIMIT 5 [ RunTime:0.023016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58238862 ORDER BY `minOrder` ASC [ RunTime:0.020300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58238862 ORDER BY `unit` DESC [ RunTime:0.022839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58238862 LIMIT 2 [ RunTime:0.029710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58238862 ORDER BY `minOrder` ASC [ RunTime:0.019288s ]
select * from pdf where partno='ATDR1/2-6PK' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.010831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1/2-6PK' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.024129s ]
SELECT `id` FROM `stock` WHERE `id` <> 58238862 AND `partno` = 'ATDR1/2-6PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.014094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828321 [ RunTime:0.010733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58238861 LIMIT 5 [ RunTime:0.025508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58238861 ORDER BY `minOrder` ASC [ RunTime:0.019038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58238861 ORDER BY `unit` DESC [ RunTime:0.015267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58238861 LIMIT 2 [ RunTime:0.026100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58238861 ORDER BY `minOrder` ASC [ RunTime:0.008384s ]
select * from pdf where partno='ATDR10-6PK' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.013842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR10-6PK' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.018476s ]
SELECT `id` FROM `stock` WHERE `id` <> 58238861 AND `partno` = 'ATDR10-6PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.009934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828320 [ RunTime:0.022057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58234973 LIMIT 5 [ RunTime:0.027558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234973 ORDER BY `minOrder` ASC [ RunTime:0.004602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58234973 ORDER BY `unit` DESC [ RunTime:0.011679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58234973 LIMIT 2 [ RunTime:0.023680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234973 ORDER BY `minOrder` ASC [ RunTime:0.008780s ]
select * from pdf where partno='ATDR1-8/10' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.013540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1-8/10' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.008368s ]
SELECT `id` FROM `stock` WHERE `id` <> 58234973 AND `partno` = 'ATDR1-8/10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.007636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16633335 [ RunTime:0.023421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58234972 LIMIT 5 [ RunTime:0.036976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234972 ORDER BY `minOrder` ASC [ RunTime:0.054846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58234972 ORDER BY `unit` DESC [ RunTime:0.012029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58234972 LIMIT 2 [ RunTime:0.022099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234972 ORDER BY `minOrder` ASC [ RunTime:0.008628s ]
select * from pdf where partno='ATDR1-1/8' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.041321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1-1/8' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.012363s ]
SELECT `id` FROM `stock` WHERE `id` <> 58234972 AND `partno` = 'ATDR1-1/8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.036992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827050 [ RunTime:0.014544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58234970 LIMIT 5 [ RunTime:0.005651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234970 ORDER BY `minOrder` ASC [ RunTime:0.033538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58234970 ORDER BY `unit` DESC [ RunTime:0.028349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58234970 LIMIT 2 [ RunTime:0.031876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58234970 ORDER BY `minOrder` ASC [ RunTime:0.015307s ]
select * from pdf where partno='ATDR1-4/10' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.033639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1-4/10' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.022035s ]
SELECT `id` FROM `stock` WHERE `id` <> 58234970 AND `partno` = 'ATDR1-4/10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.019112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718429 [ RunTime:0.019213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58232155 LIMIT 5 [ RunTime:0.029379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58232155 ORDER BY `minOrder` ASC [ RunTime:0.026084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58232155 ORDER BY `unit` DESC [ RunTime:0.007604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58232155 LIMIT 2 [ RunTime:0.020972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58232155 ORDER BY `minOrder` ASC [ RunTime:0.006425s ]
select * from pdf where partno='ATDR1-6/10' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.008269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1-6/10' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.002848s ]
SELECT `id` FROM `stock` WHERE `id` <> 58232155 AND `partno` = 'ATDR1-6/10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.010266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14714089 [ RunTime:0.022484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58231927 LIMIT 5 [ RunTime:0.010607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231927 ORDER BY `minOrder` ASC [ RunTime:0.013894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58231927 ORDER BY `unit` DESC [ RunTime:0.026386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58231927 LIMIT 2 [ RunTime:0.005181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58231927 ORDER BY `minOrder` ASC [ RunTime:0.005331s ]
select * from pdf where partno='ATDR1-1/2' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.028308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATDR1-1/2' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.022524s ]
SELECT `id` FROM `stock` WHERE `id` <> 58231927 AND `partno` = 'ATDR1-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.020966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826163 [ RunTime:0.026880s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015588s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020167s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020679s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031494s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028563s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020162s ]
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 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013012s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ATDR1%' OR `brand` LIKE 'ATDR1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013951s ]