SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001691s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032182s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16026053 LIMIT 5 [ RunTime:0.031956s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16026053 ORDER BY `minOrder` ASC [ RunTime:0.015538s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16026053 ORDER BY `unit` DESC [ RunTime:0.006812s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16026053 LIMIT 2 [ RunTime:0.034996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16026053 ORDER BY `minOrder` ASC [ RunTime:0.005200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15287676 LIMIT 5 [ RunTime:0.017607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15287676 ORDER BY `minOrder` ASC [ RunTime:0.033885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15287676 ORDER BY `unit` DESC [ RunTime:0.034562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15287676 LIMIT 2 [ RunTime:0.008911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15287676 ORDER BY `minOrder` ASC [ RunTime:0.016248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17069571 LIMIT 5 [ RunTime:0.026793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17069571 ORDER BY `minOrder` ASC [ RunTime:0.019968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17069571 ORDER BY `unit` DESC [ RunTime:0.025920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17069571 LIMIT 2 [ RunTime:0.049666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17069571 ORDER BY `minOrder` ASC [ RunTime:0.016020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19063617 LIMIT 5 [ RunTime:0.015807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19063617 ORDER BY `minOrder` ASC [ RunTime:0.018955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19063617 ORDER BY `unit` DESC [ RunTime:0.023192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19063617 LIMIT 2 [ RunTime:0.021460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19063617 ORDER BY `minOrder` ASC [ RunTime:0.012124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19063517 LIMIT 5 [ RunTime:0.014511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19063517 ORDER BY `minOrder` ASC [ RunTime:0.006166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19063517 ORDER BY `unit` DESC [ RunTime:0.020808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19063517 LIMIT 2 [ RunTime:0.039156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19063517 ORDER BY `minOrder` ASC [ RunTime:0.019823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16086929 LIMIT 5 [ RunTime:0.034096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16086929 ORDER BY `minOrder` ASC [ RunTime:0.020956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16086929 ORDER BY `unit` DESC [ RunTime:0.013363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16086929 LIMIT 2 [ RunTime:0.009679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16086929 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14232685 LIMIT 5 [ RunTime:0.009814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14232685 ORDER BY `minOrder` ASC [ RunTime:0.015480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14232685 ORDER BY `unit` DESC [ RunTime:0.002907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14232685 LIMIT 2 [ RunTime:0.003194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14232685 ORDER BY `minOrder` ASC [ RunTime:0.004924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16026386 LIMIT 5 [ RunTime:0.003950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16026386 ORDER BY `minOrder` ASC [ RunTime:0.005837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16026386 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16026386 LIMIT 2 [ RunTime:0.002312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16026386 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14211724 LIMIT 5 [ RunTime:0.004003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14211724 ORDER BY `minOrder` ASC [ RunTime:0.006575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14211724 ORDER BY `unit` DESC [ RunTime:0.003786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14211724 LIMIT 2 [ RunTime:0.007315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14211724 ORDER BY `minOrder` ASC [ RunTime:0.006897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19063505 LIMIT 5 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19063505 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19063505 ORDER BY `unit` DESC [ RunTime:0.009949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19063505 LIMIT 2 [ RunTime:0.010058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19063505 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17070115 LIMIT 5 [ RunTime:0.000997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17070115 ORDER BY `minOrder` ASC [ RunTime:0.005825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17070115 ORDER BY `unit` DESC [ RunTime:0.001573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17070115 LIMIT 2 [ RunTime:0.005957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17070115 ORDER BY `minOrder` ASC [ RunTime:0.004792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16087177 LIMIT 5 [ RunTime:0.012615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16087177 ORDER BY `minOrder` ASC [ RunTime:0.025455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16087177 ORDER BY `unit` DESC [ RunTime:0.005702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16087177 LIMIT 2 [ RunTime:0.027881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16087177 ORDER BY `minOrder` ASC [ RunTime:0.005274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17070116 LIMIT 5 [ RunTime:0.012464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17070116 ORDER BY `minOrder` ASC [ RunTime:0.005481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17070116 ORDER BY `unit` DESC [ RunTime:0.010419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17070116 LIMIT 2 [ RunTime:0.002038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17070116 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19169526 LIMIT 5 [ RunTime:0.014007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19169526 ORDER BY `minOrder` ASC [ RunTime:0.016874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19169526 ORDER BY `unit` DESC [ RunTime:0.014719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19169526 LIMIT 2 [ RunTime:0.010223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19169526 ORDER BY `minOrder` ASC [ RunTime:0.006777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19169525 LIMIT 5 [ RunTime:0.004666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19169525 ORDER BY `minOrder` ASC [ RunTime:0.004304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19169525 ORDER BY `unit` DESC [ RunTime:0.017594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19169525 LIMIT 2 [ RunTime:0.016071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19169525 ORDER BY `minOrder` ASC [ RunTime:0.008638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064873 LIMIT 5 [ RunTime:0.013817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064873 ORDER BY `minOrder` ASC [ RunTime:0.009055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19064873 ORDER BY `unit` DESC [ RunTime:0.023885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19064873 LIMIT 2 [ RunTime:0.026995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064873 ORDER BY `minOrder` ASC [ RunTime:0.013181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064870 LIMIT 5 [ RunTime:0.008002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064870 ORDER BY `minOrder` ASC [ RunTime:0.004053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19064870 ORDER BY `unit` DESC [ RunTime:0.013361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19064870 LIMIT 2 [ RunTime:0.015832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064870 ORDER BY `minOrder` ASC [ RunTime:0.004833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064869 LIMIT 5 [ RunTime:0.001054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064869 ORDER BY `minOrder` ASC [ RunTime:0.018198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19064869 ORDER BY `unit` DESC [ RunTime:0.008214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19064869 LIMIT 2 [ RunTime:0.003446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064869 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064868 LIMIT 5 [ RunTime:0.001758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064868 ORDER BY `minOrder` ASC [ RunTime:0.007407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19064868 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19064868 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064868 ORDER BY `minOrder` ASC [ RunTime:0.006898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064866 LIMIT 5 [ RunTime:0.001755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064866 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19064866 ORDER BY `unit` DESC [ RunTime:0.000318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19064866 LIMIT 2 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19064866 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000851s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57015453 LIMIT 5 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57015453 ORDER BY `minOrder` ASC [ RunTime:0.007442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57015453 ORDER BY `unit` DESC [ RunTime:0.002212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57015453 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57015453 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
select * from pdf where partno='DS2760BE/T&R' and brandshort='Dallas Semiconductor' limit 1 [ RunTime:0.009151s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2760BE/T&R' OR `brand` LIKE 'Dallas Semiconductor%' ) ) LIMIT 1 [ RunTime:0.023264s ]
SELECT `id` FROM `stock` WHERE `id` <> 57015453 AND `partno` = 'DS2760BE/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dallas semiconductor%' ) [ RunTime:0.014842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19063617 [ RunTime:0.013988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57014600 LIMIT 5 [ RunTime:0.012915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014600 ORDER BY `minOrder` ASC [ RunTime:0.005914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57014600 ORDER BY `unit` DESC [ RunTime:0.002238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57014600 LIMIT 2 [ RunTime:0.007199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014600 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
select * from pdf where partno='DS2762AE+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.007219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2762AE+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.022466s ]
SELECT `id` FROM `stock` WHERE `id` <> 57014600 AND `partno` = 'DS2762AE+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17070116 [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57014405 LIMIT 5 [ RunTime:0.003724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014405 ORDER BY `minOrder` ASC [ RunTime:0.007481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57014405 ORDER BY `unit` DESC [ RunTime:0.007817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57014405 LIMIT 2 [ RunTime:0.004325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014405 ORDER BY `minOrder` ASC [ RunTime:0.024140s ]
select * from pdf where partno='DS2764AE+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.035090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2764AE+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.030211s ]
SELECT `id` FROM `stock` WHERE `id` <> 57014405 AND `partno` = 'DS2764AE+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.017061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14211724 [ RunTime:0.009256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57014601 LIMIT 5 [ RunTime:0.034868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014601 ORDER BY `minOrder` ASC [ RunTime:0.019583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57014601 ORDER BY `unit` DESC [ RunTime:0.012010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57014601 LIMIT 2 [ RunTime:0.052240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014601 ORDER BY `minOrder` ASC [ RunTime:0.007439s ]
select * from pdf where partno='DS2762BE+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.030805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2762BE+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.010577s ]
SELECT `id` FROM `stock` WHERE `id` <> 57014601 AND `partno` = 'DS2762BE+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.013944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17070115 [ RunTime:0.013916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57014597 LIMIT 5 [ RunTime:0.041078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014597 ORDER BY `minOrder` ASC [ RunTime:0.015263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57014597 ORDER BY `unit` DESC [ RunTime:0.010373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57014597 LIMIT 2 [ RunTime:0.016676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57014597 ORDER BY `minOrder` ASC [ RunTime:0.016457s ]
select * from pdf where partno='DS2764BE+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.026505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2764BE+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.004816s ]
SELECT `id` FROM `stock` WHERE `id` <> 57014597 AND `partno` = 'DS2764BE+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.017876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15288339 [ RunTime:0.010780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57017936 LIMIT 5 [ RunTime:0.020024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017936 ORDER BY `minOrder` ASC [ RunTime:0.011589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57017936 ORDER BY `unit` DESC [ RunTime:0.032773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57017936 LIMIT 2 [ RunTime:0.024600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017936 ORDER BY `minOrder` ASC [ RunTime:0.025463s ]
select * from pdf where partno='DS2762AE+025' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.016291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2762AE+025' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.049683s ]
SELECT `id` FROM `stock` WHERE `id` <> 57017936 AND `partno` = 'DS2762AE+025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.035689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064746 [ RunTime:0.041967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57017922 LIMIT 5 [ RunTime:0.052313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017922 ORDER BY `minOrder` ASC [ RunTime:0.033718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57017922 ORDER BY `unit` DESC [ RunTime:0.026147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57017922 LIMIT 2 [ RunTime:0.021900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017922 ORDER BY `minOrder` ASC [ RunTime:0.024211s ]
select * from pdf where partno='DS2762BE+025' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.008518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2762BE+025' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.009117s ]
SELECT `id` FROM `stock` WHERE `id` <> 57017922 AND `partno` = 'DS2762BE+025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.043917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064739 [ RunTime:0.017165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57017890 LIMIT 5 [ RunTime:0.028757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017890 ORDER BY `minOrder` ASC [ RunTime:0.044389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57017890 ORDER BY `unit` DESC [ RunTime:0.041908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57017890 LIMIT 2 [ RunTime:0.026964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017890 ORDER BY `minOrder` ASC [ RunTime:0.012032s ]
select * from pdf where partno='DS2764BE+025' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.037101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2764BE+025' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.018205s ]
SELECT `id` FROM `stock` WHERE `id` <> 57017890 AND `partno` = 'DS2764BE+025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.013896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17070013 [ RunTime:0.026254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57017863 LIMIT 5 [ RunTime:0.102325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017863 ORDER BY `minOrder` ASC [ RunTime:0.022096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57017863 ORDER BY `unit` DESC [ RunTime:0.028448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57017863 LIMIT 2 [ RunTime:0.031962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017863 ORDER BY `minOrder` ASC [ RunTime:0.052507s ]
select * from pdf where partno='DS2762BE+025/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.019633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2762BE+025/T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.022136s ]
SELECT `id` FROM `stock` WHERE `id` <> 57017863 AND `partno` = 'DS2762BE+025/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.034476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15288261 [ RunTime:0.023452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57017791 LIMIT 5 [ RunTime:0.029468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017791 ORDER BY `minOrder` ASC [ RunTime:0.039815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57017791 ORDER BY `unit` DESC [ RunTime:0.008527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57017791 LIMIT 2 [ RunTime:0.006879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017791 ORDER BY `minOrder` ASC [ RunTime:0.010666s ]
select * from pdf where partno='DS2762AE+025/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.006191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2762AE+025/T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.004488s ]
SELECT `id` FROM `stock` WHERE `id` <> 57017791 AND `partno` = 'DS2762AE+025/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.011207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17070003 [ RunTime:0.015733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57017782 LIMIT 5 [ RunTime:0.004356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017782 ORDER BY `minOrder` ASC [ RunTime:0.013259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57017782 ORDER BY `unit` DESC [ RunTime:0.008331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57017782 LIMIT 2 [ RunTime:0.002804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017782 ORDER BY `minOrder` ASC [ RunTime:0.002902s ]
select * from pdf where partno='DS2764BE+025/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.016536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2764BE+025/T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.011889s ]
SELECT `id` FROM `stock` WHERE `id` <> 57017782 AND `partno` = 'DS2764BE+025/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.004015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064684 [ RunTime:0.014869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57017781 LIMIT 5 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017781 ORDER BY `minOrder` ASC [ RunTime:0.003903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57017781 ORDER BY `unit` DESC [ RunTime:0.005411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57017781 LIMIT 2 [ RunTime:0.002923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57017781 ORDER BY `minOrder` ASC [ RunTime:0.002380s ]
select * from pdf where partno='DS2764AE+025/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.005860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2764AE+025/T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.009177s ]
SELECT `id` FROM `stock` WHERE `id` <> 57017781 AND `partno` = 'DS2764AE+025/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.000959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19064683 [ RunTime:0.017466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57015840 LIMIT 5 [ RunTime:0.001079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57015840 ORDER BY `minOrder` ASC [ RunTime:0.003736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57015840 ORDER BY `unit` DESC [ RunTime:0.004621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57015840 LIMIT 2 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57015840 ORDER BY `minOrder` ASC [ RunTime:0.004533s ]
select * from pdf where partno='DS2764AE+025' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.020044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS2764AE+025' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.020674s ]
SELECT `id` FROM `stock` WHERE `id` <> 57015840 AND `partno` = 'DS2764AE+025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.019995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14211476 [ RunTime:0.001290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57011200 LIMIT 5 [ RunTime:0.026146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57011200 ORDER BY `minOrder` ASC [ RunTime:0.013901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57011200 ORDER BY `unit` DESC [ RunTime:0.019428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57011200 LIMIT 2 [ RunTime:0.027903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57011200 ORDER BY `minOrder` ASC [ RunTime:0.008378s ]
select * from pdf where partno='DS276SN+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.006676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS276SN+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.017145s ]
SELECT `id` FROM `stock` WHERE `id` <> 57011200 AND `partno` = 'DS276SN+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.020365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17103267 [ RunTime:0.009254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57010693 LIMIT 5 [ RunTime:0.018790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010693 ORDER BY `minOrder` ASC [ RunTime:0.007620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57010693 ORDER BY `unit` DESC [ RunTime:0.017574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57010693 LIMIT 2 [ RunTime:0.023813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010693 ORDER BY `minOrder` ASC [ RunTime:0.015786s ]
select * from pdf where partno='DS276S+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.023039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS276S+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.028731s ]
SELECT `id` FROM `stock` WHERE `id` <> 57010693 AND `partno` = 'DS276S+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.018241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19169525 [ RunTime:0.001848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57010400 LIMIT 5 [ RunTime:0.015159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010400 ORDER BY `minOrder` ASC [ RunTime:0.014545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57010400 ORDER BY `unit` DESC [ RunTime:0.019167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57010400 LIMIT 2 [ RunTime:0.012498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010400 ORDER BY `minOrder` ASC [ RunTime:0.006814s ]
select * from pdf where partno='DS276S+T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.016839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS276S+T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.014307s ]
SELECT `id` FROM `stock` WHERE `id` <> 57010400 AND `partno` = 'DS276S+T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.022403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15322630 [ RunTime:0.062202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57010386 LIMIT 5 [ RunTime:0.022120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010386 ORDER BY `minOrder` ASC [ RunTime:0.020015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57010386 ORDER BY `unit` DESC [ RunTime:0.025643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57010386 LIMIT 2 [ RunTime:0.046428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010386 ORDER BY `minOrder` ASC [ RunTime:0.019149s ]
select * from pdf where partno='DS276S' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.023980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS276S' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.037733s ]
SELECT `id` FROM `stock` WHERE `id` <> 57010386 AND `partno` = 'DS276S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.036178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19169526 [ RunTime:0.065439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57010385 LIMIT 5 [ RunTime:0.012439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010385 ORDER BY `minOrder` ASC [ RunTime:0.014396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57010385 ORDER BY `unit` DESC [ RunTime:0.033350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57010385 LIMIT 2 [ RunTime:0.020477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57010385 ORDER BY `minOrder` ASC [ RunTime:0.008359s ]
select * from pdf where partno='DS276' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.026713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS276' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.026830s ]
SELECT `id` FROM `stock` WHERE `id` <> 57010385 AND `partno` = 'DS276' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.015950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16087035 [ RunTime:0.006122s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022010s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041815s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013172s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057245s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034706s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040919s ]
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 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021925s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DS276%' OR `brand` LIKE 'DS276%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.048447s ]