SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002962s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=7093&search=1' [ RunTime:0.020263s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001331s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.033068s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001339s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.008663s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002974s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017436s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001145s ]
SELECT * FROM `stock_search` WHERE `partno` = '7093' LIMIT 1 [ RunTime:0.032252s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-29 06:31:04' WHERE `partno` = '7093' [ RunTime:0.028691s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002801s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070509s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067264 LIMIT 5 [ RunTime:0.064338s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067264 ORDER BY `minOrder` ASC [ RunTime:0.050594s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.044485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067264 ORDER BY `unit` DESC [ RunTime:0.034972s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067264 LIMIT 2 [ RunTime:0.062315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067264 ORDER BY `minOrder` ASC [ RunTime:0.022124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067267 LIMIT 5 [ RunTime:0.062710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067267 ORDER BY `minOrder` ASC [ RunTime:0.059826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067267 ORDER BY `unit` DESC [ RunTime:0.162985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067267 LIMIT 2 [ RunTime:0.063835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067267 ORDER BY `minOrder` ASC [ RunTime:0.015438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12169948 LIMIT 5 [ RunTime:0.086961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12169948 ORDER BY `minOrder` ASC [ RunTime:0.033850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12169948 ORDER BY `unit` DESC [ RunTime:0.061712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12169948 LIMIT 2 [ RunTime:0.054807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12169948 ORDER BY `minOrder` ASC [ RunTime:0.014685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349906 LIMIT 5 [ RunTime:0.041622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349906 ORDER BY `minOrder` ASC [ RunTime:0.040786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349906 ORDER BY `unit` DESC [ RunTime:0.072885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349906 LIMIT 2 [ RunTime:0.040867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349906 ORDER BY `minOrder` ASC [ RunTime:0.020146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12169951 LIMIT 5 [ RunTime:0.027229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12169951 ORDER BY `minOrder` ASC [ RunTime:0.089807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12169951 ORDER BY `unit` DESC [ RunTime:0.089327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12169951 LIMIT 2 [ RunTime:0.071431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12169951 ORDER BY `minOrder` ASC [ RunTime:0.062072s ]
select * from pdf where partno='7093C' and brandshort='3M' limit 1 [ RunTime:0.055638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067826 LIMIT 5 [ RunTime:0.051765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067826 ORDER BY `minOrder` ASC [ RunTime:0.028299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067826 ORDER BY `unit` DESC [ RunTime:0.059753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067826 LIMIT 2 [ RunTime:0.030824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067826 ORDER BY `minOrder` ASC [ RunTime:0.052559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067644 LIMIT 5 [ RunTime:0.021422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067644 ORDER BY `minOrder` ASC [ RunTime:0.023680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067644 ORDER BY `unit` DESC [ RunTime:0.080744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067644 LIMIT 2 [ RunTime:0.065191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067644 ORDER BY `minOrder` ASC [ RunTime:0.006879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067647 LIMIT 5 [ RunTime:0.057416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067647 ORDER BY `minOrder` ASC [ RunTime:0.019951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067647 ORDER BY `unit` DESC [ RunTime:0.044151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067647 LIMIT 2 [ RunTime:0.105868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067647 ORDER BY `minOrder` ASC [ RunTime:0.044192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349728 LIMIT 5 [ RunTime:0.037281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349728 ORDER BY `minOrder` ASC [ RunTime:0.027739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349728 ORDER BY `unit` DESC [ RunTime:0.090609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349728 LIMIT 2 [ RunTime:0.096489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349728 ORDER BY `minOrder` ASC [ RunTime:0.035025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349729 LIMIT 5 [ RunTime:0.062458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349729 ORDER BY `minOrder` ASC [ RunTime:0.036662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349729 ORDER BY `unit` DESC [ RunTime:0.065302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349729 LIMIT 2 [ RunTime:0.023565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349729 ORDER BY `minOrder` ASC [ RunTime:0.016441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349730 LIMIT 5 [ RunTime:0.026706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349730 ORDER BY `minOrder` ASC [ RunTime:0.067150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349730 ORDER BY `unit` DESC [ RunTime:0.049007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349730 LIMIT 2 [ RunTime:0.126039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349730 ORDER BY `minOrder` ASC [ RunTime:0.025243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067368 LIMIT 5 [ RunTime:0.037146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067368 ORDER BY `minOrder` ASC [ RunTime:0.062712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067368 ORDER BY `unit` DESC [ RunTime:0.080249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067368 LIMIT 2 [ RunTime:0.030467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067368 ORDER BY `minOrder` ASC [ RunTime:0.011788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350639 LIMIT 5 [ RunTime:0.084705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350639 ORDER BY `minOrder` ASC [ RunTime:0.050031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350639 ORDER BY `unit` DESC [ RunTime:0.015498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350639 LIMIT 2 [ RunTime:0.007091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350639 ORDER BY `minOrder` ASC [ RunTime:0.009146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067832 LIMIT 5 [ RunTime:0.055140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067832 ORDER BY `minOrder` ASC [ RunTime:0.024099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067832 ORDER BY `unit` DESC [ RunTime:0.038675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067832 LIMIT 2 [ RunTime:0.029560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067832 ORDER BY `minOrder` ASC [ RunTime:0.006243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350395 LIMIT 5 [ RunTime:0.029585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350395 ORDER BY `minOrder` ASC [ RunTime:0.023109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350395 ORDER BY `unit` DESC [ RunTime:0.010660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350395 LIMIT 2 [ RunTime:0.014662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350395 ORDER BY `minOrder` ASC [ RunTime:0.017287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349738 LIMIT 5 [ RunTime:0.024389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349738 ORDER BY `minOrder` ASC [ RunTime:0.018521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349738 ORDER BY `unit` DESC [ RunTime:0.060188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349738 LIMIT 2 [ RunTime:0.016124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349738 ORDER BY `minOrder` ASC [ RunTime:0.007201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14655744 LIMIT 5 [ RunTime:0.033365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14655744 ORDER BY `minOrder` ASC [ RunTime:0.021020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14655744 ORDER BY `unit` DESC [ RunTime:0.038025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14655744 LIMIT 2 [ RunTime:0.011794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14655744 ORDER BY `minOrder` ASC [ RunTime:0.002985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13751645 LIMIT 5 [ RunTime:0.011897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13751645 ORDER BY `minOrder` ASC [ RunTime:0.005379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13751645 ORDER BY `unit` DESC [ RunTime:0.019528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13751645 LIMIT 2 [ RunTime:0.020153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13751645 ORDER BY `minOrder` ASC [ RunTime:0.007034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14544733 LIMIT 5 [ RunTime:0.013669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14544733 ORDER BY `minOrder` ASC [ RunTime:0.044163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14544733 ORDER BY `unit` DESC [ RunTime:0.028478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14544733 LIMIT 2 [ RunTime:0.013924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14544733 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628579 LIMIT 5 [ RunTime:0.016729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628579 ORDER BY `minOrder` ASC [ RunTime:0.024435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14628579 ORDER BY `unit` DESC [ RunTime:0.021843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14628579 LIMIT 2 [ RunTime:0.032809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628579 ORDER BY `minOrder` ASC [ RunTime:0.004081s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134785 LIMIT 5 [ RunTime:0.021278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134785 ORDER BY `minOrder` ASC [ RunTime:0.030485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134785 ORDER BY `unit` DESC [ RunTime:0.059359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134785 LIMIT 2 [ RunTime:0.027667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134785 ORDER BY `minOrder` ASC [ RunTime:0.016310s ]
select * from pdf where partno='7093-0177' and brandshort='amphenol / sv microwave' limit 1 [ RunTime:0.026523s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093-0177' OR `brand` LIKE 'amphenol / sv microwave%' ) ) LIMIT 1 [ RunTime:0.030130s ]
SELECT `id` FROM `stock` WHERE `id` <> 51134785 AND `partno` = '7093-0177' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol / sv microwave%' ) [ RunTime:0.033066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32262486 LIMIT 5 [ RunTime:0.018085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32262486 ORDER BY `minOrder` ASC [ RunTime:0.024477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32262486 ORDER BY `unit` DESC [ RunTime:0.028845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32262486 LIMIT 2 [ RunTime:0.022240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32262486 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
select * from pdf where partno='7093-0174' and brandshort='amphenol / sv microwave' limit 1 [ RunTime:0.013341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093-0174' OR `brand` LIKE 'amphenol / sv microwave%' ) ) LIMIT 1 [ RunTime:0.020318s ]
SELECT `id` FROM `stock` WHERE `id` <> 32262486 AND `partno` = '7093-0174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol / sv microwave%' ) [ RunTime:0.048577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32205465 [ RunTime:0.019388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32205465 LIMIT 5 [ RunTime:0.039983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32205465 ORDER BY `minOrder` ASC [ RunTime:0.016952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32205465 ORDER BY `unit` DESC [ RunTime:0.041037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32205465 LIMIT 2 [ RunTime:0.022359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32205465 ORDER BY `minOrder` ASC [ RunTime:0.002873s ]
select * from pdf where partno='7093-0174' and brandshort='amphenol / sv microwave' limit 1 [ RunTime:0.001585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093-0174' OR `brand` LIKE 'amphenol / sv microwave%' ) ) LIMIT 1 [ RunTime:0.008104s ]
SELECT `id` FROM `stock` WHERE `id` <> 32205465 AND `partno` = '7093-0174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol / sv microwave%' ) [ RunTime:0.042413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32262486 [ RunTime:0.024872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134902 LIMIT 5 [ RunTime:0.030130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134902 ORDER BY `minOrder` ASC [ RunTime:0.039993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134902 ORDER BY `unit` DESC [ RunTime:0.025341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134902 LIMIT 2 [ RunTime:0.065013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134902 ORDER BY `minOrder` ASC [ RunTime:0.051361s ]
select * from pdf where partno='7093-0181' and brandshort='amphenol / sv microwave' limit 1 [ RunTime:0.073442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093-0181' OR `brand` LIKE 'amphenol / sv microwave%' ) ) LIMIT 1 [ RunTime:0.123475s ]
SELECT `id` FROM `stock` WHERE `id` <> 51134902 AND `partno` = '7093-0181' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol / sv microwave%' ) [ RunTime:0.124430s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.107764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560318 LIMIT 5 [ RunTime:0.042642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560318 ORDER BY `minOrder` ASC [ RunTime:0.086896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560318 ORDER BY `unit` DESC [ RunTime:0.019204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560318 LIMIT 2 [ RunTime:0.072885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560318 ORDER BY `minOrder` ASC [ RunTime:0.001109s ]
select * from pdf where partno='70937CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.029445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70937CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.042778s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560318 AND `partno` = '70937CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.099001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349738 [ RunTime:0.011774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586247 LIMIT 5 [ RunTime:0.025402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586247 ORDER BY `minOrder` ASC [ RunTime:0.023695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586247 ORDER BY `unit` DESC [ RunTime:0.085176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586247 LIMIT 2 [ RunTime:0.045052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586247 ORDER BY `minOrder` ASC [ RunTime:0.009094s ]
select * from pdf where partno='7093C' and brandshort='3M' limit 1 [ RunTime:0.000556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093C' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.020927s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586247 AND `partno` = '7093C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.052337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12169951 [ RunTime:0.009166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560606 LIMIT 5 [ RunTime:0.019984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560606 ORDER BY `minOrder` ASC [ RunTime:0.027214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560606 ORDER BY `unit` DESC [ RunTime:0.014291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560606 LIMIT 2 [ RunTime:0.015902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560606 ORDER BY `minOrder` ASC [ RunTime:0.006314s ]
select * from pdf where partno='70938CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70938CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004469s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560606 AND `partno` = '70938CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.014052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349906 [ RunTime:0.003113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560321 LIMIT 5 [ RunTime:0.006560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560321 ORDER BY `minOrder` ASC [ RunTime:0.006513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560321 ORDER BY `unit` DESC [ RunTime:0.014353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560321 LIMIT 2 [ RunTime:0.004230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560321 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
select * from pdf where partno='70939CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70939CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010163s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560321 AND `partno` = '70939CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349729 [ RunTime:0.001284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586244 LIMIT 5 [ RunTime:0.005298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586244 ORDER BY `minOrder` ASC [ RunTime:0.001323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586244 ORDER BY `unit` DESC [ RunTime:0.000985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586244 LIMIT 2 [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586244 ORDER BY `minOrder` ASC [ RunTime:0.010980s ]
select * from pdf where partno='7093B' and brandshort='3M' limit 1 [ RunTime:0.004693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093B' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.005712s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586244 AND `partno` = '7093B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.003016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560324 LIMIT 5 [ RunTime:0.003851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560324 ORDER BY `minOrder` ASC [ RunTime:0.001913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560324 ORDER BY `unit` DESC [ RunTime:0.005837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560324 LIMIT 2 [ RunTime:0.002834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560324 ORDER BY `minOrder` ASC [ RunTime:0.002069s ]
select * from pdf where partno='70931CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70931CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000726s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560324 AND `partno` = '70931CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561292 LIMIT 5 [ RunTime:0.005937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561292 ORDER BY `minOrder` ASC [ RunTime:0.007233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561292 ORDER BY `unit` DESC [ RunTime:0.009536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561292 LIMIT 2 [ RunTime:0.001735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561292 ORDER BY `minOrder` ASC [ RunTime:0.002691s ]
select * from pdf where partno='70935SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70935SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001561s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561292 AND `partno` = '70935SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067644 [ RunTime:0.003865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560332 LIMIT 5 [ RunTime:0.003506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560332 ORDER BY `minOrder` ASC [ RunTime:0.008527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560332 ORDER BY `unit` DESC [ RunTime:0.006599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560332 LIMIT 2 [ RunTime:0.002628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560332 ORDER BY `minOrder` ASC [ RunTime:0.001288s ]
select * from pdf where partno='70934CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70934CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008922s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560332 AND `partno` = '70934CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.008276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560333 LIMIT 5 [ RunTime:0.001819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560333 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560333 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560333 LIMIT 2 [ RunTime:0.001349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560333 ORDER BY `minOrder` ASC [ RunTime:0.000841s ]
select * from pdf where partno='70935CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70935CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003980s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560333 AND `partno` = '70935CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067267 [ RunTime:0.001866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561661 LIMIT 5 [ RunTime:0.003304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561661 ORDER BY `minOrder` ASC [ RunTime:0.009098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561661 ORDER BY `unit` DESC [ RunTime:0.002836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561661 LIMIT 2 [ RunTime:0.005474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561661 ORDER BY `minOrder` ASC [ RunTime:0.001897s ]
select * from pdf where partno='70939SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70939SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.005135s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561661 AND `partno` = '70939SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067832 [ RunTime:0.000937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561316 LIMIT 5 [ RunTime:0.004668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561316 ORDER BY `minOrder` ASC [ RunTime:0.013066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561316 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561316 LIMIT 2 [ RunTime:0.005349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561316 ORDER BY `minOrder` ASC [ RunTime:0.003936s ]
select * from pdf where partno='70934SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70934SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008163s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561316 AND `partno` = '70934SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067647 [ RunTime:0.003227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561663 LIMIT 5 [ RunTime:0.002639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561663 ORDER BY `minOrder` ASC [ RunTime:0.006472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561663 ORDER BY `unit` DESC [ RunTime:0.011042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561663 LIMIT 2 [ RunTime:0.005719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561663 ORDER BY `minOrder` ASC [ RunTime:0.003479s ]
select * from pdf where partno='70932SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70932SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004372s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561663 AND `partno` = '70932SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350639 [ RunTime:0.007117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560656 LIMIT 5 [ RunTime:0.013894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560656 ORDER BY `minOrder` ASC [ RunTime:0.007159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560656 ORDER BY `unit` DESC [ RunTime:0.012683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560656 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560656 ORDER BY `minOrder` ASC [ RunTime:0.004799s ]
select * from pdf where partno='70932CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70932CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.005657s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560656 AND `partno` = '70932CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067368 [ RunTime:0.001661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561327 LIMIT 5 [ RunTime:0.001860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561327 ORDER BY `minOrder` ASC [ RunTime:0.003388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561327 ORDER BY `unit` DESC [ RunTime:0.009626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561327 LIMIT 2 [ RunTime:0.002625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561327 ORDER BY `minOrder` ASC [ RunTime:0.001881s ]
select * from pdf where partno='70933SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70933SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.012458s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561327 AND `partno` = '70933SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.014528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560343 LIMIT 5 [ RunTime:0.002830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560343 ORDER BY `minOrder` ASC [ RunTime:0.003065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560343 ORDER BY `unit` DESC [ RunTime:0.012924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560343 LIMIT 2 [ RunTime:0.005042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560343 ORDER BY `minOrder` ASC [ RunTime:0.001807s ]
select * from pdf where partno='70936CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70936CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.015471s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560343 AND `partno` = '70936CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349728 [ RunTime:0.011616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560344 LIMIT 5 [ RunTime:0.011762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560344 ORDER BY `minOrder` ASC [ RunTime:0.021045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560344 ORDER BY `unit` DESC [ RunTime:0.007599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560344 LIMIT 2 [ RunTime:0.019604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560344 ORDER BY `minOrder` ASC [ RunTime:0.007940s ]
select * from pdf where partno='70930CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.042970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70930CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002841s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560344 AND `partno` = '70930CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067264 [ RunTime:0.014496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565889 LIMIT 5 [ RunTime:0.012230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565889 ORDER BY `minOrder` ASC [ RunTime:0.005139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565889 ORDER BY `unit` DESC [ RunTime:0.003871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565889 LIMIT 2 [ RunTime:0.002901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565889 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='70931SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70931SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004282s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565889 AND `partno` = '70931SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.010165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350395 [ RunTime:0.009140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62454916 LIMIT 5 [ RunTime:0.008219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62454916 ORDER BY `minOrder` ASC [ RunTime:0.006680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62454916 ORDER BY `unit` DESC [ RunTime:0.011865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62454916 LIMIT 2 [ RunTime:0.002321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62454916 ORDER BY `minOrder` ASC [ RunTime:0.007967s ]
select * from pdf where partno='7093-0175' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.003148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093-0175' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.002188s ]
SELECT `id` FROM `stock` WHERE `id` <> 62454916 AND `partno` = '7093-0175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.011320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14655744 [ RunTime:0.010815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565956 LIMIT 5 [ RunTime:0.013228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565956 ORDER BY `minOrder` ASC [ RunTime:0.013846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565956 ORDER BY `unit` DESC [ RunTime:0.019738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565956 LIMIT 2 [ RunTime:0.003713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565956 ORDER BY `minOrder` ASC [ RunTime:0.005203s ]
select * from pdf where partno='70937SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70937SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002073s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565956 AND `partno` = '70937SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067826 [ RunTime:0.006100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62455259 LIMIT 5 [ RunTime:0.007030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62455259 ORDER BY `minOrder` ASC [ RunTime:0.010014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62455259 ORDER BY `unit` DESC [ RunTime:0.006515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62455259 LIMIT 2 [ RunTime:0.012135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62455259 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
select * from pdf where partno='7093-0184' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.005105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7093-0184' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.021070s ]
SELECT `id` FROM `stock` WHERE `id` <> 62455259 AND `partno` = '7093-0184' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.016788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14544733 [ RunTime:0.014425s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016383s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010787s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008468s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010662s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003747s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022962s ]
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 '7093%' OR `brand` LIKE '7093%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013078s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7093%' OR `brand` LIKE '7093%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010225s ]