SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002436s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081726s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11450198 LIMIT 5 [ RunTime:0.021858s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450198 ORDER BY `minOrder` ASC [ RunTime:0.040665s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.035580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11450198 ORDER BY `unit` DESC [ RunTime:0.024340s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11450198 LIMIT 2 [ RunTime:0.030419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450198 ORDER BY `minOrder` ASC [ RunTime:0.026298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234465 LIMIT 5 [ RunTime:0.031877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234465 ORDER BY `minOrder` ASC [ RunTime:0.021542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14234465 ORDER BY `unit` DESC [ RunTime:0.023514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14234465 LIMIT 2 [ RunTime:0.011631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234465 ORDER BY `minOrder` ASC [ RunTime:0.007364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492629 LIMIT 5 [ RunTime:0.029669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492629 ORDER BY `minOrder` ASC [ RunTime:0.057290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492629 ORDER BY `unit` DESC [ RunTime:0.039148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492629 LIMIT 2 [ RunTime:0.005811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492629 ORDER BY `minOrder` ASC [ RunTime:0.006148s ]
select * from pdf where partno='541219 RD002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.012184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15325712 LIMIT 5 [ RunTime:0.011240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15325712 ORDER BY `minOrder` ASC [ RunTime:0.002064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15325712 ORDER BY `unit` DESC [ RunTime:0.014189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15325712 LIMIT 2 [ RunTime:0.005105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15325712 ORDER BY `minOrder` ASC [ RunTime:0.015577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19177859 LIMIT 5 [ RunTime:0.029232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19177859 ORDER BY `minOrder` ASC [ RunTime:0.022188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19177859 ORDER BY `unit` DESC [ RunTime:0.007400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19177859 LIMIT 2 [ RunTime:0.007073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19177859 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19185214 LIMIT 5 [ RunTime:0.011428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19185214 ORDER BY `minOrder` ASC [ RunTime:0.031735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19185214 ORDER BY `unit` DESC [ RunTime:0.004757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19185214 LIMIT 2 [ RunTime:0.003114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19185214 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370758 LIMIT 5 [ RunTime:0.004335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370758 ORDER BY `minOrder` ASC [ RunTime:0.007052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14370758 ORDER BY `unit` DESC [ RunTime:0.009886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14370758 LIMIT 2 [ RunTime:0.017775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370758 ORDER BY `minOrder` ASC [ RunTime:0.009238s ]
select * from pdf where partno='541219 WH005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16406997 LIMIT 5 [ RunTime:0.006936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16406997 ORDER BY `minOrder` ASC [ RunTime:0.002335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16406997 ORDER BY `unit` DESC [ RunTime:0.002775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16406997 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16406997 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='541219 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370759 LIMIT 5 [ RunTime:0.013381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370759 ORDER BY `minOrder` ASC [ RunTime:0.051305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14370759 ORDER BY `unit` DESC [ RunTime:0.021498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14370759 LIMIT 2 [ RunTime:0.018189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370759 ORDER BY `minOrder` ASC [ RunTime:0.002602s ]
select * from pdf where partno='541219 RD005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.034915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492338 LIMIT 5 [ RunTime:0.019267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492338 ORDER BY `minOrder` ASC [ RunTime:0.030173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492338 ORDER BY `unit` DESC [ RunTime:0.043117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492338 LIMIT 2 [ RunTime:0.032299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492338 ORDER BY `minOrder` ASC [ RunTime:0.019523s ]
select * from pdf where partno='541201 RD005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.016477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492337 LIMIT 5 [ RunTime:0.009277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492337 ORDER BY `minOrder` ASC [ RunTime:0.006218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492337 ORDER BY `unit` DESC [ RunTime:0.004251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492337 LIMIT 2 [ RunTime:0.011605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492337 ORDER BY `minOrder` ASC [ RunTime:0.001097s ]
select * from pdf where partno='541201 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.017129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370961 LIMIT 5 [ RunTime:0.016604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370961 ORDER BY `minOrder` ASC [ RunTime:0.020791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14370961 ORDER BY `unit` DESC [ RunTime:0.022841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14370961 LIMIT 2 [ RunTime:0.039587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370961 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
select * from pdf where partno='541219 BK002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.031290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407119 LIMIT 5 [ RunTime:0.016040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407119 ORDER BY `minOrder` ASC [ RunTime:0.018006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407119 ORDER BY `unit` DESC [ RunTime:0.018990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407119 LIMIT 2 [ RunTime:0.015197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407119 ORDER BY `minOrder` ASC [ RunTime:0.003917s ]
select * from pdf where partno='541219 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.021715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234471 LIMIT 5 [ RunTime:0.012086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234471 ORDER BY `minOrder` ASC [ RunTime:0.014672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14234471 ORDER BY `unit` DESC [ RunTime:0.001064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14234471 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234471 ORDER BY `minOrder` ASC [ RunTime:0.004350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14372851 LIMIT 5 [ RunTime:0.009082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14372851 ORDER BY `minOrder` ASC [ RunTime:0.001743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14372851 ORDER BY `unit` DESC [ RunTime:0.011289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14372851 LIMIT 2 [ RunTime:0.008510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14372851 ORDER BY `minOrder` ASC [ RunTime:0.002553s ]
select * from pdf where partno='541201 RD001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492910 LIMIT 5 [ RunTime:0.001552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492910 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492910 ORDER BY `unit` DESC [ RunTime:0.005463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492910 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492910 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='541201 BK002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492536 LIMIT 5 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492536 ORDER BY `minOrder` ASC [ RunTime:0.004994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492536 ORDER BY `unit` DESC [ RunTime:0.003415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492536 LIMIT 2 [ RunTime:0.019088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492536 ORDER BY `minOrder` ASC [ RunTime:0.017629s ]
select * from pdf where partno='541201 RD002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.023048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16409128 LIMIT 5 [ RunTime:0.002408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16409128 ORDER BY `minOrder` ASC [ RunTime:0.004090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16409128 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16409128 LIMIT 2 [ RunTime:0.006482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16409128 ORDER BY `minOrder` ASC [ RunTime:0.003182s ]
select * from pdf where partno='541219 RD001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14373077 LIMIT 5 [ RunTime:0.020304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14373077 ORDER BY `minOrder` ASC [ RunTime:0.009845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14373077 ORDER BY `unit` DESC [ RunTime:0.004131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14373077 LIMIT 2 [ RunTime:0.001326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14373077 ORDER BY `minOrder` ASC [ RunTime:0.003158s ]
select * from pdf where partno='541219 GR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494080 LIMIT 5 [ RunTime:0.008643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494080 ORDER BY `minOrder` ASC [ RunTime:0.005546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13494080 ORDER BY `unit` DESC [ RunTime:0.011976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13494080 LIMIT 2 [ RunTime:0.010233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494080 ORDER BY `minOrder` ASC [ RunTime:0.006409s ]
select * from pdf where partno='541219 WH002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.014076s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138321 LIMIT 5 [ RunTime:0.005504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138321 ORDER BY `minOrder` ASC [ RunTime:0.007297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138321 ORDER BY `unit` DESC [ RunTime:0.018332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138321 LIMIT 2 [ RunTime:0.002191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138321 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='541219 gr005' and brandshort='alpha wire' limit 1 [ RunTime:0.000973s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '541219 gr005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.000905s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138321 AND `partno` = '541219 gr005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13493833 [ RunTime:0.002995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139013 LIMIT 5 [ RunTime:0.010221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139013 ORDER BY `minOrder` ASC [ RunTime:0.007143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139013 ORDER BY `unit` DESC [ RunTime:0.004356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139013 LIMIT 2 [ RunTime:0.009109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139013 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
select * from pdf where partno='541201 rd001' and brandshort='alpha wire' limit 1 [ RunTime:0.001693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '541201 rd001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.009428s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139013 AND `partno` = '541201 rd001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.030264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14372851 [ RunTime:0.021588s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60671505 LIMIT 5 [ RunTime:0.004630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60671505 ORDER BY `minOrder` ASC [ RunTime:0.017860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60671505 ORDER BY `unit` DESC [ RunTime:0.005792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60671505 LIMIT 2 [ RunTime:0.001127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60671505 ORDER BY `minOrder` ASC [ RunTime:0.007288s ]
select * from pdf where partno='54122-812062400LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.005423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-812062400LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.008187s ]
SELECT `id` FROM `stock` WHERE `id` <> 60671505 AND `partno` = '54122-812062400LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.011893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19737579 [ RunTime:0.019305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60668661 LIMIT 5 [ RunTime:0.001079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60668661 ORDER BY `minOrder` ASC [ RunTime:0.003883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60668661 ORDER BY `unit` DESC [ RunTime:0.003557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60668661 LIMIT 2 [ RunTime:0.003515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60668661 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='54121-807041050LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.016427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54121-807041050LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002339s ]
SELECT `id` FROM `stock` WHERE `id` <> 60668661 AND `partno` = '54121-807041050LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11450198 [ RunTime:0.005866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60322600 LIMIT 5 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60322600 ORDER BY `minOrder` ASC [ RunTime:0.011539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60322600 ORDER BY `unit` DESC [ RunTime:0.005797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60322600 LIMIT 2 [ RunTime:0.006626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60322600 ORDER BY `minOrder` ASC [ RunTime:0.003036s ]
select * from pdf where partno='54123-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54123-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002020s ]
SELECT `id` FROM `stock` WHERE `id` <> 60322600 AND `partno` = '54123-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60686326 LIMIT 5 [ RunTime:0.015717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60686326 ORDER BY `minOrder` ASC [ RunTime:0.002450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60686326 ORDER BY `unit` DESC [ RunTime:0.004614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60686326 LIMIT 2 [ RunTime:0.004169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60686326 ORDER BY `minOrder` ASC [ RunTime:0.002021s ]
select * from pdf where partno='54122-104500800LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.009115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-104500800LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.005950s ]
SELECT `id` FROM `stock` WHERE `id` <> 60686326 AND `partno` = '54122-104500800LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.005408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19698435 [ RunTime:0.015718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63820948 LIMIT 5 [ RunTime:0.003666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820948 ORDER BY `minOrder` ASC [ RunTime:0.002565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63820948 ORDER BY `unit` DESC [ RunTime:0.003724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63820948 LIMIT 2 [ RunTime:0.020194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820948 ORDER BY `minOrder` ASC [ RunTime:0.007393s ]
select * from pdf where partno='54122W/B' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.000950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122W/B' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.011630s ]
SELECT `id` FROM `stock` WHERE `id` <> 63820948 AND `partno` = '54122W/B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.012245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234465 [ RunTime:0.001782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60669445 LIMIT 5 [ RunTime:0.001675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60669445 ORDER BY `minOrder` ASC [ RunTime:0.017538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60669445 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60669445 LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60669445 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='54121-808031450LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.011972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54121-808031450LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.005929s ]
SELECT `id` FROM `stock` WHERE `id` <> 60669445 AND `partno` = '54121-808031450LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16176372 [ RunTime:0.007255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60671856 LIMIT 5 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60671856 ORDER BY `minOrder` ASC [ RunTime:0.008507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60671856 ORDER BY `unit` DESC [ RunTime:0.001639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60671856 LIMIT 2 [ RunTime:0.004971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60671856 ORDER BY `minOrder` ASC [ RunTime:0.001980s ]
select * from pdf where partno='54122-411062300RLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-411062300RLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004548s ]
SELECT `id` FROM `stock` WHERE `id` <> 60671856 AND `partno` = '54122-411062300RLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11455895 [ RunTime:0.001778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60671019 LIMIT 5 [ RunTime:0.005024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60671019 ORDER BY `minOrder` ASC [ RunTime:0.002754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60671019 ORDER BY `unit` DESC [ RunTime:0.010466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60671019 LIMIT 2 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60671019 ORDER BY `minOrder` ASC [ RunTime:0.014154s ]
select * from pdf where partno='54121-108051650LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.010565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54121-108051650LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003548s ]
SELECT `id` FROM `stock` WHERE `id` <> 60671019 AND `partno` = '54121-108051650LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63820978 LIMIT 5 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820978 ORDER BY `minOrder` ASC [ RunTime:0.012896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63820978 ORDER BY `unit` DESC [ RunTime:0.007494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63820978 LIMIT 2 [ RunTime:0.002717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820978 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='54123/BFA' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.000540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54123/BFA' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.002037s ]
SELECT `id` FROM `stock` WHERE `id` <> 63820978 AND `partno` = '54123/BFA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.001392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15325712 [ RunTime:0.009549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63820954 LIMIT 5 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820954 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63820954 ORDER BY `unit` DESC [ RunTime:0.005353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63820954 LIMIT 2 [ RunTime:0.003596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820954 ORDER BY `minOrder` ASC [ RunTime:0.002197s ]
select * from pdf where partno='54121/BDA' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.004484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54121/BDA' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.001097s ]
SELECT `id` FROM `stock` WHERE `id` <> 63820954 AND `partno` = '54121/BDA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.005232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19177859 [ RunTime:0.007174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60697787 LIMIT 5 [ RunTime:0.002840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60697787 ORDER BY `minOrder` ASC [ RunTime:0.002477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60697787 ORDER BY `unit` DESC [ RunTime:0.009825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60697787 LIMIT 2 [ RunTime:0.001844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60697787 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='54121-802050800LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54121-802050800LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003665s ]
SELECT `id` FROM `stock` WHERE `id` <> 60697787 AND `partno` = '54121-802050800LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12582471 [ RunTime:0.002653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63049065 LIMIT 5 [ RunTime:0.003244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63049065 ORDER BY `minOrder` ASC [ RunTime:0.002378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63049065 ORDER BY `unit` DESC [ RunTime:0.002372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63049065 LIMIT 2 [ RunTime:0.002825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63049065 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='541201 WH002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '541201 WH002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.011895s ]
SELECT `id` FROM `stock` WHERE `id` <> 63049065 AND `partno` = '541201 WH002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14372565 [ RunTime:0.009581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60699500 LIMIT 5 [ RunTime:0.013463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60699500 ORDER BY `minOrder` ASC [ RunTime:0.005377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60699500 ORDER BY `unit` DESC [ RunTime:0.007340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60699500 LIMIT 2 [ RunTime:0.003536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60699500 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='54122-820162000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-820162000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000795s ]
SELECT `id` FROM `stock` WHERE `id` <> 60699500 AND `partno` = '54122-820162000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16177256 [ RunTime:0.003401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60699236 LIMIT 5 [ RunTime:0.005625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60699236 ORDER BY `minOrder` ASC [ RunTime:0.024038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60699236 ORDER BY `unit` DESC [ RunTime:0.000911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60699236 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60699236 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='54122-806140850LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-806140850LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003105s ]
SELECT `id` FROM `stock` WHERE `id` <> 60699236 AND `partno` = '54122-806140850LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.006159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19741313 [ RunTime:0.003003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60679603 LIMIT 5 [ RunTime:0.001355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60679603 ORDER BY `minOrder` ASC [ RunTime:0.001123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60679603 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60679603 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60679603 ORDER BY `minOrder` ASC [ RunTime:0.001957s ]
select * from pdf where partno='54122-820222000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-820222000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000761s ]
SELECT `id` FROM `stock` WHERE `id` <> 60679603 AND `partno` = '54122-820222000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19673116 [ RunTime:0.001393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60678903 LIMIT 5 [ RunTime:0.003057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60678903 ORDER BY `minOrder` ASC [ RunTime:0.001716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60678903 ORDER BY `unit` DESC [ RunTime:0.003990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60678903 LIMIT 2 [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60678903 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='54122-110161800LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-110161800LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000749s ]
SELECT `id` FROM `stock` WHERE `id` <> 60678903 AND `partno` = '54122-110161800LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19746860 [ RunTime:0.004656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60677763 LIMIT 5 [ RunTime:0.003523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60677763 ORDER BY `minOrder` ASC [ RunTime:0.010198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60677763 ORDER BY `unit` DESC [ RunTime:0.006092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60677763 LIMIT 2 [ RunTime:0.006229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60677763 ORDER BY `minOrder` ASC [ RunTime:0.003726s ]
select * from pdf where partno='54122-114101800LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-114101800LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004498s ]
SELECT `id` FROM `stock` WHERE `id` <> 60677763 AND `partno` = '54122-114101800LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19746325 [ RunTime:0.002273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60676196 LIMIT 5 [ RunTime:0.002375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60676196 ORDER BY `minOrder` ASC [ RunTime:0.010712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60676196 ORDER BY `unit` DESC [ RunTime:0.004990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60676196 LIMIT 2 [ RunTime:0.002065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60676196 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='54122-108141300LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-108141300LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.012003s ]
SELECT `id` FROM `stock` WHERE `id` <> 60676196 AND `partno` = '54122-108141300LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12594782 [ RunTime:0.010671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60677656 LIMIT 5 [ RunTime:0.003642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60677656 ORDER BY `minOrder` ASC [ RunTime:0.002187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60677656 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60677656 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60677656 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='54122-114201800LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54122-114201800LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001891s ]
SELECT `id` FROM `stock` WHERE `id` <> 60677656 AND `partno` = '54122-114201800LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19746279 [ RunTime:0.005189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63783157 LIMIT 5 [ RunTime:0.003672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63783157 ORDER BY `minOrder` ASC [ RunTime:0.003042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63783157 ORDER BY `unit` DESC [ RunTime:0.000944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63783157 LIMIT 2 [ RunTime:0.007823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63783157 ORDER BY `minOrder` ASC [ RunTime:0.000706s ]
select * from pdf where partno='54126W/B' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.002297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54126W/B' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.003004s ]
SELECT `id` FROM `stock` WHERE `id` <> 63783157 AND `partno` = '54126W/B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.002011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19185214 [ RunTime:0.005790s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001635s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004950s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001320s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004582s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004943s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006546s ]
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 '5412%' OR `brand` LIKE '5412%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001382s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5412%' OR `brand` LIKE '5412%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016867s ]