SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003450s ]
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://ic118.com/stock&keyword=5KP18A&page=1&srecordnum=37' [ RunTime:0.001813s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002006s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002316s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000480s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002256s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000756s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002171s ]
SELECT * FROM `stock_search` WHERE `partno` = '5KP18A' LIMIT 1 [ RunTime:0.000711s ]
UPDATE `stock_search` SET `count` = 16680 , `updatetime` = '2026-06-11 21:21:46' WHERE `partno` = '5KP18A' [ RunTime:0.002176s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000323s ]
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.000637s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002400s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '5KP18A%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.005017s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '5KP18A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003008s ]
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 ('13914206','42108931','42108993','16661967','42144881','14823302','42143898','42136365','16683091','16863','15844','14803398','3432','42414643','42411271','42323357','42323323','42317002','42301263','42299459') ORDER BY FIELD(s.id, 13914206,42108931,42108993,16661967,42144881,14823302,42143898,42136365,16683091,16863,15844,14803398,3432,42414643,42411271,42323357,42323323,42317002,42301263,42299459) [ RunTime:0.007418s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914206 LIMIT 4 [ RunTime:0.001084s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914206 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914206 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914206 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914206 ORDER BY `minOrder` ASC [ RunTime:0.001963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42108931 LIMIT 4 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108931 ORDER BY `minOrder` ASC [ RunTime:0.002504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42108931 ORDER BY `unit` DESC [ RunTime:0.000961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42108931 LIMIT 2 [ RunTime:0.002469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108931 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='5KP18A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007845s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003667s ]
SELECT `id` FROM `stock` WHERE `id` <> 42108931 AND `partno` = '5KP18A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823302 [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42108993 LIMIT 4 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108993 ORDER BY `minOrder` ASC [ RunTime:0.004126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42108993 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42108993 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108993 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
select * from pdf where partno='5KP18A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003535s ]
SELECT `id` FROM `stock` WHERE `id` <> 42108993 AND `partno` = '5KP18A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914206 [ RunTime:0.001748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661967 LIMIT 4 [ RunTime:0.003611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661967 ORDER BY `minOrder` ASC [ RunTime:0.002598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661967 ORDER BY `unit` DESC [ RunTime:0.002882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661967 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661967 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42144881 LIMIT 4 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42144881 ORDER BY `minOrder` ASC [ RunTime:0.000859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42144881 ORDER BY `unit` DESC [ RunTime:0.003692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42144881 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42144881 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
select * from pdf where partno='5KP18A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.008082s ]
SELECT `id` FROM `stock` WHERE `id` <> 42144881 AND `partno` = '5KP18A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661967 [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823302 LIMIT 4 [ RunTime:0.001270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823302 ORDER BY `minOrder` ASC [ RunTime:0.004384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823302 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823302 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823302 ORDER BY `minOrder` ASC [ RunTime:0.000206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143898 LIMIT 4 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143898 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143898 ORDER BY `unit` DESC [ RunTime:0.001247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143898 LIMIT 2 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143898 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
select * from pdf where partno='5KP18A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.000598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.005452s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143898 AND `partno` = '5KP18A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.001034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803398 [ RunTime:0.000938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136365 LIMIT 4 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136365 ORDER BY `minOrder` ASC [ RunTime:0.002794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136365 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136365 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136365 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
select * from pdf where partno='5KP18A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.001682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683091 LIMIT 4 [ RunTime:0.001735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683091 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683091 ORDER BY `unit` DESC [ RunTime:0.002677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683091 LIMIT 2 [ RunTime:0.003030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683091 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16863 LIMIT 4 [ RunTime:0.004784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16863 ORDER BY `minOrder` ASC [ RunTime:0.001958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16863 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16863 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16863 ORDER BY `minOrder` ASC [ RunTime:0.001622s ]
select * from pdf where partno='5KP18A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.003435s ]
select foldpath,foldpath2,filename from pdf_file where id=854533 limit 1 [ RunTime:0.008775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.021810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15844 LIMIT 4 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15844 ORDER BY `minOrder` ASC [ RunTime:0.004969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15844 ORDER BY `unit` DESC [ RunTime:0.003026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15844 LIMIT 2 [ RunTime:0.003121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15844 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='5KP18A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.000456s ]
select foldpath,foldpath2,filename from pdf_file where id=854533 limit 1 [ RunTime:0.000314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803398 LIMIT 4 [ RunTime:0.001497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803398 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803398 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803398 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803398 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3432 LIMIT 4 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3432 ORDER BY `minOrder` ASC [ RunTime:0.021748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3432 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3432 LIMIT 2 [ RunTime:0.002456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3432 ORDER BY `minOrder` ASC [ RunTime:0.006171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.000727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414643 LIMIT 4 [ RunTime:0.002487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414643 ORDER BY `minOrder` ASC [ RunTime:0.003634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414643 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414643 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414643 ORDER BY `minOrder` ASC [ RunTime:0.001887s ]
select * from pdf where partno='5KP18A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003318s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414643 AND `partno` = '5KP18A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823910 [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42411271 LIMIT 4 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411271 ORDER BY `minOrder` ASC [ RunTime:0.007342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42411271 ORDER BY `unit` DESC [ RunTime:0.002427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42411271 LIMIT 2 [ RunTime:0.002361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411271 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='5KP18A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000836s ]
SELECT `id` FROM `stock` WHERE `id` <> 42411271 AND `partno` = '5KP18A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683490 [ RunTime:0.007255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42323357 LIMIT 4 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323357 ORDER BY `minOrder` ASC [ RunTime:0.006737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42323357 ORDER BY `unit` DESC [ RunTime:0.003617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42323357 LIMIT 2 [ RunTime:0.004358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323357 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='5KP18A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002260s ]
SELECT `id` FROM `stock` WHERE `id` <> 42323357 AND `partno` = '5KP18A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928933 [ RunTime:0.002395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42323323 LIMIT 4 [ RunTime:0.003391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323323 ORDER BY `minOrder` ASC [ RunTime:0.003420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42323323 ORDER BY `unit` DESC [ RunTime:0.000810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42323323 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323323 ORDER BY `minOrder` ASC [ RunTime:0.002142s ]
select * from pdf where partno='5KP18AHE3_A/C' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18AHE3_A/C' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000823s ]
SELECT `id` FROM `stock` WHERE `id` <> 42323323 AND `partno` = '5KP18AHE3_A/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921856 [ RunTime:0.001287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42317002 LIMIT 4 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42317002 ORDER BY `minOrder` ASC [ RunTime:0.006435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42317002 ORDER BY `unit` DESC [ RunTime:0.002786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42317002 LIMIT 2 [ RunTime:0.005419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42317002 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
select * from pdf where partno='5KP18AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.005687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.001138s ]
SELECT `id` FROM `stock` WHERE `id` <> 42317002 AND `partno` = '5KP18AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680200 [ RunTime:0.003123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42301263 LIMIT 4 [ RunTime:0.001248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42301263 ORDER BY `minOrder` ASC [ RunTime:0.001526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42301263 ORDER BY `unit` DESC [ RunTime:0.008502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42301263 LIMIT 2 [ RunTime:0.002402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42301263 ORDER BY `minOrder` ASC [ RunTime:0.005764s ]
select * from pdf where partno='5KP18A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001767s ]
SELECT `id` FROM `stock` WHERE `id` <> 42301263 AND `partno` = '5KP18A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922025 [ RunTime:0.010557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42299459 LIMIT 4 [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299459 ORDER BY `minOrder` ASC [ RunTime:0.002733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42299459 ORDER BY `unit` DESC [ RunTime:0.003516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42299459 LIMIT 2 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299459 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='5KP18A-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.001437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP18A-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.003726s ]
SELECT `id` FROM `stock` WHERE `id` <> 42299459 AND `partno` = '5KP18A-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.001509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679540 [ RunTime:0.001323s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '5KP18A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001718s ]