SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001486s ]
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=77&srecordnum=10000' [ RunTime:0.001765s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001394s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000549s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002501s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000310s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002153s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000414s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002292s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.001449s ]
UPDATE `stock_search` SET `count` = 1962 , `updatetime` = '2026-06-12 10:15:12' WHERE `partno` = '228' [ RunTime:0.007273s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000310s ]
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.000495s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002399s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.228338s ]
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 1520,20 [ RunTime:0.104205s ]
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 ('32925295','32925294','32925293','32925292','32925291','32925290','32925289','32925288','32925287','32925286','32925285','32925284','32925283','32925282','32925281','32925280','32925279','32925278','32925277','32925276') ORDER BY FIELD(s.id, 32925295,32925294,32925293,32925292,32925291,32925290,32925289,32925288,32925287,32925286,32925285,32925284,32925283,32925282,32925281,32925280,32925279,32925278,32925277,32925276) [ RunTime:0.026047s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925295 LIMIT 4 [ RunTime:0.013319s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925295 ORDER BY `minOrder` ASC [ RunTime:0.018500s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925295 ORDER BY `unit` DESC [ RunTime:0.002972s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925295 LIMIT 2 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925295 ORDER BY `minOrder` ASC [ RunTime:0.011947s ]
select * from pdf where partno='228CDVAYFDAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006705s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFDAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014363s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925295 AND `partno` = '228CDVAYFDAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449686 [ RunTime:0.035687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925294 LIMIT 4 [ RunTime:0.013568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925294 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925294 ORDER BY `unit` DESC [ RunTime:0.008356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925294 LIMIT 2 [ RunTime:0.007112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925294 ORDER BY `minOrder` ASC [ RunTime:0.003810s ]
select * from pdf where partno='228CDVARGBFBMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFBMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000846s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925294 AND `partno` = '228CDVARGBFBMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366408 [ RunTime:0.003117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925293 LIMIT 4 [ RunTime:0.001092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925293 ORDER BY `minOrder` ASC [ RunTime:0.012329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925293 ORDER BY `unit` DESC [ RunTime:0.009504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925293 LIMIT 2 [ RunTime:0.003436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925293 ORDER BY `minOrder` ASC [ RunTime:0.000921s ]
select * from pdf where partno='228CDVARFAAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011050s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925293 AND `partno` = '228CDVARFAAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449685 [ RunTime:0.006678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925292 LIMIT 4 [ RunTime:0.006951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925292 ORDER BY `minOrder` ASC [ RunTime:0.004690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925292 ORDER BY `unit` DESC [ RunTime:0.017744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925292 LIMIT 2 [ RunTime:0.012430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925292 ORDER BY `minOrder` ASC [ RunTime:0.007362s ]
select * from pdf where partno='228CDVARFBWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFBWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011964s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925292 AND `partno` = '228CDVARFBWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366407 [ RunTime:0.006898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925291 LIMIT 4 [ RunTime:0.007552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925291 ORDER BY `minOrder` ASC [ RunTime:0.018369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925291 ORDER BY `unit` DESC [ RunTime:0.017998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925291 LIMIT 2 [ RunTime:0.014330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925291 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='228CDVAAWFFMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFFMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008320s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925291 AND `partno` = '228CDVAAWFFMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449684 [ RunTime:0.013187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925290 LIMIT 4 [ RunTime:0.011668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925290 ORDER BY `minOrder` ASC [ RunTime:0.014559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925290 ORDER BY `unit` DESC [ RunTime:0.013051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925290 LIMIT 2 [ RunTime:0.004904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925290 ORDER BY `minOrder` ASC [ RunTime:0.011540s ]
select * from pdf where partno='228CDVARGFEAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.014966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFEAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014187s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925290 AND `partno` = '228CDVARGFEAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449683 [ RunTime:0.017823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925289 LIMIT 4 [ RunTime:0.015799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925289 ORDER BY `minOrder` ASC [ RunTime:0.015061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925289 ORDER BY `unit` DESC [ RunTime:0.008496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925289 LIMIT 2 [ RunTime:0.007325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925289 ORDER BY `minOrder` ASC [ RunTime:0.004908s ]
select * from pdf where partno='228CDVARGFFMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015826s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925289 AND `partno` = '228CDVARGFFMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449682 [ RunTime:0.006025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925288 LIMIT 4 [ RunTime:0.008460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925288 ORDER BY `minOrder` ASC [ RunTime:0.017773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925288 ORDER BY `unit` DESC [ RunTime:0.026239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925288 LIMIT 2 [ RunTime:0.018104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925288 ORDER BY `minOrder` ASC [ RunTime:0.012379s ]
select * from pdf where partno='228CDVARBFFRB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARBFFRB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019234s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925288 AND `partno` = '228CDVARBFFRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449681 [ RunTime:0.013945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925287 LIMIT 4 [ RunTime:0.008502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925287 ORDER BY `minOrder` ASC [ RunTime:0.036935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925287 ORDER BY `unit` DESC [ RunTime:0.017910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925287 LIMIT 2 [ RunTime:0.013397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925287 ORDER BY `minOrder` ASC [ RunTime:0.030072s ]
select * from pdf where partno='228CDVARFAAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFAAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013319s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925287 AND `partno` = '228CDVARFAAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449680 [ RunTime:0.005392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925286 LIMIT 4 [ RunTime:0.002824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925286 ORDER BY `minOrder` ASC [ RunTime:0.005104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925286 ORDER BY `unit` DESC [ RunTime:0.011342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925286 LIMIT 2 [ RunTime:0.001857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925286 ORDER BY `minOrder` ASC [ RunTime:0.001530s ]
select * from pdf where partno='228CDVAAFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004448s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925286 AND `partno` = '228CDVAAFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449679 [ RunTime:0.002954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925285 LIMIT 4 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925285 ORDER BY `minOrder` ASC [ RunTime:0.001246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925285 ORDER BY `unit` DESC [ RunTime:0.007925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925285 LIMIT 2 [ RunTime:0.010278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925285 ORDER BY `minOrder` ASC [ RunTime:0.005057s ]
select * from pdf where partno='228CDVARAFDBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFDBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017039s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925285 AND `partno` = '228CDVARAFDBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449678 [ RunTime:0.001737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925284 LIMIT 4 [ RunTime:0.001798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925284 ORDER BY `minOrder` ASC [ RunTime:0.005982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925284 ORDER BY `unit` DESC [ RunTime:0.002363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925284 LIMIT 2 [ RunTime:0.006804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925284 ORDER BY `minOrder` ASC [ RunTime:0.005332s ]
select * from pdf where partno='228CDVAGFABBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFABBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011379s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925284 AND `partno` = '228CDVAGFABBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449677 [ RunTime:0.016367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925283 LIMIT 4 [ RunTime:0.005417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925283 ORDER BY `minOrder` ASC [ RunTime:0.019719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925283 ORDER BY `unit` DESC [ RunTime:0.003638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925283 LIMIT 2 [ RunTime:0.003513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925283 ORDER BY `minOrder` ASC [ RunTime:0.002360s ]
select * from pdf where partno='228CDVARAFFMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARAFFMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007713s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925283 AND `partno` = '228CDVARAFFMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449676 [ RunTime:0.003479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925282 LIMIT 4 [ RunTime:0.006595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925282 ORDER BY `minOrder` ASC [ RunTime:0.004646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925282 ORDER BY `unit` DESC [ RunTime:0.003703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925282 LIMIT 2 [ RunTime:0.004141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925282 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
select * from pdf where partno='228CDVARGBFDMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFDMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018296s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925282 AND `partno` = '228CDVARGBFDMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449675 [ RunTime:0.001295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925281 LIMIT 4 [ RunTime:0.004967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925281 ORDER BY `minOrder` ASC [ RunTime:0.001193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925281 ORDER BY `unit` DESC [ RunTime:0.004197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925281 LIMIT 2 [ RunTime:0.006847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925281 ORDER BY `minOrder` ASC [ RunTime:0.004962s ]
select * from pdf where partno='228CDVARBFAMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARBFAMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004755s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925281 AND `partno` = '228CDVARBFAMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925280 LIMIT 4 [ RunTime:0.005168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925280 ORDER BY `minOrder` ASC [ RunTime:0.009397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925280 ORDER BY `unit` DESC [ RunTime:0.007927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925280 LIMIT 2 [ RunTime:0.002888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925280 ORDER BY `minOrder` ASC [ RunTime:0.002534s ]
select * from pdf where partno='228CDVAGFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006985s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925280 AND `partno` = '228CDVAGFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449674 [ RunTime:0.013398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925279 LIMIT 4 [ RunTime:0.010396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925279 ORDER BY `minOrder` ASC [ RunTime:0.013551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925279 ORDER BY `unit` DESC [ RunTime:0.000867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925279 LIMIT 2 [ RunTime:0.004196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925279 ORDER BY `minOrder` ASC [ RunTime:0.001998s ]
select * from pdf where partno='228CDVAYFERA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFERA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003912s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925279 AND `partno` = '228CDVAYFERA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449673 [ RunTime:0.006900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925278 LIMIT 4 [ RunTime:0.002608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925278 ORDER BY `minOrder` ASC [ RunTime:0.014040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925278 ORDER BY `unit` DESC [ RunTime:0.012338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925278 LIMIT 2 [ RunTime:0.006645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925278 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='228CDVAYFFAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021940s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925278 AND `partno` = '228CDVAYFFAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449672 [ RunTime:0.011541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925277 LIMIT 4 [ RunTime:0.009596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925277 ORDER BY `minOrder` ASC [ RunTime:0.017924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925277 ORDER BY `unit` DESC [ RunTime:0.004583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925277 LIMIT 2 [ RunTime:0.009756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925277 ORDER BY `minOrder` ASC [ RunTime:0.003351s ]
select * from pdf where partno='228CDVARGFFWD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFWD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004309s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925277 AND `partno` = '228CDVARGFFWD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449671 [ RunTime:0.010184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925276 LIMIT 4 [ RunTime:0.001831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925276 ORDER BY `minOrder` ASC [ RunTime:0.012250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925276 ORDER BY `unit` DESC [ RunTime:0.003122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925276 LIMIT 2 [ RunTime:0.001960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925276 ORDER BY `minOrder` ASC [ RunTime:0.004664s ]
select * from pdf where partno='228CDVAGFAAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFAAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007417s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925276 AND `partno` = '228CDVAGFAAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366406 [ RunTime:0.004732s ]
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.114363s ]