SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002166s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015412s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17111107 LIMIT 5 [ RunTime:0.035747s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17111107 ORDER BY `minOrder` ASC [ RunTime:0.002226s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17111107 ORDER BY `unit` DESC [ RunTime:0.014804s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17111107 LIMIT 2 [ RunTime:0.027024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17111107 ORDER BY `minOrder` ASC [ RunTime:0.018056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16102260 LIMIT 5 [ RunTime:0.024352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16102260 ORDER BY `minOrder` ASC [ RunTime:0.017670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16102260 ORDER BY `unit` DESC [ RunTime:0.067492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16102260 LIMIT 2 [ RunTime:0.024017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16102260 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513134 LIMIT 5 [ RunTime:0.015971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513134 ORDER BY `minOrder` ASC [ RunTime:0.003689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513134 ORDER BY `unit` DESC [ RunTime:0.011979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513134 LIMIT 2 [ RunTime:0.006958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513134 ORDER BY `minOrder` ASC [ RunTime:0.024605s ]
select * from pdf where partno='5482C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17045556 LIMIT 5 [ RunTime:0.035649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17045556 ORDER BY `minOrder` ASC [ RunTime:0.068493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17045556 ORDER BY `unit` DESC [ RunTime:0.016088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17045556 LIMIT 2 [ RunTime:0.017823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17045556 ORDER BY `minOrder` ASC [ RunTime:0.008783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170576 LIMIT 5 [ RunTime:0.027669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170576 ORDER BY `minOrder` ASC [ RunTime:0.006550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12170576 ORDER BY `unit` DESC [ RunTime:0.031689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12170576 LIMIT 2 [ RunTime:0.020148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170576 ORDER BY `minOrder` ASC [ RunTime:0.038268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517349 LIMIT 5 [ RunTime:0.035795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517349 ORDER BY `minOrder` ASC [ RunTime:0.011804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13517349 ORDER BY `unit` DESC [ RunTime:0.014418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13517349 LIMIT 2 [ RunTime:0.019293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517349 ORDER BY `minOrder` ASC [ RunTime:0.015425s ]
select * from pdf where partno='5482C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517033 LIMIT 5 [ RunTime:0.016903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517033 ORDER BY `minOrder` ASC [ RunTime:0.021741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13517033 ORDER BY `unit` DESC [ RunTime:0.022057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13517033 LIMIT 2 [ RunTime:0.028882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517033 ORDER BY `minOrder` ASC [ RunTime:0.012872s ]
select * from pdf where partno='5482C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.009762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378263 LIMIT 5 [ RunTime:0.029936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378263 ORDER BY `minOrder` ASC [ RunTime:0.018115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14378263 ORDER BY `unit` DESC [ RunTime:0.033385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14378263 LIMIT 2 [ RunTime:0.019171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378263 ORDER BY `minOrder` ASC [ RunTime:0.027710s ]
select * from pdf where partno='5482C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503763 LIMIT 5 [ RunTime:0.025013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503763 ORDER BY `minOrder` ASC [ RunTime:0.008105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503763 ORDER BY `unit` DESC [ RunTime:0.006648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503763 LIMIT 2 [ RunTime:0.018877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503763 ORDER BY `minOrder` ASC [ RunTime:0.001468s ]
select * from pdf where partno='5482C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.013558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291570 LIMIT 5 [ RunTime:0.006349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291570 ORDER BY `minOrder` ASC [ RunTime:0.026874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13291570 ORDER BY `unit` DESC [ RunTime:0.017694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13291570 LIMIT 2 [ RunTime:0.011950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291570 ORDER BY `minOrder` ASC [ RunTime:0.003044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289854 LIMIT 5 [ RunTime:0.010354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289854 ORDER BY `minOrder` ASC [ RunTime:0.011856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289854 ORDER BY `unit` DESC [ RunTime:0.001430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289854 LIMIT 2 [ RunTime:0.005896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289854 ORDER BY `minOrder` ASC [ RunTime:0.008635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288229 LIMIT 5 [ RunTime:0.004491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288229 ORDER BY `minOrder` ASC [ RunTime:0.004860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288229 ORDER BY `unit` DESC [ RunTime:0.030846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288229 LIMIT 2 [ RunTime:0.005114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288229 ORDER BY `minOrder` ASC [ RunTime:0.003689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285958 LIMIT 5 [ RunTime:0.019924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285958 ORDER BY `minOrder` ASC [ RunTime:0.018729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13285958 ORDER BY `unit` DESC [ RunTime:0.010776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13285958 LIMIT 2 [ RunTime:0.011722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285958 ORDER BY `minOrder` ASC [ RunTime:0.027165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12023476 LIMIT 5 [ RunTime:0.012964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12023476 ORDER BY `minOrder` ASC [ RunTime:0.024153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12023476 ORDER BY `unit` DESC [ RunTime:0.012442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12023476 LIMIT 2 [ RunTime:0.038189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12023476 ORDER BY `minOrder` ASC [ RunTime:0.016040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016813 LIMIT 5 [ RunTime:0.029929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016813 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12016813 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12016813 LIMIT 2 [ RunTime:0.001514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016813 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12015525 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12015525 ORDER BY `minOrder` ASC [ RunTime:0.005194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12015525 ORDER BY `unit` DESC [ RunTime:0.014290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12015525 LIMIT 2 [ RunTime:0.021490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12015525 ORDER BY `minOrder` ASC [ RunTime:0.017604s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137923 LIMIT 5 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137923 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137923 ORDER BY `unit` DESC [ RunTime:0.000736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137923 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137923 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='5482c sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.002262s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482c sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.002406s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137923 AND `partno` = '5482c sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513134 [ RunTime:0.006777s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63775497 LIMIT 5 [ RunTime:0.030853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63775497 ORDER BY `minOrder` ASC [ RunTime:0.052033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63775497 ORDER BY `unit` DESC [ RunTime:0.026862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63775497 LIMIT 2 [ RunTime:0.072357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63775497 ORDER BY `minOrder` ASC [ RunTime:0.019318s ]
select * from pdf where partno='5482J/B' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.026143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482J/B' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.018509s ]
SELECT `id` FROM `stock` WHERE `id` <> 63775497 AND `partno` = '5482J/B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.013910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17111107 [ RunTime:0.035983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63775488 LIMIT 5 [ RunTime:0.094169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63775488 ORDER BY `minOrder` ASC [ RunTime:0.048704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63775488 ORDER BY `unit` DESC [ RunTime:0.029185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63775488 LIMIT 2 [ RunTime:0.030424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63775488 ORDER BY `minOrder` ASC [ RunTime:0.007595s ]
select * from pdf where partno='5482W/R LF' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.065825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482W/R LF' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.089822s ]
SELECT `id` FROM `stock` WHERE `id` <> 63775488 AND `partno` = '5482W/R LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.100251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16102260 [ RunTime:0.049034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62999728 LIMIT 5 [ RunTime:0.026904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999728 ORDER BY `minOrder` ASC [ RunTime:0.029786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62999728 ORDER BY `unit` DESC [ RunTime:0.023649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62999728 LIMIT 2 [ RunTime:0.021694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999728 ORDER BY `minOrder` ASC [ RunTime:0.017960s ]
select * from pdf where partno='5482C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005899s ]
SELECT `id` FROM `stock` WHERE `id` <> 62999728 AND `partno` = '5482C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.029844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513134 [ RunTime:0.012767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64810521 LIMIT 5 [ RunTime:0.034106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810521 ORDER BY `minOrder` ASC [ RunTime:0.047177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64810521 ORDER BY `unit` DESC [ RunTime:0.074012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64810521 LIMIT 2 [ RunTime:0.035326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810521 ORDER BY `minOrder` ASC [ RunTime:0.003078s ]
select * from pdf where partno='54826MB' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.024895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54826MB' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.019005s ]
SELECT `id` FROM `stock` WHERE `id` <> 64810521 AND `partno` = '54826MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.026636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58513422 LIMIT 5 [ RunTime:0.034895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513422 ORDER BY `minOrder` ASC [ RunTime:0.035062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58513422 ORDER BY `unit` DESC [ RunTime:0.009121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58513422 LIMIT 2 [ RunTime:0.035140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513422 ORDER BY `minOrder` ASC [ RunTime:0.004847s ]
select * from pdf where partno='54825MB' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.042518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54825MB' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.045000s ]
SELECT `id` FROM `stock` WHERE `id` <> 58513422 AND `partno` = '54825MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.032415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58513867 LIMIT 5 [ RunTime:0.024893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513867 ORDER BY `minOrder` ASC [ RunTime:0.014120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58513867 ORDER BY `unit` DESC [ RunTime:0.013633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58513867 LIMIT 2 [ RunTime:0.008768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513867 ORDER BY `minOrder` ASC [ RunTime:0.010889s ]
select * from pdf where partno='5482' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.032626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.038792s ]
SELECT `id` FROM `stock` WHERE `id` <> 58513867 AND `partno` = '5482' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.036751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170576 [ RunTime:0.019049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021602 LIMIT 5 [ RunTime:0.028150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021602 ORDER BY `minOrder` ASC [ RunTime:0.011544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021602 ORDER BY `unit` DESC [ RunTime:0.044363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021602 LIMIT 2 [ RunTime:0.055348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021602 ORDER BY `minOrder` ASC [ RunTime:0.012839s ]
select * from pdf where partno='5482C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.009364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482C SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.028433s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021602 AND `partno` = '5482C SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.034144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378263 [ RunTime:0.031314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021483 LIMIT 5 [ RunTime:0.058674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021483 ORDER BY `minOrder` ASC [ RunTime:0.043083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021483 ORDER BY `unit` DESC [ RunTime:0.055005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021483 LIMIT 2 [ RunTime:0.086946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021483 ORDER BY `minOrder` ASC [ RunTime:0.017264s ]
select * from pdf where partno='5482C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.021108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482C BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.021457s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021483 AND `partno` = '5482C BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.055804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503763 [ RunTime:0.094385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000269 LIMIT 5 [ RunTime:0.022039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000269 ORDER BY `minOrder` ASC [ RunTime:0.053841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000269 ORDER BY `unit` DESC [ RunTime:0.067886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000269 LIMIT 2 [ RunTime:0.038868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000269 ORDER BY `minOrder` ASC [ RunTime:0.029444s ]
select * from pdf where partno='5482C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.054186s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000269 AND `partno` = '5482C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.060486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517033 [ RunTime:0.031903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000119 LIMIT 5 [ RunTime:0.029306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000119 ORDER BY `minOrder` ASC [ RunTime:0.086150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000119 ORDER BY `unit` DESC [ RunTime:0.058170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000119 LIMIT 2 [ RunTime:0.025454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000119 ORDER BY `minOrder` ASC [ RunTime:0.004306s ]
select * from pdf where partno='5482C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5482C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.029750s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000119 AND `partno` = '5482C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.041530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517349 [ RunTime:0.043349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32730203 LIMIT 5 [ RunTime:0.025055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32730203 ORDER BY `minOrder` ASC [ RunTime:0.038817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32730203 ORDER BY `unit` DESC [ RunTime:0.038280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32730203 LIMIT 2 [ RunTime:0.022482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32730203 ORDER BY `minOrder` ASC [ RunTime:0.023882s ]
select * from pdf where partno='548251-000' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '548251-000' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033356s ]
SELECT `id` FROM `stock` WHERE `id` <> 32730203 AND `partno` = '548251-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.045394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32615296 LIMIT 5 [ RunTime:0.044708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32615296 ORDER BY `minOrder` ASC [ RunTime:0.016460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32615296 ORDER BY `unit` DESC [ RunTime:0.019458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32615296 LIMIT 2 [ RunTime:0.010862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32615296 ORDER BY `minOrder` ASC [ RunTime:0.002907s ]
select * from pdf where partno='54827' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.035033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54827' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.005787s ]
SELECT `id` FROM `stock` WHERE `id` <> 32615296 AND `partno` = '54827' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.005015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291570 [ RunTime:0.013232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32600286 LIMIT 5 [ RunTime:0.003439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32600286 ORDER BY `minOrder` ASC [ RunTime:0.024026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32600286 ORDER BY `unit` DESC [ RunTime:0.011876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32600286 LIMIT 2 [ RunTime:0.001223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32600286 ORDER BY `minOrder` ASC [ RunTime:0.009799s ]
select * from pdf where partno='54828' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.025802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54828' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.003452s ]
SELECT `id` FROM `stock` WHERE `id` <> 32600286 AND `partno` = '54828' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.018033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12023476 [ RunTime:0.013543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32576214 LIMIT 5 [ RunTime:0.015101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32576214 ORDER BY `minOrder` ASC [ RunTime:0.003155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32576214 ORDER BY `unit` DESC [ RunTime:0.002816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32576214 LIMIT 2 [ RunTime:0.010634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32576214 ORDER BY `minOrder` ASC [ RunTime:0.005508s ]
select * from pdf where partno='54829' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.009005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54829' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.016630s ]
SELECT `id` FROM `stock` WHERE `id` <> 32576214 AND `partno` = '54829' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.036461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289854 [ RunTime:0.002825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32507441 LIMIT 5 [ RunTime:0.011571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32507441 ORDER BY `minOrder` ASC [ RunTime:0.022168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32507441 ORDER BY `unit` DESC [ RunTime:0.005280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32507441 LIMIT 2 [ RunTime:0.008044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32507441 ORDER BY `minOrder` ASC [ RunTime:0.006731s ]
select * from pdf where partno='54823' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.014795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54823' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.029486s ]
SELECT `id` FROM `stock` WHERE `id` <> 32507441 AND `partno` = '54823' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.028597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288229 [ RunTime:0.022280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32386568 LIMIT 5 [ RunTime:0.024734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32386568 ORDER BY `minOrder` ASC [ RunTime:0.031827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32386568 ORDER BY `unit` DESC [ RunTime:0.006155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32386568 LIMIT 2 [ RunTime:0.026505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32386568 ORDER BY `minOrder` ASC [ RunTime:0.009315s ]
select * from pdf where partno='54824' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.034925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54824' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.016246s ]
SELECT `id` FROM `stock` WHERE `id` <> 32386568 AND `partno` = '54824' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.010608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016813 [ RunTime:0.028091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32384384 LIMIT 5 [ RunTime:0.047569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32384384 ORDER BY `minOrder` ASC [ RunTime:0.018100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32384384 ORDER BY `unit` DESC [ RunTime:0.020591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32384384 LIMIT 2 [ RunTime:0.023095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32384384 ORDER BY `minOrder` ASC [ RunTime:0.019289s ]
select * from pdf where partno='54825' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.025010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54825' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.085274s ]
SELECT `id` FROM `stock` WHERE `id` <> 32384384 AND `partno` = '54825' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.056742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285958 [ RunTime:0.037073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32362041 LIMIT 5 [ RunTime:0.012143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32362041 ORDER BY `minOrder` ASC [ RunTime:0.030108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32362041 ORDER BY `unit` DESC [ RunTime:0.034370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32362041 LIMIT 2 [ RunTime:0.048152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32362041 ORDER BY `minOrder` ASC [ RunTime:0.048212s ]
select * from pdf where partno='54826' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.021780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54826' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.019838s ]
SELECT `id` FROM `stock` WHERE `id` <> 32362041 AND `partno` = '54826' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.015523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12015525 [ RunTime:0.063591s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080884s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075501s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082248s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037173s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018846s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035927s ]
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 '5482%' OR `brand` LIKE '5482%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085263s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5482%' OR `brand` LIKE '5482%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016915s ]