SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003175s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=228&page=91&srecordnum=10000' [ RunTime:0.001917s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002099s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000579s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002357s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002239s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004002s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002171s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004207s ]
UPDATE `stock_search` SET `count` = 1987 , `updatetime` = '2026-06-12 13:50:44' WHERE `partno` = '228' [ RunTime:0.002339s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000282s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003219s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.000398s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1800,20 [ RunTime:0.095901s ]
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 ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32924915','32924914','32924913','32924912','32924911','32924910','32924909','32924908','32924907','32924906','32924905','32924904','32924903','32924902','32924901','32924900','32924899','32924898','32924897','32924896') ORDER BY FIELD(s.id, 32924915,32924914,32924913,32924912,32924911,32924910,32924909,32924908,32924907,32924906,32924905,32924904,32924903,32924902,32924901,32924900,32924899,32924898,32924897,32924896) [ RunTime:0.013244s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924915 LIMIT 4 [ RunTime:0.010298s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924915 ORDER BY `minOrder` ASC [ RunTime:0.013908s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924915 ORDER BY `unit` DESC [ RunTime:0.006698s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924915 LIMIT 2 [ RunTime:0.004943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924915 ORDER BY `minOrder` ASC [ RunTime:0.006874s ]
select * from pdf where partno='228CDVARGBFEBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021457s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFEBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041243s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924915 AND `partno` = '228CDVARGBFEBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449532 [ RunTime:0.007351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924914 LIMIT 4 [ RunTime:0.044575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924914 ORDER BY `minOrder` ASC [ RunTime:0.029842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924914 ORDER BY `unit` DESC [ RunTime:0.025210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924914 LIMIT 2 [ RunTime:0.048167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924914 ORDER BY `minOrder` ASC [ RunTime:0.027107s ]
select * from pdf where partno='228CDVARAFFWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.036656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019088s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924914 AND `partno` = '228CDVARAFFWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.103719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449531 [ RunTime:0.130311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924913 LIMIT 4 [ RunTime:0.033167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924913 ORDER BY `minOrder` ASC [ RunTime:0.062939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924913 ORDER BY `unit` DESC [ RunTime:0.026358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924913 LIMIT 2 [ RunTime:0.085131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924913 ORDER BY `minOrder` ASC [ RunTime:0.020243s ]
select * from pdf where partno='228CDVARAFFMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028338s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924913 AND `partno` = '228CDVARAFFMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.045253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449530 [ RunTime:0.020002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924912 LIMIT 4 [ RunTime:0.020377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924912 ORDER BY `minOrder` ASC [ RunTime:0.029803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924912 ORDER BY `unit` DESC [ RunTime:0.036384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924912 LIMIT 2 [ RunTime:0.034797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924912 ORDER BY `minOrder` ASC [ RunTime:0.007974s ]
select * from pdf where partno='228CDVAWFBRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFBRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022698s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924912 AND `partno` = '228CDVAWFBRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366317 [ RunTime:0.021285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924911 LIMIT 4 [ RunTime:0.030126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924911 ORDER BY `minOrder` ASC [ RunTime:0.019736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924911 ORDER BY `unit` DESC [ RunTime:0.015726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924911 LIMIT 2 [ RunTime:0.047370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924911 ORDER BY `minOrder` ASC [ RunTime:0.014193s ]
select * from pdf where partno='228CDVAAFDMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFDMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007976s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924911 AND `partno` = '228CDVAAFDMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449529 [ RunTime:0.023522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924910 LIMIT 4 [ RunTime:0.014186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924910 ORDER BY `minOrder` ASC [ RunTime:0.011981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924910 ORDER BY `unit` DESC [ RunTime:0.008278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924910 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924910 ORDER BY `minOrder` ASC [ RunTime:0.005122s ]
select * from pdf where partno='228CDVAGFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008206s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924910 AND `partno` = '228CDVAGFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.038619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366316 [ RunTime:0.009939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924909 LIMIT 4 [ RunTime:0.018622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924909 ORDER BY `minOrder` ASC [ RunTime:0.021647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924909 ORDER BY `unit` DESC [ RunTime:0.018523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924909 LIMIT 2 [ RunTime:0.013577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924909 ORDER BY `minOrder` ASC [ RunTime:0.014107s ]
select * from pdf where partno='228CDVAAFDBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFDBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020640s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924909 AND `partno` = '228CDVAAFDBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366315 [ RunTime:0.035374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924908 LIMIT 4 [ RunTime:0.005103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924908 ORDER BY `minOrder` ASC [ RunTime:0.004287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924908 ORDER BY `unit` DESC [ RunTime:0.015713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924908 LIMIT 2 [ RunTime:0.014034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924908 ORDER BY `minOrder` ASC [ RunTime:0.011261s ]
select * from pdf where partno='228CDVAAFDRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFDRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.026162s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924908 AND `partno` = '228CDVAAFDRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366314 [ RunTime:0.011896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924907 LIMIT 4 [ RunTime:0.008779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924907 ORDER BY `minOrder` ASC [ RunTime:0.002450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924907 ORDER BY `unit` DESC [ RunTime:0.005076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924907 LIMIT 2 [ RunTime:0.032891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924907 ORDER BY `minOrder` ASC [ RunTime:0.024751s ]
select * from pdf where partno='228CDVARFAMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004412s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924907 AND `partno` = '228CDVARFAMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449528 [ RunTime:0.028645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924906 LIMIT 4 [ RunTime:0.040179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924906 ORDER BY `minOrder` ASC [ RunTime:0.013671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924906 ORDER BY `unit` DESC [ RunTime:0.045632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924906 LIMIT 2 [ RunTime:0.006348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924906 ORDER BY `minOrder` ASC [ RunTime:0.013870s ]
select * from pdf where partno='228CDVAYGFFRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYGFFRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013391s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924906 AND `partno` = '228CDVAYGFFRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366313 [ RunTime:0.015165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924905 LIMIT 4 [ RunTime:0.010807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924905 ORDER BY `minOrder` ASC [ RunTime:0.021825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924905 ORDER BY `unit` DESC [ RunTime:0.066798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924905 LIMIT 2 [ RunTime:0.012977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924905 ORDER BY `minOrder` ASC [ RunTime:0.039794s ]
select * from pdf where partno='228CDVAYGFFAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYGFFAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005665s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924905 AND `partno` = '228CDVAYGFFAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.054827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449527 [ RunTime:0.057497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924904 LIMIT 4 [ RunTime:0.052081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924904 ORDER BY `minOrder` ASC [ RunTime:0.028492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924904 ORDER BY `unit` DESC [ RunTime:0.028804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924904 LIMIT 2 [ RunTime:0.053665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924904 ORDER BY `minOrder` ASC [ RunTime:0.005516s ]
select * from pdf where partno='228CDVAAWFFAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFFAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022488s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924904 AND `partno` = '228CDVAAWFFAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449526 [ RunTime:0.022785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924903 LIMIT 4 [ RunTime:0.021338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924903 ORDER BY `minOrder` ASC [ RunTime:0.004831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924903 ORDER BY `unit` DESC [ RunTime:0.027014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924903 LIMIT 2 [ RunTime:0.038293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924903 ORDER BY `minOrder` ASC [ RunTime:0.029133s ]
select * from pdf where partno='228CDVAAWFFRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.034657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFFRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028066s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924903 AND `partno` = '228CDVAAWFFRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449525 [ RunTime:0.024746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924902 LIMIT 4 [ RunTime:0.036195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924902 ORDER BY `minOrder` ASC [ RunTime:0.071854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924902 ORDER BY `unit` DESC [ RunTime:0.050224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924902 LIMIT 2 [ RunTime:0.021622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924902 ORDER BY `minOrder` ASC [ RunTime:0.004475s ]
select * from pdf where partno='228CDVAAFAWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.028206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFAWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.031201s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924902 AND `partno` = '228CDVAAFAWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449524 [ RunTime:0.009702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924901 LIMIT 4 [ RunTime:0.026048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924901 ORDER BY `minOrder` ASC [ RunTime:0.014585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924901 ORDER BY `unit` DESC [ RunTime:0.007627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924901 LIMIT 2 [ RunTime:0.010344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924901 ORDER BY `minOrder` ASC [ RunTime:0.018993s ]
select * from pdf where partno='228CDVAAFDWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFDWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027704s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924901 AND `partno` = '228CDVAAFDWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924900 LIMIT 4 [ RunTime:0.025199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924900 ORDER BY `minOrder` ASC [ RunTime:0.028456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924900 ORDER BY `unit` DESC [ RunTime:0.026018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924900 LIMIT 2 [ RunTime:0.018014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924900 ORDER BY `minOrder` ASC [ RunTime:0.017880s ]
select * from pdf where partno='228CDVABFARC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVABFARC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.030195s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924900 AND `partno` = '228CDVABFARC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366312 [ RunTime:0.016858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924899 LIMIT 4 [ RunTime:0.031187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924899 ORDER BY `minOrder` ASC [ RunTime:0.023878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924899 ORDER BY `unit` DESC [ RunTime:0.016346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924899 LIMIT 2 [ RunTime:0.018996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924899 ORDER BY `minOrder` ASC [ RunTime:0.007387s ]
select * from pdf where partno='228CDVARGBFDWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFDWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007895s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924899 AND `partno` = '228CDVARGBFDWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366311 [ RunTime:0.014286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924898 LIMIT 4 [ RunTime:0.035734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924898 ORDER BY `minOrder` ASC [ RunTime:0.043981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924898 ORDER BY `unit` DESC [ RunTime:0.041113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924898 LIMIT 2 [ RunTime:0.018690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924898 ORDER BY `minOrder` ASC [ RunTime:0.009587s ]
select * from pdf where partno='228CDVARFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039989s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924898 AND `partno` = '228CDVARFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366310 [ RunTime:0.029582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924897 LIMIT 4 [ RunTime:0.010263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924897 ORDER BY `minOrder` ASC [ RunTime:0.021600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924897 ORDER BY `unit` DESC [ RunTime:0.046510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924897 LIMIT 2 [ RunTime:0.012966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924897 ORDER BY `minOrder` ASC [ RunTime:0.013719s ]
select * from pdf where partno='228CDVARAFFAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011619s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924897 AND `partno` = '228CDVARAFFAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366309 [ RunTime:0.017917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924896 LIMIT 4 [ RunTime:0.007263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924896 ORDER BY `minOrder` ASC [ RunTime:0.008039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924896 ORDER BY `unit` DESC [ RunTime:0.012407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924896 LIMIT 2 [ RunTime:0.009282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924896 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
select * from pdf where partno='228CDVARGBFEMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFEMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012067s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924896 AND `partno` = '228CDVARGBFEMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004624s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.003666s ]