SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001253s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=5KP85C&search=1' [ RunTime:0.006447s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002536s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000580s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001247s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001848s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005882s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001301s ]
SELECT * FROM `stock_search` WHERE `partno` = '5KP85C' LIMIT 1 [ RunTime:0.005206s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-17 11:17:51' WHERE `partno` = '5KP85C' [ RunTime:0.003992s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002598s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006915s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914214 LIMIT 5 [ RunTime:0.000768s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914214 ORDER BY `minOrder` ASC [ RunTime:0.006510s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914214 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914214 LIMIT 2 [ RunTime:0.006420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914214 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664989 LIMIT 5 [ RunTime:0.003533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664989 ORDER BY `minOrder` ASC [ RunTime:0.006250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664989 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664989 LIMIT 2 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664989 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800266 LIMIT 5 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800266 ORDER BY `minOrder` ASC [ RunTime:0.004100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800266 ORDER BY `unit` DESC [ RunTime:0.002351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800266 LIMIT 2 [ RunTime:0.001583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800266 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681204 LIMIT 5 [ RunTime:0.005801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681204 ORDER BY `minOrder` ASC [ RunTime:0.011423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681204 ORDER BY `unit` DESC [ RunTime:0.007028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681204 LIMIT 2 [ RunTime:0.005485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681204 ORDER BY `minOrder` ASC [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681132 LIMIT 5 [ RunTime:0.001830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681132 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681132 ORDER BY `unit` DESC [ RunTime:0.011257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681132 LIMIT 2 [ RunTime:0.039022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681132 ORDER BY `minOrder` ASC [ RunTime:0.008662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678711 LIMIT 5 [ RunTime:0.005716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678711 ORDER BY `minOrder` ASC [ RunTime:0.001594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678711 ORDER BY `unit` DESC [ RunTime:0.005149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678711 LIMIT 2 [ RunTime:0.022297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678711 ORDER BY `minOrder` ASC [ RunTime:0.002419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678470 LIMIT 5 [ RunTime:0.011662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678470 ORDER BY `minOrder` ASC [ RunTime:0.007185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678470 ORDER BY `unit` DESC [ RunTime:0.014871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678470 LIMIT 2 [ RunTime:0.011455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678470 ORDER BY `minOrder` ASC [ RunTime:0.003013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830157 LIMIT 5 [ RunTime:0.003913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830157 ORDER BY `minOrder` ASC [ RunTime:0.016127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830157 ORDER BY `unit` DESC [ RunTime:0.031635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830157 LIMIT 2 [ RunTime:0.010905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830157 ORDER BY `minOrder` ASC [ RunTime:0.010874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827220 LIMIT 5 [ RunTime:0.005369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827220 ORDER BY `minOrder` ASC [ RunTime:0.010586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827220 ORDER BY `unit` DESC [ RunTime:0.004739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827220 LIMIT 2 [ RunTime:0.003449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827220 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823926 LIMIT 5 [ RunTime:0.002103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823926 ORDER BY `minOrder` ASC [ RunTime:0.043269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823926 ORDER BY `unit` DESC [ RunTime:0.022534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823926 LIMIT 2 [ RunTime:0.014045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823926 ORDER BY `minOrder` ASC [ RunTime:0.004972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820927 LIMIT 5 [ RunTime:0.012386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820927 ORDER BY `minOrder` ASC [ RunTime:0.001731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820927 ORDER BY `unit` DESC [ RunTime:0.004327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820927 LIMIT 2 [ RunTime:0.008343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820927 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820066 LIMIT 5 [ RunTime:0.010356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820066 ORDER BY `minOrder` ASC [ RunTime:0.007478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820066 ORDER BY `unit` DESC [ RunTime:0.014018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820066 LIMIT 2 [ RunTime:0.007025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820066 ORDER BY `minOrder` ASC [ RunTime:0.011449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819856 LIMIT 5 [ RunTime:0.003898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819856 ORDER BY `minOrder` ASC [ RunTime:0.016143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819856 ORDER BY `unit` DESC [ RunTime:0.002477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819856 LIMIT 2 [ RunTime:0.001435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819856 ORDER BY `minOrder` ASC [ RunTime:0.013059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924848 LIMIT 5 [ RunTime:0.006495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924848 ORDER BY `minOrder` ASC [ RunTime:0.011777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924848 ORDER BY `unit` DESC [ RunTime:0.007944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924848 LIMIT 2 [ RunTime:0.008985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924848 ORDER BY `minOrder` ASC [ RunTime:0.003979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921815 LIMIT 5 [ RunTime:0.001097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921815 ORDER BY `minOrder` ASC [ RunTime:0.010755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921815 ORDER BY `unit` DESC [ RunTime:0.020968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921815 LIMIT 2 [ RunTime:0.004141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921815 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004653s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170773 LIMIT 5 [ RunTime:0.004812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170773 ORDER BY `minOrder` ASC [ RunTime:0.012756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170773 ORDER BY `unit` DESC [ RunTime:0.014507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170773 LIMIT 2 [ RunTime:0.020817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170773 ORDER BY `minOrder` ASC [ RunTime:0.004473s ]
select * from pdf where partno='5KP85CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.020712s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.008285s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170773 AND `partno` = '5KP85CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.006690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664989 [ RunTime:0.007378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156868 LIMIT 5 [ RunTime:0.008353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156868 ORDER BY `minOrder` ASC [ RunTime:0.001663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156868 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156868 LIMIT 2 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156868 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='5KP85CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.002020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002959s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156868 AND `partno` = '5KP85CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.003280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800266 [ RunTime:0.004162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42108989 LIMIT 5 [ RunTime:0.015419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108989 ORDER BY `minOrder` ASC [ RunTime:0.010835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42108989 ORDER BY `unit` DESC [ RunTime:0.009713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42108989 LIMIT 2 [ RunTime:0.014839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108989 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
select * from pdf where partno='5KP85CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.018171s ]
SELECT `id` FROM `stock` WHERE `id` <> 42108989 AND `partno` = '5KP85CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914214 [ RunTime:0.026740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414786 LIMIT 5 [ RunTime:0.034320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414786 ORDER BY `minOrder` ASC [ RunTime:0.004303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414786 ORDER BY `unit` DESC [ RunTime:0.002730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414786 LIMIT 2 [ RunTime:0.009486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414786 ORDER BY `minOrder` ASC [ RunTime:0.010141s ]
select * from pdf where partno='5KP85CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007812s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414786 AND `partno` = '5KP85CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.007731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823926 [ RunTime:0.006090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42412409 LIMIT 5 [ RunTime:0.017545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412409 ORDER BY `minOrder` ASC [ RunTime:0.003713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42412409 ORDER BY `unit` DESC [ RunTime:0.001950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42412409 LIMIT 2 [ RunTime:0.005209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412409 ORDER BY `minOrder` ASC [ RunTime:0.002175s ]
select * from pdf where partno='5KP85CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007049s ]
SELECT `id` FROM `stock` WHERE `id` <> 42412409 AND `partno` = '5KP85CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924848 [ RunTime:0.003736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42318632 LIMIT 5 [ RunTime:0.013233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318632 ORDER BY `minOrder` ASC [ RunTime:0.008160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42318632 ORDER BY `unit` DESC [ RunTime:0.002075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42318632 LIMIT 2 [ RunTime:0.004386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318632 ORDER BY `minOrder` ASC [ RunTime:0.002318s ]
select * from pdf where partno='5KP85CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.008089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.008716s ]
SELECT `id` FROM `stock` WHERE `id` <> 42318632 AND `partno` = '5KP85CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820927 [ RunTime:0.013381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42314338 LIMIT 5 [ RunTime:0.009675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42314338 ORDER BY `minOrder` ASC [ RunTime:0.037447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42314338 ORDER BY `unit` DESC [ RunTime:0.016115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42314338 LIMIT 2 [ RunTime:0.009629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42314338 ORDER BY `minOrder` ASC [ RunTime:0.008248s ]
select * from pdf where partno='5KP85CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.034981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008438s ]
SELECT `id` FROM `stock` WHERE `id` <> 42314338 AND `partno` = '5KP85CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.016305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681204 [ RunTime:0.028229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42299717 LIMIT 5 [ RunTime:0.019136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299717 ORDER BY `minOrder` ASC [ RunTime:0.012619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42299717 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42299717 LIMIT 2 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299717 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='5KP85CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.008801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.016922s ]
SELECT `id` FROM `stock` WHERE `id` <> 42299717 AND `partno` = '5KP85CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.009383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921815 [ RunTime:0.001346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297892 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297892 ORDER BY `minOrder` ASC [ RunTime:0.008698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297892 ORDER BY `unit` DESC [ RunTime:0.000789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297892 LIMIT 2 [ RunTime:0.001510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297892 ORDER BY `minOrder` ASC [ RunTime:0.001326s ]
select * from pdf where partno='5KP85CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297836 LIMIT 5 [ RunTime:0.001713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297836 ORDER BY `minOrder` ASC [ RunTime:0.011149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297836 ORDER BY `unit` DESC [ RunTime:0.013438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297836 LIMIT 2 [ RunTime:0.006003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297836 ORDER BY `minOrder` ASC [ RunTime:0.005646s ]
select * from pdf where partno='5KP85CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.007253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.021306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295793 LIMIT 5 [ RunTime:0.011173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295793 ORDER BY `minOrder` ASC [ RunTime:0.009942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295793 ORDER BY `unit` DESC [ RunTime:0.006678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295793 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295793 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='5KP85CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.018277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295788 LIMIT 5 [ RunTime:0.002216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295788 ORDER BY `minOrder` ASC [ RunTime:0.012767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295788 ORDER BY `unit` DESC [ RunTime:0.011118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295788 LIMIT 2 [ RunTime:0.014397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295788 ORDER BY `minOrder` ASC [ RunTime:0.002187s ]
select * from pdf where partno='5KP85CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.015349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.028420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42293069 LIMIT 5 [ RunTime:0.011398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293069 ORDER BY `minOrder` ASC [ RunTime:0.006986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42293069 ORDER BY `unit` DESC [ RunTime:0.006186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42293069 LIMIT 2 [ RunTime:0.022121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293069 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='5KP85CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP85CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000333s ]
SELECT `id` FROM `stock` WHERE `id` <> 42293069 AND `partno` = '5KP85CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681132 [ RunTime:0.000291s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003295s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008866s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001826s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008258s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005557s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006043s ]
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 '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015356s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5KP85C%' OR `brand` LIKE '5KP85C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015669s ]