SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002608s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014015s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518077 LIMIT 5 [ RunTime:0.016746s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518077 ORDER BY `minOrder` ASC [ RunTime:0.010223s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518077 ORDER BY `unit` DESC [ RunTime:0.003428s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518077 LIMIT 2 [ RunTime:0.009361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518077 ORDER BY `minOrder` ASC [ RunTime:0.002839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516343 LIMIT 5 [ RunTime:0.001528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516343 ORDER BY `minOrder` ASC [ RunTime:0.007500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516343 ORDER BY `unit` DESC [ RunTime:0.003819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516343 LIMIT 2 [ RunTime:0.011744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516343 ORDER BY `minOrder` ASC [ RunTime:0.011447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588884 LIMIT 5 [ RunTime:0.011254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588884 ORDER BY `minOrder` ASC [ RunTime:0.013338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19588884 ORDER BY `unit` DESC [ RunTime:0.022566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19588884 LIMIT 2 [ RunTime:0.013988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588884 ORDER BY `minOrder` ASC [ RunTime:0.007925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11554 LIMIT 5 [ RunTime:0.009108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11554 ORDER BY `minOrder` ASC [ RunTime:0.013914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11554 ORDER BY `unit` DESC [ RunTime:0.004194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11554 LIMIT 2 [ RunTime:0.011984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11554 ORDER BY `minOrder` ASC [ RunTime:0.007627s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42100-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.020100s ]
SELECT `id` FROM `stock` WHERE `id` <> 11554 AND `partno` = '42100-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.010534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538088 LIMIT 5 [ RunTime:0.013451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538088 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538088 ORDER BY `unit` DESC [ RunTime:0.009420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538088 LIMIT 2 [ RunTime:0.027074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538088 ORDER BY `minOrder` ASC [ RunTime:0.002358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408413 LIMIT 5 [ RunTime:0.011975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408413 ORDER BY `minOrder` ASC [ RunTime:0.014250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408413 ORDER BY `unit` DESC [ RunTime:0.024211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408413 LIMIT 2 [ RunTime:0.035290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408413 ORDER BY `minOrder` ASC [ RunTime:0.005303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13268354 LIMIT 5 [ RunTime:0.026866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13268354 ORDER BY `minOrder` ASC [ RunTime:0.014407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13268354 ORDER BY `unit` DESC [ RunTime:0.008090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13268354 LIMIT 2 [ RunTime:0.008667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13268354 ORDER BY `minOrder` ASC [ RunTime:0.003083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509211 LIMIT 5 [ RunTime:0.036580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509211 ORDER BY `minOrder` ASC [ RunTime:0.011262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509211 ORDER BY `unit` DESC [ RunTime:0.010619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509211 LIMIT 2 [ RunTime:0.035824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509211 ORDER BY `minOrder` ASC [ RunTime:0.015358s ]
select * from pdf where partno='4210-A1' and brandshort='Conductive Containers, Inc.' limit 1 [ RunTime:0.014013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687454 LIMIT 5 [ RunTime:0.013374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687454 ORDER BY `minOrder` ASC [ RunTime:0.012211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687454 ORDER BY `unit` DESC [ RunTime:0.028913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687454 LIMIT 2 [ RunTime:0.040257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687454 ORDER BY `minOrder` ASC [ RunTime:0.042324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687420 LIMIT 5 [ RunTime:0.044534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687420 ORDER BY `minOrder` ASC [ RunTime:0.033028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687420 ORDER BY `unit` DESC [ RunTime:0.048363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687420 LIMIT 2 [ RunTime:0.010970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687420 ORDER BY `minOrder` ASC [ RunTime:0.004854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423228 LIMIT 5 [ RunTime:0.008751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423228 ORDER BY `minOrder` ASC [ RunTime:0.045064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16423228 ORDER BY `unit` DESC [ RunTime:0.041387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16423228 LIMIT 2 [ RunTime:0.008975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423228 ORDER BY `minOrder` ASC [ RunTime:0.024682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423150 LIMIT 5 [ RunTime:0.033710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423150 ORDER BY `minOrder` ASC [ RunTime:0.064947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16423150 ORDER BY `unit` DESC [ RunTime:0.012842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16423150 LIMIT 2 [ RunTime:0.060991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423150 ORDER BY `minOrder` ASC [ RunTime:0.029222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14473393 LIMIT 5 [ RunTime:0.079719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14473393 ORDER BY `minOrder` ASC [ RunTime:0.028721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14473393 ORDER BY `unit` DESC [ RunTime:0.015559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14473393 LIMIT 2 [ RunTime:0.021067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14473393 ORDER BY `minOrder` ASC [ RunTime:0.034740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14304395 LIMIT 5 [ RunTime:0.033965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14304395 ORDER BY `minOrder` ASC [ RunTime:0.030608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14304395 ORDER BY `unit` DESC [ RunTime:0.022519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14304395 LIMIT 2 [ RunTime:0.017419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14304395 ORDER BY `minOrder` ASC [ RunTime:0.010074s ]
select * from pdf where partno='42103C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.002194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13391491 LIMIT 5 [ RunTime:0.052589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391491 ORDER BY `minOrder` ASC [ RunTime:0.028985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13391491 ORDER BY `unit` DESC [ RunTime:0.019638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13391491 LIMIT 2 [ RunTime:0.004537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391491 ORDER BY `minOrder` ASC [ RunTime:0.024200s ]
select * from pdf where partno='42103C-R' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.007878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251207 LIMIT 5 [ RunTime:0.027489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251207 ORDER BY `minOrder` ASC [ RunTime:0.025231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13251207 ORDER BY `unit` DESC [ RunTime:0.004826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13251207 LIMIT 2 [ RunTime:0.005071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251207 ORDER BY `minOrder` ASC [ RunTime:0.020555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13233676 LIMIT 5 [ RunTime:0.007582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13233676 ORDER BY `minOrder` ASC [ RunTime:0.005574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13233676 ORDER BY `unit` DESC [ RunTime:0.005731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13233676 LIMIT 2 [ RunTime:0.016827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13233676 ORDER BY `minOrder` ASC [ RunTime:0.005993s ]
select * from pdf where partno='4210-52' and brandshort='pSemi' limit 1 [ RunTime:0.003381s ]
select foldpath,foldpath2,filename from pdf_file where id=928654 limit 1 [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612164 LIMIT 5 [ RunTime:0.014936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612164 ORDER BY `minOrder` ASC [ RunTime:0.013601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612164 ORDER BY `unit` DESC [ RunTime:0.018701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612164 LIMIT 2 [ RunTime:0.011586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612164 ORDER BY `minOrder` ASC [ RunTime:0.007809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518624 LIMIT 5 [ RunTime:0.007038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518624 ORDER BY `minOrder` ASC [ RunTime:0.037120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518624 ORDER BY `unit` DESC [ RunTime:0.008246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518624 LIMIT 2 [ RunTime:0.016023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518624 ORDER BY `minOrder` ASC [ RunTime:0.010509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517706 LIMIT 5 [ RunTime:0.041269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517706 ORDER BY `minOrder` ASC [ RunTime:0.028321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517706 ORDER BY `unit` DESC [ RunTime:0.030374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517706 LIMIT 2 [ RunTime:0.052538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517706 ORDER BY `minOrder` ASC [ RunTime:0.003998s ]
select * from pdf where partno='42100-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.043898s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133739 LIMIT 5 [ RunTime:0.021033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133739 ORDER BY `minOrder` ASC [ RunTime:0.006801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133739 ORDER BY `unit` DESC [ RunTime:0.008269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133739 LIMIT 2 [ RunTime:0.001520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133739 ORDER BY `minOrder` ASC [ RunTime:0.003307s ]
select * from pdf where partno='4210-p' and brandshort='heyco' limit 1 [ RunTime:0.008795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210-p' OR `brand` LIKE 'heyco%' ) ) LIMIT 1 [ RunTime:0.009298s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133739 AND `partno` = '4210-p' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco%' ) [ RunTime:0.011488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423228 [ RunTime:0.003201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096367 LIMIT 5 [ RunTime:0.013486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096367 ORDER BY `minOrder` ASC [ RunTime:0.035215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096367 ORDER BY `unit` DESC [ RunTime:0.030842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096367 LIMIT 2 [ RunTime:0.027376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096367 ORDER BY `minOrder` ASC [ RunTime:0.004523s ]
select * from pdf where partno='4210' and brandshort='adafruit' limit 1 [ RunTime:0.012679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.014310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254352 LIMIT 5 [ RunTime:0.009310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254352 ORDER BY `minOrder` ASC [ RunTime:0.015756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254352 ORDER BY `unit` DESC [ RunTime:0.006890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254352 LIMIT 2 [ RunTime:0.014443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254352 ORDER BY `minOrder` ASC [ RunTime:0.007576s ]
select * from pdf where partno='42103' and brandshort='auvidea' limit 1 [ RunTime:0.019515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42103' OR `brand` LIKE 'auvidea%' ) ) LIMIT 1 [ RunTime:0.008971s ]
SELECT `id` FROM `stock` WHERE `id` <> 32254352 AND `partno` = '42103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%auvidea%' ) [ RunTime:0.005491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131882 [ RunTime:0.000755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131882 LIMIT 5 [ RunTime:0.020378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131882 ORDER BY `minOrder` ASC [ RunTime:0.018834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131882 ORDER BY `unit` DESC [ RunTime:0.009035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131882 LIMIT 2 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131882 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='42103' and brandshort='auvidea' limit 1 [ RunTime:0.002430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42103' OR `brand` LIKE 'auvidea%' ) ) LIMIT 1 [ RunTime:0.000378s ]
SELECT `id` FROM `stock` WHERE `id` <> 51131882 AND `partno` = '42103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%auvidea%' ) [ RunTime:0.003276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254352 [ RunTime:0.010743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132022 LIMIT 5 [ RunTime:0.018305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132022 ORDER BY `minOrder` ASC [ RunTime:0.047794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132022 ORDER BY `unit` DESC [ RunTime:0.012992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132022 LIMIT 2 [ RunTime:0.035909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132022 ORDER BY `minOrder` ASC [ RunTime:0.007369s ]
select * from pdf where partno='42101' and brandshort='auvidea' limit 1 [ RunTime:0.024053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42101' OR `brand` LIKE 'auvidea%' ) ) LIMIT 1 [ RunTime:0.013364s ]
SELECT `id` FROM `stock` WHERE `id` <> 51132022 AND `partno` = '42101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%auvidea%' ) [ RunTime:0.000886s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60638823 LIMIT 5 [ RunTime:0.006178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60638823 ORDER BY `minOrder` ASC [ RunTime:0.017098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60638823 ORDER BY `unit` DESC [ RunTime:0.011998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60638823 LIMIT 2 [ RunTime:0.034896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60638823 ORDER BY `minOrder` ASC [ RunTime:0.017356s ]
select * from pdf where partno='42100-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42100-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013508s ]
SELECT `id` FROM `stock` WHERE `id` <> 60638823 AND `partno` = '42100-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516343 [ RunTime:0.030100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60643685 LIMIT 5 [ RunTime:0.035552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643685 ORDER BY `minOrder` ASC [ RunTime:0.044841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60643685 ORDER BY `unit` DESC [ RunTime:0.046717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60643685 LIMIT 2 [ RunTime:0.027297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643685 ORDER BY `minOrder` ASC [ RunTime:0.002975s ]
select * from pdf where partno='42101-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42101-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.059677s ]
SELECT `id` FROM `stock` WHERE `id` <> 60643685 AND `partno` = '42101-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.027083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588884 [ RunTime:0.024647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639174 LIMIT 5 [ RunTime:0.020793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639174 ORDER BY `minOrder` ASC [ RunTime:0.030133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639174 ORDER BY `unit` DESC [ RunTime:0.019049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639174 LIMIT 2 [ RunTime:0.002957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639174 ORDER BY `minOrder` ASC [ RunTime:0.002797s ]
select * from pdf where partno='42100-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42100-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015601s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639174 AND `partno` = '42100-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.025461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518077 [ RunTime:0.009323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59947681 LIMIT 5 [ RunTime:0.026128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947681 ORDER BY `minOrder` ASC [ RunTime:0.015927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59947681 ORDER BY `unit` DESC [ RunTime:0.016472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59947681 LIMIT 2 [ RunTime:0.031407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947681 ORDER BY `minOrder` ASC [ RunTime:0.017832s ]
select * from pdf where partno='42107-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.021905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42107-2' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.034199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60641142 LIMIT 5 [ RunTime:0.013483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641142 ORDER BY `minOrder` ASC [ RunTime:0.020916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60641142 ORDER BY `unit` DESC [ RunTime:0.038096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60641142 LIMIT 2 [ RunTime:0.042698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641142 ORDER BY `minOrder` ASC [ RunTime:0.008380s ]
select * from pdf where partno='42100-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.018401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42100-2' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.052288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60641140 LIMIT 5 [ RunTime:0.018985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641140 ORDER BY `minOrder` ASC [ RunTime:0.041145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60641140 ORDER BY `unit` DESC [ RunTime:0.034671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60641140 LIMIT 2 [ RunTime:0.001319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641140 ORDER BY `minOrder` ASC [ RunTime:0.002833s ]
select * from pdf where partno='42100-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.006739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42100-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.030100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62248229 LIMIT 5 [ RunTime:0.018434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62248229 ORDER BY `minOrder` ASC [ RunTime:0.007993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62248229 ORDER BY `unit` DESC [ RunTime:0.009010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62248229 LIMIT 2 [ RunTime:0.014092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62248229 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='4210' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.003932s ]
SELECT `id` FROM `stock` WHERE `id` <> 62248229 AND `partno` = '4210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.016065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14473393 [ RunTime:0.004318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126922 LIMIT 5 [ RunTime:0.004132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126922 ORDER BY `minOrder` ASC [ RunTime:0.009341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126922 ORDER BY `unit` DESC [ RunTime:0.006851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126922 LIMIT 2 [ RunTime:0.004549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126922 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='4210F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.012706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002815s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126922 AND `partno` = '4210F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.004364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538088 [ RunTime:0.003741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126485 LIMIT 5 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126485 ORDER BY `minOrder` ASC [ RunTime:0.006766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126485 ORDER BY `unit` DESC [ RunTime:0.010262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126485 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126485 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='4210B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.011611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002933s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126485 AND `partno` = '4210B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.007754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408413 [ RunTime:0.001868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127108 LIMIT 5 [ RunTime:0.002738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127108 ORDER BY `minOrder` ASC [ RunTime:0.021372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127108 ORDER BY `unit` DESC [ RunTime:0.007672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127108 LIMIT 2 [ RunTime:0.008262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127108 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='4210' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.005794s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127108 AND `partno` = '4210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.003412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423150 [ RunTime:0.004599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64178131 LIMIT 5 [ RunTime:0.002341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178131 ORDER BY `minOrder` ASC [ RunTime:0.007543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64178131 ORDER BY `unit` DESC [ RunTime:0.010866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64178131 LIMIT 2 [ RunTime:0.018896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178131 ORDER BY `minOrder` ASC [ RunTime:0.003789s ]
select * from pdf where partno='421041101-0607501' and brandshort='SAG' limit 1 [ RunTime:0.011683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '421041101-0607501' OR `brand` LIKE 'SAG%' ) ) LIMIT 1 [ RunTime:0.031359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64723043 LIMIT 5 [ RunTime:0.043363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64723043 ORDER BY `minOrder` ASC [ RunTime:0.003990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64723043 ORDER BY `unit` DESC [ RunTime:0.006342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64723043 LIMIT 2 [ RunTime:0.016274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64723043 ORDER BY `minOrder` ASC [ RunTime:0.004528s ]
select * from pdf where partno='4210B' and brandshort='Dwyer' limit 1 [ RunTime:0.009208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210B' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.003513s ]
SELECT `id` FROM `stock` WHERE `id` <> 64723043 AND `partno` = '4210B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.010148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56711511 [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64717919 LIMIT 5 [ RunTime:0.005948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64717919 ORDER BY `minOrder` ASC [ RunTime:0.001513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64717919 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64717919 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64717919 ORDER BY `minOrder` ASC [ RunTime:0.000938s ]
select * from pdf where partno='4210' and brandshort='Dwyer' limit 1 [ RunTime:0.003690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.000673s ]
SELECT `id` FROM `stock` WHERE `id` <> 64717919 AND `partno` = '4210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.001765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32713255 [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63493315 LIMIT 5 [ RunTime:0.000884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63493315 ORDER BY `minOrder` ASC [ RunTime:0.003365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63493315 ORDER BY `unit` DESC [ RunTime:0.000727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63493315 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63493315 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='4210-A1' and brandshort='Conductive Containers, Inc.' limit 1 [ RunTime:0.000430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210-A1' OR `brand` LIKE 'Conductive Containers, Inc.%' ) ) LIMIT 1 [ RunTime:0.000319s ]
SELECT `id` FROM `stock` WHERE `id` <> 63493315 AND `partno` = '4210-A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conductive containers, inc.%' ) [ RunTime:0.000395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509211 [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63129763 LIMIT 5 [ RunTime:0.011782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63129763 ORDER BY `minOrder` ASC [ RunTime:0.002398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63129763 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63129763 LIMIT 2 [ RunTime:0.001205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63129763 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
select * from pdf where partno='4210-P' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.003680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210-P' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000981s ]
SELECT `id` FROM `stock` WHERE `id` <> 63129763 AND `partno` = '4210-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423228 [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60642559 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60642559 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60642559 ORDER BY `unit` DESC [ RunTime:0.000538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60642559 LIMIT 2 [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60642559 ORDER BY `minOrder` ASC [ RunTime:0.001209s ]
select * from pdf where partno='42100-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42100-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003814s ]
SELECT `id` FROM `stock` WHERE `id` <> 60642559 AND `partno` = '42100-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517706 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60346919 LIMIT 5 [ RunTime:0.003688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60346919 ORDER BY `minOrder` ASC [ RunTime:0.001208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60346919 ORDER BY `unit` DESC [ RunTime:0.001477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60346919 LIMIT 2 [ RunTime:0.001152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60346919 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='42107-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42107-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002664s ]
SELECT `id` FROM `stock` WHERE `id` <> 60346919 AND `partno` = '42107-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.003317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612164 [ RunTime:0.000614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59711521 LIMIT 5 [ RunTime:0.003557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711521 ORDER BY `minOrder` ASC [ RunTime:0.001664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59711521 ORDER BY `unit` DESC [ RunTime:0.000334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59711521 LIMIT 2 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711521 ORDER BY `minOrder` ASC [ RunTime:0.000866s ]
select * from pdf where partno='4210-0200MD' and brandshort='3M' limit 1 [ RunTime:0.000478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4210-0200MD' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.000338s ]
SELECT `id` FROM `stock` WHERE `id` <> 59711521 AND `partno` = '4210-0200MD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579862 [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568846 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568846 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568846 ORDER BY `unit` DESC [ RunTime:0.007833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568846 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568846 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='421027' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '421027' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001699s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568846 AND `partno` = '421027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.002446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568838 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568838 ORDER BY `minOrder` ASC [ RunTime:0.009026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568838 ORDER BY `unit` DESC [ RunTime:0.014040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568838 LIMIT 2 [ RunTime:0.001855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568838 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='421025' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '421025' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000804s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568838 AND `partno` = '421025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159106 [ RunTime:0.015861s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024535s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027069s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018432s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013466s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012358s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016749s ]
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 '4210%' OR `brand` LIKE '4210%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033569s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4210%' OR `brand` LIKE '4210%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030444s ]