SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002462s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026695s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14435325 LIMIT 5 [ RunTime:0.025069s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14435325 ORDER BY `minOrder` ASC [ RunTime:0.027750s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14435325 ORDER BY `unit` DESC [ RunTime:0.012684s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14435325 LIMIT 2 [ RunTime:0.021719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14435325 ORDER BY `minOrder` ASC [ RunTime:0.017368s ]
select * from pdf where partno='232011-06' and brandshort='Qualtek' limit 1 [ RunTime:0.022899s ]
select foldpath,foldpath2,filename from pdf_file where id=758912 limit 1 [ RunTime:0.034712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14435295 LIMIT 5 [ RunTime:0.004632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14435295 ORDER BY `minOrder` ASC [ RunTime:0.010977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14435295 ORDER BY `unit` DESC [ RunTime:0.007393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14435295 LIMIT 2 [ RunTime:0.005490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14435295 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
select * from pdf where partno='232015-06' and brandshort='Qualtek' limit 1 [ RunTime:0.001082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14067841 LIMIT 5 [ RunTime:0.001145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14067841 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14067841 ORDER BY `unit` DESC [ RunTime:0.003020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14067841 LIMIT 2 [ RunTime:0.005171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14067841 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13174657 LIMIT 5 [ RunTime:0.003187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13174657 ORDER BY `minOrder` ASC [ RunTime:0.009670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13174657 ORDER BY `unit` DESC [ RunTime:0.010478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13174657 LIMIT 2 [ RunTime:0.019647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13174657 ORDER BY `minOrder` ASC [ RunTime:0.011580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13174683 LIMIT 5 [ RunTime:0.014127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13174683 ORDER BY `minOrder` ASC [ RunTime:0.015484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13174683 ORDER BY `unit` DESC [ RunTime:0.011920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13174683 LIMIT 2 [ RunTime:0.033296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13174683 ORDER BY `minOrder` ASC [ RunTime:0.005854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008821 LIMIT 5 [ RunTime:0.017648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008821 ORDER BY `minOrder` ASC [ RunTime:0.008391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15008821 ORDER BY `unit` DESC [ RunTime:0.010140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15008821 LIMIT 2 [ RunTime:0.002920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008821 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14069001 LIMIT 5 [ RunTime:0.001163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14069001 ORDER BY `minOrder` ASC [ RunTime:0.003494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14069001 ORDER BY `unit` DESC [ RunTime:0.007534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14069001 LIMIT 2 [ RunTime:0.002435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14069001 ORDER BY `minOrder` ASC [ RunTime:0.001146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008688 LIMIT 5 [ RunTime:0.017011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008688 ORDER BY `minOrder` ASC [ RunTime:0.012637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15008688 ORDER BY `unit` DESC [ RunTime:0.024400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15008688 LIMIT 2 [ RunTime:0.005972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008688 ORDER BY `minOrder` ASC [ RunTime:0.001795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14068863 LIMIT 5 [ RunTime:0.002303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068863 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14068863 ORDER BY `unit` DESC [ RunTime:0.003997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14068863 LIMIT 2 [ RunTime:0.011671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068863 ORDER BY `minOrder` ASC [ RunTime:0.001250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14068861 LIMIT 5 [ RunTime:0.017541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068861 ORDER BY `minOrder` ASC [ RunTime:0.002277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14068861 ORDER BY `unit` DESC [ RunTime:0.001819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14068861 LIMIT 2 [ RunTime:0.023347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068861 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14068874 LIMIT 5 [ RunTime:0.002047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068874 ORDER BY `minOrder` ASC [ RunTime:0.004684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14068874 ORDER BY `unit` DESC [ RunTime:0.020081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14068874 LIMIT 2 [ RunTime:0.002000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068874 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457453 LIMIT 5 [ RunTime:0.001052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457453 ORDER BY `minOrder` ASC [ RunTime:0.001944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457453 ORDER BY `unit` DESC [ RunTime:0.001447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457453 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457453 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19015006 LIMIT 5 [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19015006 ORDER BY `minOrder` ASC [ RunTime:0.006399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19015006 ORDER BY `unit` DESC [ RunTime:0.010558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19015006 LIMIT 2 [ RunTime:0.001523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19015006 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19002974 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002974 ORDER BY `minOrder` ASC [ RunTime:0.003332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19002974 ORDER BY `unit` DESC [ RunTime:0.002250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19002974 LIMIT 2 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002974 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19002650 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002650 ORDER BY `minOrder` ASC [ RunTime:0.002439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19002650 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19002650 LIMIT 2 [ RunTime:0.002835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002650 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754005 LIMIT 5 [ RunTime:0.004226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754005 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754005 ORDER BY `unit` DESC [ RunTime:0.003733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754005 LIMIT 2 [ RunTime:0.006415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754005 ORDER BY `minOrder` ASC [ RunTime:0.003382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433225 LIMIT 5 [ RunTime:0.005898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433225 ORDER BY `minOrder` ASC [ RunTime:0.005509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433225 ORDER BY `unit` DESC [ RunTime:0.001582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433225 LIMIT 2 [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433225 ORDER BY `minOrder` ASC [ RunTime:0.001239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14067819 LIMIT 5 [ RunTime:0.005682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14067819 ORDER BY `minOrder` ASC [ RunTime:0.002546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14067819 ORDER BY `unit` DESC [ RunTime:0.023293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14067819 LIMIT 2 [ RunTime:0.015645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14067819 ORDER BY `minOrder` ASC [ RunTime:0.006629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13566543 LIMIT 5 [ RunTime:0.014092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13566543 ORDER BY `minOrder` ASC [ RunTime:0.013487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13566543 ORDER BY `unit` DESC [ RunTime:0.012288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13566543 LIMIT 2 [ RunTime:0.001747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13566543 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='232010-06' and brandshort='Qualtek' limit 1 [ RunTime:0.001208s ]
select foldpath,foldpath2,filename from pdf_file where id=758911 limit 1 [ RunTime:0.009997s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002357s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48587362 LIMIT 5 [ RunTime:0.001946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48587362 ORDER BY `minOrder` ASC [ RunTime:0.001079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48587362 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48587362 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48587362 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='232015-06' and brandshort='Qualtek' limit 1 [ RunTime:0.000804s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '232015-06' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.000406s ]
SELECT `id` FROM `stock` WHERE `id` <> 48587362 AND `partno` = '232015-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.003641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14435295 [ RunTime:0.005750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35784099 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35784099 ORDER BY `minOrder` ASC [ RunTime:0.001618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35784099 ORDER BY `unit` DESC [ RunTime:0.001293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35784099 LIMIT 2 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35784099 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='232015-06' and brandshort='Qualtek' limit 1 [ RunTime:0.000464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '232015-06' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.003812s ]
SELECT `id` FROM `stock` WHERE `id` <> 35784099 AND `partno` = '232015-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.010335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14435295 [ RunTime:0.002194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48587627 LIMIT 5 [ RunTime:0.001728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48587627 ORDER BY `minOrder` ASC [ RunTime:0.001750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48587627 ORDER BY `unit` DESC [ RunTime:0.008586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48587627 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48587627 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='232011-06' and brandshort='Qualtek' limit 1 [ RunTime:0.001478s ]
select foldpath,foldpath2,filename from pdf_file where id=758912 limit 1 [ RunTime:0.000304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '232011-06' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.002743s ]
SELECT `id` FROM `stock` WHERE `id` <> 48587627 AND `partno` = '232011-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.001563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14435325 [ RunTime:0.004043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35784365 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35784365 ORDER BY `minOrder` ASC [ RunTime:0.002337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35784365 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35784365 LIMIT 2 [ RunTime:0.002175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35784365 ORDER BY `minOrder` ASC [ RunTime:0.002647s ]
select * from pdf where partno='232011-06' and brandshort='Qualtek' limit 1 [ RunTime:0.000471s ]
select foldpath,foldpath2,filename from pdf_file where id=758912 limit 1 [ RunTime:0.000306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '232011-06' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.000460s ]
SELECT `id` FROM `stock` WHERE `id` <> 35784365 AND `partno` = '232011-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.006824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14435325 [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51762882 LIMIT 5 [ RunTime:0.002984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51762882 ORDER BY `minOrder` ASC [ RunTime:0.003277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51762882 ORDER BY `unit` DESC [ RunTime:0.002631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51762882 LIMIT 2 [ RunTime:0.004451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51762882 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='2320157' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320157' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38232815 LIMIT 5 [ RunTime:0.002117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38232815 ORDER BY `minOrder` ASC [ RunTime:0.005978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38232815 ORDER BY `unit` DESC [ RunTime:0.005575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38232815 LIMIT 2 [ RunTime:0.008591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38232815 ORDER BY `minOrder` ASC [ RunTime:0.002234s ]
select * from pdf where partno='2320115' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320115' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50802384 LIMIT 5 [ RunTime:0.008117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50802384 ORDER BY `minOrder` ASC [ RunTime:0.001339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50802384 ORDER BY `unit` DESC [ RunTime:0.003956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50802384 LIMIT 2 [ RunTime:0.004300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50802384 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='2320115' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320115' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53792788 LIMIT 5 [ RunTime:0.002990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53792788 ORDER BY `minOrder` ASC [ RunTime:0.020629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53792788 ORDER BY `unit` DESC [ RunTime:0.006690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53792788 LIMIT 2 [ RunTime:0.007975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53792788 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='232016003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '232016003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002459s ]
SELECT `id` FROM `stock` WHERE `id` <> 53792788 AND `partno` = '232016003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13174657 [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53792830 LIMIT 5 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53792830 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53792830 ORDER BY `unit` DESC [ RunTime:0.002670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53792830 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53792830 ORDER BY `minOrder` ASC [ RunTime:0.001924s ]
select * from pdf where partno='232017003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '232017003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id` FROM `stock` WHERE `id` <> 53792830 AND `partno` = '232017003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13174683 [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49248607 LIMIT 5 [ RunTime:0.003879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49248607 ORDER BY `minOrder` ASC [ RunTime:0.003521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49248607 ORDER BY `unit` DESC [ RunTime:0.004596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49248607 LIMIT 2 [ RunTime:0.003190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49248607 ORDER BY `minOrder` ASC [ RunTime:0.005268s ]
select * from pdf where partno='23201.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.003556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23201.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004218s ]
SELECT `id` FROM `stock` WHERE `id` <> 49248607 AND `partno` = '23201.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.006310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36452173 [ RunTime:0.004624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36452173 LIMIT 5 [ RunTime:0.002354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36452173 ORDER BY `minOrder` ASC [ RunTime:0.001473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36452173 ORDER BY `unit` DESC [ RunTime:0.000810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36452173 LIMIT 2 [ RunTime:0.003344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36452173 ORDER BY `minOrder` ASC [ RunTime:0.006079s ]
select * from pdf where partno='23201.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23201.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.000500s ]
SELECT `id` FROM `stock` WHERE `id` <> 36452173 AND `partno` = '23201.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.001938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49248607 [ RunTime:0.002381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50802401 LIMIT 5 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50802401 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50802401 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50802401 LIMIT 2 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50802401 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='2320144' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320144' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38233375 LIMIT 5 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38233375 ORDER BY `minOrder` ASC [ RunTime:0.001486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38233375 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38233375 LIMIT 2 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38233375 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='2320144' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320144' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51290612 LIMIT 5 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51290612 ORDER BY `minOrder` ASC [ RunTime:0.003498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51290612 ORDER BY `unit` DESC [ RunTime:0.009282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51290612 LIMIT 2 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51290612 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='2320186' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320186' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51766418 LIMIT 5 [ RunTime:0.001853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51766418 ORDER BY `minOrder` ASC [ RunTime:0.002033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51766418 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51766418 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51766418 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='2320160' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320160' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50803040 LIMIT 5 [ RunTime:0.003774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50803040 ORDER BY `minOrder` ASC [ RunTime:0.001862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50803040 ORDER BY `unit` DESC [ RunTime:0.000302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50803040 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50803040 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
select * from pdf where partno='2320131' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320131' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38233691 LIMIT 5 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38233691 ORDER BY `minOrder` ASC [ RunTime:0.004473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38233691 ORDER BY `unit` DESC [ RunTime:0.002082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38233691 LIMIT 2 [ RunTime:0.002652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38233691 ORDER BY `minOrder` ASC [ RunTime:0.003846s ]
select * from pdf where partno='2320131' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320131' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38233388 LIMIT 5 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38233388 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38233388 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38233388 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38233388 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='2320102' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320102' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50802862 LIMIT 5 [ RunTime:0.003944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50802862 ORDER BY `minOrder` ASC [ RunTime:0.018691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50802862 ORDER BY `unit` DESC [ RunTime:0.011330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50802862 LIMIT 2 [ RunTime:0.010410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50802862 ORDER BY `minOrder` ASC [ RunTime:0.011557s ]
select * from pdf where partno='2320102' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320102' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51290610 LIMIT 5 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51290610 ORDER BY `minOrder` ASC [ RunTime:0.001553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51290610 ORDER BY `unit` DESC [ RunTime:0.002284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51290610 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51290610 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='2320173' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2320173' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000452s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001333s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006589s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001287s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006729s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018081s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007759s ]
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 '23201%' OR `brand` LIKE '23201%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008562s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '23201%' OR `brand` LIKE '23201%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022300s ]