SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002070s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054108s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401175 LIMIT 5 [ RunTime:0.012937s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401175 ORDER BY `minOrder` ASC [ RunTime:0.004160s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401175 ORDER BY `unit` DESC [ RunTime:0.003991s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401175 LIMIT 2 [ RunTime:0.018459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401175 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14371250 LIMIT 5 [ RunTime:0.015839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14371250 ORDER BY `minOrder` ASC [ RunTime:0.025563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14371250 ORDER BY `unit` DESC [ RunTime:0.022458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14371250 LIMIT 2 [ RunTime:0.029706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14371250 ORDER BY `minOrder` ASC [ RunTime:0.011144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492794 LIMIT 5 [ RunTime:0.028241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492794 ORDER BY `minOrder` ASC [ RunTime:0.016640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492794 ORDER BY `unit` DESC [ RunTime:0.039107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492794 LIMIT 2 [ RunTime:0.040566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492794 ORDER BY `minOrder` ASC [ RunTime:0.006001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489882 LIMIT 5 [ RunTime:0.028366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489882 ORDER BY `minOrder` ASC [ RunTime:0.046179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489882 ORDER BY `unit` DESC [ RunTime:0.010427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489882 LIMIT 2 [ RunTime:0.016648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489882 ORDER BY `minOrder` ASC [ RunTime:0.033078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14364353 LIMIT 5 [ RunTime:0.020820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364353 ORDER BY `minOrder` ASC [ RunTime:0.029208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14364353 ORDER BY `unit` DESC [ RunTime:0.010486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14364353 LIMIT 2 [ RunTime:0.029198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364353 ORDER BY `minOrder` ASC [ RunTime:0.014405s ]
select * from pdf where partno='10981-18-1-2000-002-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.016130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14364350 LIMIT 5 [ RunTime:0.011860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364350 ORDER BY `minOrder` ASC [ RunTime:0.017378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14364350 ORDER BY `unit` DESC [ RunTime:0.006213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14364350 LIMIT 2 [ RunTime:0.017048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364350 ORDER BY `minOrder` ASC [ RunTime:0.005663s ]
select * from pdf where partno='10981-20-1-2000-002-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.008182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14364349 LIMIT 5 [ RunTime:0.020204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364349 ORDER BY `minOrder` ASC [ RunTime:0.014942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14364349 ORDER BY `unit` DESC [ RunTime:0.023450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14364349 LIMIT 2 [ RunTime:0.026852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364349 ORDER BY `minOrder` ASC [ RunTime:0.011034s ]
select * from pdf where partno='10981-20-1-2000-001-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.009201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16408661 LIMIT 5 [ RunTime:0.029549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16408661 ORDER BY `minOrder` ASC [ RunTime:0.009764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16408661 ORDER BY `unit` DESC [ RunTime:0.029877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16408661 LIMIT 2 [ RunTime:0.024942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16408661 ORDER BY `minOrder` ASC [ RunTime:0.031838s ]
select * from pdf where partno='10981-18-1-2000-001-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.021238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401619 LIMIT 5 [ RunTime:0.027484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401619 ORDER BY `minOrder` ASC [ RunTime:0.009239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401619 ORDER BY `unit` DESC [ RunTime:0.039010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401619 LIMIT 2 [ RunTime:0.032443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401619 ORDER BY `minOrder` ASC [ RunTime:0.019840s ]
select * from pdf where partno='10981-18-1-2000-004-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.010699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13490045 LIMIT 5 [ RunTime:0.016764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13490045 ORDER BY `minOrder` ASC [ RunTime:0.046663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13490045 ORDER BY `unit` DESC [ RunTime:0.014963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13490045 LIMIT 2 [ RunTime:0.037853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13490045 ORDER BY `minOrder` ASC [ RunTime:0.020780s ]
select * from pdf where partno='10981-20-1-2000-004-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.018689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13493373 LIMIT 5 [ RunTime:0.005862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13493373 ORDER BY `minOrder` ASC [ RunTime:0.015264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13493373 ORDER BY `unit` DESC [ RunTime:0.034868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13493373 LIMIT 2 [ RunTime:0.003846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13493373 ORDER BY `minOrder` ASC [ RunTime:0.016292s ]
select * from pdf where partno='10981-22-1-2000-002-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.023894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14372001 LIMIT 5 [ RunTime:0.014055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14372001 ORDER BY `minOrder` ASC [ RunTime:0.005846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14372001 ORDER BY `unit` DESC [ RunTime:0.009786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14372001 LIMIT 2 [ RunTime:0.001184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14372001 ORDER BY `minOrder` ASC [ RunTime:0.006242s ]
select * from pdf where partno='10981-22-1-2000-001-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.009349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16408641 LIMIT 5 [ RunTime:0.004396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16408641 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16408641 ORDER BY `unit` DESC [ RunTime:0.002413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16408641 LIMIT 2 [ RunTime:0.015872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16408641 ORDER BY `minOrder` ASC [ RunTime:0.005602s ]
select * from pdf where partno='10981-22-1-2000-004-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.009405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348377 LIMIT 5 [ RunTime:0.013270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348377 ORDER BY `minOrder` ASC [ RunTime:0.006419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348377 ORDER BY `unit` DESC [ RunTime:0.001926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348377 LIMIT 2 [ RunTime:0.012221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348377 ORDER BY `minOrder` ASC [ RunTime:0.008871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16402851 LIMIT 5 [ RunTime:0.010919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16402851 ORDER BY `minOrder` ASC [ RunTime:0.006055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16402851 ORDER BY `unit` DESC [ RunTime:0.006761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16402851 LIMIT 2 [ RunTime:0.001982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16402851 ORDER BY `minOrder` ASC [ RunTime:0.005926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363871 LIMIT 5 [ RunTime:0.001056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363871 ORDER BY `minOrder` ASC [ RunTime:0.004339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363871 ORDER BY `unit` DESC [ RunTime:0.000765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363871 LIMIT 2 [ RunTime:0.010335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363871 ORDER BY `minOrder` ASC [ RunTime:0.007693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363870 LIMIT 5 [ RunTime:0.001703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363870 ORDER BY `minOrder` ASC [ RunTime:0.003681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363870 ORDER BY `unit` DESC [ RunTime:0.001610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363870 LIMIT 2 [ RunTime:0.004223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363870 ORDER BY `minOrder` ASC [ RunTime:0.008603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363863 LIMIT 5 [ RunTime:0.013677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363863 ORDER BY `minOrder` ASC [ RunTime:0.016815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363863 ORDER BY `unit` DESC [ RunTime:0.018356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363863 LIMIT 2 [ RunTime:0.018014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363863 ORDER BY `minOrder` ASC [ RunTime:0.001446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401167 LIMIT 5 [ RunTime:0.008531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401167 ORDER BY `minOrder` ASC [ RunTime:0.004844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401167 ORDER BY `unit` DESC [ RunTime:0.018885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401167 LIMIT 2 [ RunTime:0.045939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401167 ORDER BY `minOrder` ASC [ RunTime:0.013127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363864 LIMIT 5 [ RunTime:0.012387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363864 ORDER BY `minOrder` ASC [ RunTime:0.028076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363864 ORDER BY `unit` DESC [ RunTime:0.008925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363864 LIMIT 2 [ RunTime:0.028173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363864 ORDER BY `minOrder` ASC [ RunTime:0.011194s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275756 LIMIT 5 [ RunTime:0.002839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275756 ORDER BY `minOrder` ASC [ RunTime:0.003120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275756 ORDER BY `unit` DESC [ RunTime:0.013948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275756 LIMIT 2 [ RunTime:0.047961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275756 ORDER BY `minOrder` ASC [ RunTime:0.014086s ]
select * from pdf where partno='1098171' and brandshort='phoenix contact' limit 1 [ RunTime:0.010802s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098171' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.026251s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046030 LIMIT 5 [ RunTime:0.019372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046030 ORDER BY `minOrder` ASC [ RunTime:0.017679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046030 ORDER BY `unit` DESC [ RunTime:0.016018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046030 LIMIT 2 [ RunTime:0.016478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046030 ORDER BY `minOrder` ASC [ RunTime:0.027446s ]
select * from pdf where partno='10981-22-1-2000-001-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.013353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-22-1-2000-001-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.020969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046124 LIMIT 5 [ RunTime:0.025567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046124 ORDER BY `minOrder` ASC [ RunTime:0.019541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046124 ORDER BY `unit` DESC [ RunTime:0.010808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046124 LIMIT 2 [ RunTime:0.008208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046124 ORDER BY `minOrder` ASC [ RunTime:0.016876s ]
select * from pdf where partno='10981-20-1-2000-002-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.001688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-20-1-2000-002-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.037547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046125 LIMIT 5 [ RunTime:0.018885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046125 ORDER BY `minOrder` ASC [ RunTime:0.013992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046125 ORDER BY `unit` DESC [ RunTime:0.005621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046125 LIMIT 2 [ RunTime:0.012396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046125 ORDER BY `minOrder` ASC [ RunTime:0.019919s ]
select * from pdf where partno='10981-20-1-2000-001-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.006623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-20-1-2000-001-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.023024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046198 LIMIT 5 [ RunTime:0.012779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046198 ORDER BY `minOrder` ASC [ RunTime:0.016719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046198 ORDER BY `unit` DESC [ RunTime:0.030623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046198 LIMIT 2 [ RunTime:0.045111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046198 ORDER BY `minOrder` ASC [ RunTime:0.018103s ]
select * from pdf where partno='10981-18-1-2000-002-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.010102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-18-1-2000-002-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.028578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046126 LIMIT 5 [ RunTime:0.009330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046126 ORDER BY `minOrder` ASC [ RunTime:0.010168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046126 ORDER BY `unit` DESC [ RunTime:0.004343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046126 LIMIT 2 [ RunTime:0.054328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046126 ORDER BY `minOrder` ASC [ RunTime:0.002929s ]
select * from pdf where partno='10981-20-1-2000-004-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.010802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-20-1-2000-004-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.024317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046199 LIMIT 5 [ RunTime:0.019023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046199 ORDER BY `minOrder` ASC [ RunTime:0.032415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046199 ORDER BY `unit` DESC [ RunTime:0.025023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046199 LIMIT 2 [ RunTime:0.045008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046199 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
select * from pdf where partno='10981-18-1-2000-001-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.027555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-18-1-2000-001-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.043131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046200 LIMIT 5 [ RunTime:0.063068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046200 ORDER BY `minOrder` ASC [ RunTime:0.071891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046200 ORDER BY `unit` DESC [ RunTime:0.027608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046200 LIMIT 2 [ RunTime:0.023628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046200 ORDER BY `minOrder` ASC [ RunTime:0.019875s ]
select * from pdf where partno='10981-18-1-2000-004-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.033691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-18-1-2000-004-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.067259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046031 LIMIT 5 [ RunTime:0.045603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046031 ORDER BY `minOrder` ASC [ RunTime:0.028428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046031 ORDER BY `unit` DESC [ RunTime:0.031187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046031 LIMIT 2 [ RunTime:0.023837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046031 ORDER BY `minOrder` ASC [ RunTime:0.012393s ]
select * from pdf where partno='10981-22-1-2000-002-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.000481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-22-1-2000-002-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.007923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63046033 LIMIT 5 [ RunTime:0.005825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046033 ORDER BY `minOrder` ASC [ RunTime:0.019439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63046033 ORDER BY `unit` DESC [ RunTime:0.020278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63046033 LIMIT 2 [ RunTime:0.028530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63046033 ORDER BY `minOrder` ASC [ RunTime:0.003597s ]
select * from pdf where partno='10981-22-1-2000-004-1-TD' and brandshort='CNC Tech' limit 1 [ RunTime:0.000584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981-22-1-2000-004-1-TD' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.006266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63002083 LIMIT 5 [ RunTime:0.012731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002083 ORDER BY `minOrder` ASC [ RunTime:0.033149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63002083 ORDER BY `unit` DESC [ RunTime:0.029364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63002083 LIMIT 2 [ RunTime:0.003484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002083 ORDER BY `minOrder` ASC [ RunTime:0.004515s ]
select * from pdf where partno='1098A 0102500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.011062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098A 0102500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.018336s ]
SELECT `id` FROM `stock` WHERE `id` <> 63002083 AND `partno` = '1098A 0102500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.049281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507577 [ RunTime:0.020319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563216 LIMIT 5 [ RunTime:0.019164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563216 ORDER BY `minOrder` ASC [ RunTime:0.100891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563216 ORDER BY `unit` DESC [ RunTime:0.050834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563216 LIMIT 2 [ RunTime:0.024332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563216 ORDER BY `minOrder` ASC [ RunTime:0.053880s ]
select * from pdf where partno='10988CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.039215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10988CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.045402s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563216 AND `partno` = '10988CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.043350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068505 [ RunTime:0.086066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56253455 LIMIT 5 [ RunTime:0.014743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253455 ORDER BY `minOrder` ASC [ RunTime:0.039398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56253455 ORDER BY `unit` DESC [ RunTime:0.021917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56253455 LIMIT 2 [ RunTime:0.017543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253455 ORDER BY `minOrder` ASC [ RunTime:0.020880s ]
select * from pdf where partno='109858-000' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.034635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109858-000' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.061038s ]
SELECT `id` FROM `stock` WHERE `id` <> 56253455 AND `partno` = '109858-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.018911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560264 LIMIT 5 [ RunTime:0.022117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560264 ORDER BY `minOrder` ASC [ RunTime:0.023820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560264 ORDER BY `unit` DESC [ RunTime:0.033888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560264 LIMIT 2 [ RunTime:0.037740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560264 ORDER BY `minOrder` ASC [ RunTime:0.007155s ]
select * from pdf where partno='1098178' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.032861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098178' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560238 LIMIT 5 [ RunTime:0.020055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560238 ORDER BY `minOrder` ASC [ RunTime:0.039150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560238 ORDER BY `unit` DESC [ RunTime:0.016866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560238 LIMIT 2 [ RunTime:0.026280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560238 ORDER BY `minOrder` ASC [ RunTime:0.012708s ]
select * from pdf where partno='1098169' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.020481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098169' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560137 LIMIT 5 [ RunTime:0.011062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560137 ORDER BY `minOrder` ASC [ RunTime:0.034902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560137 ORDER BY `unit` DESC [ RunTime:0.042821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560137 LIMIT 2 [ RunTime:0.011813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560137 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='1098167' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098167' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560762 LIMIT 5 [ RunTime:0.009322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560762 ORDER BY `minOrder` ASC [ RunTime:0.055699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560762 ORDER BY `unit` DESC [ RunTime:0.010376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560762 LIMIT 2 [ RunTime:0.027120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560762 ORDER BY `minOrder` ASC [ RunTime:0.027934s ]
select * from pdf where partno='10981CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.025245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10981CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.015875s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560762 AND `partno` = '10981CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.044220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347042 [ RunTime:0.018292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560239 LIMIT 5 [ RunTime:0.019238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560239 ORDER BY `minOrder` ASC [ RunTime:0.067224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560239 ORDER BY `unit` DESC [ RunTime:0.053505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560239 LIMIT 2 [ RunTime:0.028210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560239 ORDER BY `minOrder` ASC [ RunTime:0.021687s ]
select * from pdf where partno='1098177' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098177' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.038151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58297666 LIMIT 5 [ RunTime:0.013868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297666 ORDER BY `minOrder` ASC [ RunTime:0.009934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58297666 ORDER BY `unit` DESC [ RunTime:0.000923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58297666 LIMIT 2 [ RunTime:0.041583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297666 ORDER BY `minOrder` ASC [ RunTime:0.014752s ]
select * from pdf where partno='1098' and brandshort='Pololu' limit 1 [ RunTime:0.011944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.013754s ]
SELECT `id` FROM `stock` WHERE `id` <> 58297666 AND `partno` = '1098' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.018198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13466350 [ RunTime:0.016203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60561131 LIMIT 5 [ RunTime:0.047063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60561131 ORDER BY `minOrder` ASC [ RunTime:0.028881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60561131 ORDER BY `unit` DESC [ RunTime:0.012330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60561131 LIMIT 2 [ RunTime:0.037388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60561131 ORDER BY `minOrder` ASC [ RunTime:0.030686s ]
select * from pdf where partno='1098170' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.033125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1098170' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558364 LIMIT 5 [ RunTime:0.037210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558364 ORDER BY `minOrder` ASC [ RunTime:0.038988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558364 ORDER BY `unit` DESC [ RunTime:0.034247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558364 LIMIT 2 [ RunTime:0.021991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558364 ORDER BY `minOrder` ASC [ RunTime:0.012223s ]
select * from pdf where partno='10983CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10983CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001032s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558364 AND `partno` = '10983CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.028557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348377 [ RunTime:0.023719s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029884s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023322s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031216s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016295s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022331s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021832s ]
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 '1098%' OR `brand` LIKE '1098%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021421s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1098%' OR `brand` LIKE '1098%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.072871s ]