SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002504s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=6713&search=1' [ RunTime:0.002915s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002189s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000569s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002300s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003150s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000313s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002296s ]
SELECT * FROM `stock_search` WHERE `partno` = '6713' LIMIT 1 [ RunTime:0.001176s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 15:18:18' WHERE `partno` = '6713' [ RunTime:0.002839s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002386s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008255s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363268 LIMIT 5 [ RunTime:0.002133s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363268 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363268 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363268 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363268 ORDER BY `minOrder` ASC [ RunTime:0.002165s ]
select * from pdf where partno='6713 VI001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13387517 LIMIT 5 [ RunTime:0.005487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13387517 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13387517 ORDER BY `unit` DESC [ RunTime:0.001635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13387517 LIMIT 2 [ RunTime:0.001249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13387517 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
select * from pdf where partno='67130850' and brandshort='Schott Corporation' limit 1 [ RunTime:0.001196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407048 LIMIT 5 [ RunTime:0.000977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407048 ORDER BY `minOrder` ASC [ RunTime:0.002487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407048 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407048 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407048 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
select * from pdf where partno='6713 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548971 LIMIT 5 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548971 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15548971 ORDER BY `unit` DESC [ RunTime:0.000709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15548971 LIMIT 2 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548971 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370549 LIMIT 5 [ RunTime:0.000868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370549 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14370549 ORDER BY `unit` DESC [ RunTime:0.000646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14370549 LIMIT 2 [ RunTime:0.002316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370549 ORDER BY `minOrder` ASC [ RunTime:0.002579s ]
select * from pdf where partno='6713 RD001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363352 LIMIT 5 [ RunTime:0.003451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363352 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363352 ORDER BY `unit` DESC [ RunTime:0.002265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363352 LIMIT 2 [ RunTime:0.001726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363352 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
select * from pdf where partno='6713 DB005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363351 LIMIT 5 [ RunTime:0.002459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363351 ORDER BY `minOrder` ASC [ RunTime:0.005796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363351 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363351 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363351 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
select * from pdf where partno='6713 OR005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492783 LIMIT 5 [ RunTime:0.001127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492783 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492783 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492783 LIMIT 2 [ RunTime:0.002835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492783 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
select * from pdf where partno='6713 OR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407050 LIMIT 5 [ RunTime:0.001198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407050 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407050 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407050 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407050 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
select * from pdf where partno='6713 WH005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407841 LIMIT 5 [ RunTime:0.000907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407841 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407841 ORDER BY `unit` DESC [ RunTime:0.000599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407841 LIMIT 2 [ RunTime:0.000587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407841 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
select * from pdf where partno='6713 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370548 LIMIT 5 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370548 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14370548 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14370548 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370548 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='6713 GR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407840 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407840 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407840 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407840 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407840 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='6713 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407322 LIMIT 5 [ RunTime:0.004241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407322 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407322 ORDER BY `unit` DESC [ RunTime:0.004832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407322 LIMIT 2 [ RunTime:0.001753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407322 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='6713 VI005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407100 LIMIT 5 [ RunTime:0.000740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407100 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407100 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407100 LIMIT 2 [ RunTime:0.002735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407100 ORDER BY `minOrder` ASC [ RunTime:0.002407s ]
select * from pdf where partno='6713 BL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492141 LIMIT 5 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492141 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492141 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492141 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492141 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='6713 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407323 LIMIT 5 [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407323 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407323 ORDER BY `unit` DESC [ RunTime:0.001659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407323 LIMIT 2 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407323 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='6713 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407099 LIMIT 5 [ RunTime:0.008604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407099 ORDER BY `minOrder` ASC [ RunTime:0.011597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407099 ORDER BY `unit` DESC [ RunTime:0.001691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407099 LIMIT 2 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407099 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='6713 YL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370760 LIMIT 5 [ RunTime:0.003431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370760 ORDER BY `minOrder` ASC [ RunTime:0.006073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14370760 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14370760 LIMIT 2 [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370760 ORDER BY `minOrder` ASC [ RunTime:0.001810s ]
select * from pdf where partno='6713 WU005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492340 LIMIT 5 [ RunTime:0.003075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492340 ORDER BY `minOrder` ASC [ RunTime:0.001574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492340 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492340 LIMIT 2 [ RunTime:0.002926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492340 ORDER BY `minOrder` ASC [ RunTime:0.009524s ]
select * from pdf where partno='6713 GR005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.032148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492341 LIMIT 5 [ RunTime:0.012773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492341 ORDER BY `minOrder` ASC [ RunTime:0.007760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492341 ORDER BY `unit` DESC [ RunTime:0.012762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492341 LIMIT 2 [ RunTime:0.003939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492341 ORDER BY `minOrder` ASC [ RunTime:0.003021s ]
select * from pdf where partno='6713 GY005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.014356s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139034 LIMIT 5 [ RunTime:0.009107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139034 ORDER BY `minOrder` ASC [ RunTime:0.012436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139034 ORDER BY `unit` DESC [ RunTime:0.003667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139034 LIMIT 2 [ RunTime:0.012220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139034 ORDER BY `minOrder` ASC [ RunTime:0.009226s ]
select * from pdf where partno='6713 rd005' and brandshort='alpha wire' limit 1 [ RunTime:0.005085s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 rd005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.001092s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139034 AND `partno` = '6713 rd005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407049 [ RunTime:0.008315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139035 LIMIT 5 [ RunTime:0.044197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139035 ORDER BY `minOrder` ASC [ RunTime:0.033984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139035 ORDER BY `unit` DESC [ RunTime:0.018602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139035 LIMIT 2 [ RunTime:0.027910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139035 ORDER BY `minOrder` ASC [ RunTime:0.033415s ]
select * from pdf where partno='6713 wh001' and brandshort='alpha wire' limit 1 [ RunTime:0.050542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 wh001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.089866s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139035 AND `partno` = '6713 wh001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.046675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407841 [ RunTime:0.047771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139036 LIMIT 5 [ RunTime:0.021392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139036 ORDER BY `minOrder` ASC [ RunTime:0.025673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139036 ORDER BY `unit` DESC [ RunTime:0.003235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139036 LIMIT 2 [ RunTime:0.011864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139036 ORDER BY `minOrder` ASC [ RunTime:0.005561s ]
select * from pdf where partno='6713 rd001' and brandshort='alpha wire' limit 1 [ RunTime:0.007596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 rd001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.009223s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139036 AND `partno` = '6713 rd001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.035474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370549 [ RunTime:0.021995s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041536 LIMIT 5 [ RunTime:0.015123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041536 ORDER BY `minOrder` ASC [ RunTime:0.024724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041536 ORDER BY `unit` DESC [ RunTime:0.001082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041536 LIMIT 2 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041536 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
select * from pdf where partno='6713 VI001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 VI001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000569s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041536 AND `partno` = '6713 VI001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363268 [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63045980 LIMIT 5 [ RunTime:0.001919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63045980 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63045980 ORDER BY `unit` DESC [ RunTime:0.001434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63045980 LIMIT 2 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63045980 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='6713 DB001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 DB001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.008493s ]
SELECT `id` FROM `stock` WHERE `id` <> 63045980 AND `partno` = '6713 DB001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.006701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363879 [ RunTime:0.004438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58266771 LIMIT 5 [ RunTime:0.004595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58266771 ORDER BY `minOrder` ASC [ RunTime:0.001727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58266771 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58266771 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58266771 ORDER BY `minOrder` ASC [ RunTime:0.004192s ]
select * from pdf where partno='67130850' and brandshort='Schott Corporation' limit 1 [ RunTime:0.001774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67130850' OR `brand` LIKE 'Schott Corporation%' ) ) LIMIT 1 [ RunTime:0.002026s ]
SELECT `id` FROM `stock` WHERE `id` <> 58266771 AND `partno` = '67130850' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schott corporation%' ) [ RunTime:0.014763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13387517 [ RunTime:0.001684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041725 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041725 ORDER BY `minOrder` ASC [ RunTime:0.003798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041725 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041725 LIMIT 2 [ RunTime:0.006697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041725 ORDER BY `minOrder` ASC [ RunTime:0.006353s ]
select * from pdf where partno='6713 BL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 BL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001279s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041725 AND `partno` = '6713 BL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.007958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14372484 [ RunTime:0.001147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041726 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041726 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041726 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041726 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041726 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='6713 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002298s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041726 AND `partno` = '6713 BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407048 [ RunTime:0.000646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60608038 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60608038 ORDER BY `minOrder` ASC [ RunTime:0.010130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60608038 ORDER BY `unit` DESC [ RunTime:0.013742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60608038 LIMIT 2 [ RunTime:0.006000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60608038 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
select * from pdf where partno='6713' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.003563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.004195s ]
SELECT `id` FROM `stock` WHERE `id` <> 60608038 AND `partno` = '6713' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.001007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548971 [ RunTime:0.002530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041727 LIMIT 5 [ RunTime:0.001203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041727 ORDER BY `minOrder` ASC [ RunTime:0.020501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041727 ORDER BY `unit` DESC [ RunTime:0.009970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041727 LIMIT 2 [ RunTime:0.009467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041727 ORDER BY `minOrder` ASC [ RunTime:0.001754s ]
select * from pdf where partno='6713 RD005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 RD005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000969s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041727 AND `partno` = '6713 RD005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407049 [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042110 LIMIT 5 [ RunTime:0.001383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042110 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042110 ORDER BY `unit` DESC [ RunTime:0.014135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042110 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042110 ORDER BY `minOrder` ASC [ RunTime:0.003464s ]
select * from pdf where partno='6713 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 WH001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000862s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042110 AND `partno` = '6713 WH001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.011028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407841 [ RunTime:0.003719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042116 LIMIT 5 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042116 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042116 ORDER BY `unit` DESC [ RunTime:0.000829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042116 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042116 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
select * from pdf where partno='6713 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 BK001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000862s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042116 AND `partno` = '6713 BK001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407840 [ RunTime:0.000706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63044124 LIMIT 5 [ RunTime:0.006726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63044124 ORDER BY `minOrder` ASC [ RunTime:0.001199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63044124 ORDER BY `unit` DESC [ RunTime:0.000764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63044124 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63044124 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
select * from pdf where partno='6713 DB005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 DB005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000794s ]
SELECT `id` FROM `stock` WHERE `id` <> 63044124 AND `partno` = '6713 DB005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363352 [ RunTime:0.002023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042118 LIMIT 5 [ RunTime:0.005429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042118 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042118 ORDER BY `unit` DESC [ RunTime:0.001385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042118 LIMIT 2 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042118 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
select * from pdf where partno='6713 BL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 BL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000843s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042118 AND `partno` = '6713 BL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13493708 [ RunTime:0.001079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042119 LIMIT 5 [ RunTime:0.001351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042119 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042119 ORDER BY `unit` DESC [ RunTime:0.000970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042119 LIMIT 2 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042119 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
select * from pdf where partno='6713 RD001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 RD001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000859s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042119 AND `partno` = '6713 RD001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370549 [ RunTime:0.003399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042806 LIMIT 5 [ RunTime:0.012036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042806 ORDER BY `minOrder` ASC [ RunTime:0.011095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042806 ORDER BY `unit` DESC [ RunTime:0.007046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042806 LIMIT 2 [ RunTime:0.006665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042806 ORDER BY `minOrder` ASC [ RunTime:0.001972s ]
select * from pdf where partno='6713 YL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 YL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006292s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042806 AND `partno` = '6713 YL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407324 [ RunTime:0.004297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042807 LIMIT 5 [ RunTime:0.003902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042807 ORDER BY `minOrder` ASC [ RunTime:0.004110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042807 ORDER BY `unit` DESC [ RunTime:0.002094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042807 LIMIT 2 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042807 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
select * from pdf where partno='6713 WU005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 WU005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000449s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042807 AND `partno` = '6713 WU005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370760 [ RunTime:0.001207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63048599 LIMIT 5 [ RunTime:0.001867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048599 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63048599 ORDER BY `unit` DESC [ RunTime:0.001367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63048599 LIMIT 2 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048599 ORDER BY `minOrder` ASC [ RunTime:0.007766s ]
select * from pdf where partno='6713 VI005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 VI005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001253s ]
SELECT `id` FROM `stock` WHERE `id` <> 63048599 AND `partno` = '6713 VI005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407322 [ RunTime:0.000720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63048600 LIMIT 5 [ RunTime:0.003996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048600 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63048600 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63048600 LIMIT 2 [ RunTime:0.003676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048600 ORDER BY `minOrder` ASC [ RunTime:0.008305s ]
select * from pdf where partno='6713 BR005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 BR005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001693s ]
SELECT `id` FROM `stock` WHERE `id` <> 63048600 AND `partno` = '6713 BR005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407325 [ RunTime:0.001596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63048602 LIMIT 5 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048602 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63048602 ORDER BY `unit` DESC [ RunTime:0.000628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63048602 LIMIT 2 [ RunTime:0.003143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048602 ORDER BY `minOrder` ASC [ RunTime:0.003630s ]
select * from pdf where partno='6713 WH005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 WH005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001987s ]
SELECT `id` FROM `stock` WHERE `id` <> 63048602 AND `partno` = '6713 WH005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407050 [ RunTime:0.001530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63048601 LIMIT 5 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048601 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63048601 ORDER BY `unit` DESC [ RunTime:0.000683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63048601 LIMIT 2 [ RunTime:0.003622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048601 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
select * from pdf where partno='6713 OR005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 OR005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.007928s ]
SELECT `id` FROM `stock` WHERE `id` <> 63048601 AND `partno` = '6713 OR005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.006831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363351 [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63048603 LIMIT 5 [ RunTime:0.004249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048603 ORDER BY `minOrder` ASC [ RunTime:0.007519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63048603 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63048603 LIMIT 2 [ RunTime:0.003241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63048603 ORDER BY `minOrder` ASC [ RunTime:0.006623s ]
select * from pdf where partno='6713 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001997s ]
SELECT `id` FROM `stock` WHERE `id` <> 63048603 AND `partno` = '6713 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407323 [ RunTime:0.005531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042117 LIMIT 5 [ RunTime:0.006221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042117 ORDER BY `minOrder` ASC [ RunTime:0.006198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042117 ORDER BY `unit` DESC [ RunTime:0.003906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042117 LIMIT 2 [ RunTime:0.007470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042117 ORDER BY `minOrder` ASC [ RunTime:0.002973s ]
select * from pdf where partno='6713 OR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6713 OR001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001120s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042117 AND `partno` = '6713 OR001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492783 [ RunTime:0.008806s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001828s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009151s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005585s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017377s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013434s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002879s ]
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 '6713%' OR `brand` LIKE '6713%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022727s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6713%' OR `brand` LIKE '6713%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003282s ]