SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001837s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.95' , `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=5KP64A&search=1' [ RunTime:0.009545s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001666s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000658s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001475s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.95' ) [ RunTime:0.005439s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001085s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004048s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001636s ]
SELECT * FROM `stock_search` WHERE `partno` = '5KP64A' LIMIT 1 [ RunTime:0.010763s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-18 23:08:15' WHERE `partno` = '5KP64A' [ RunTime:0.012272s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003072s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037456s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683106 LIMIT 5 [ RunTime:0.027087s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683106 ORDER BY `minOrder` ASC [ RunTime:0.047109s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.023402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683106 ORDER BY `unit` DESC [ RunTime:0.027862s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683106 LIMIT 2 [ RunTime:0.011838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683106 ORDER BY `minOrder` ASC [ RunTime:0.026851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800228 LIMIT 5 [ RunTime:0.018326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800228 ORDER BY `minOrder` ASC [ RunTime:0.019787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800228 ORDER BY `unit` DESC [ RunTime:0.012651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800228 LIMIT 2 [ RunTime:0.034284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800228 ORDER BY `minOrder` ASC [ RunTime:0.004752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660841 LIMIT 5 [ RunTime:0.026178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660841 ORDER BY `minOrder` ASC [ RunTime:0.017602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16660841 ORDER BY `unit` DESC [ RunTime:0.034126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16660841 LIMIT 2 [ RunTime:0.028014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660841 ORDER BY `minOrder` ASC [ RunTime:0.005003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799358 LIMIT 5 [ RunTime:0.015299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799358 ORDER BY `minOrder` ASC [ RunTime:0.012571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799358 ORDER BY `unit` DESC [ RunTime:0.015465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799358 LIMIT 2 [ RunTime:0.027772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799358 ORDER BY `minOrder` ASC [ RunTime:0.007055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799316 LIMIT 5 [ RunTime:0.015512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799316 ORDER BY `minOrder` ASC [ RunTime:0.019397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799316 ORDER BY `unit` DESC [ RunTime:0.010978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799316 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799316 ORDER BY `minOrder` ASC [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833391 LIMIT 5 [ RunTime:0.007719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833391 ORDER BY `minOrder` ASC [ RunTime:0.014807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833391 ORDER BY `unit` DESC [ RunTime:0.011126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833391 LIMIT 2 [ RunTime:0.004667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833391 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823922 LIMIT 5 [ RunTime:0.012934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823922 ORDER BY `minOrder` ASC [ RunTime:0.006789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823922 ORDER BY `unit` DESC [ RunTime:0.010608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823922 LIMIT 2 [ RunTime:0.003431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823922 ORDER BY `minOrder` ASC [ RunTime:0.010900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821525 LIMIT 5 [ RunTime:0.003555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821525 ORDER BY `minOrder` ASC [ RunTime:0.008213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821525 ORDER BY `unit` DESC [ RunTime:0.006381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821525 LIMIT 2 [ RunTime:0.010261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821525 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820529 LIMIT 5 [ RunTime:0.006389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820529 ORDER BY `minOrder` ASC [ RunTime:0.008817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820529 ORDER BY `unit` DESC [ RunTime:0.003267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820529 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820529 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820365 LIMIT 5 [ RunTime:0.004718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820365 ORDER BY `minOrder` ASC [ RunTime:0.011936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820365 ORDER BY `unit` DESC [ RunTime:0.004883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820365 LIMIT 2 [ RunTime:0.017506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820365 ORDER BY `minOrder` ASC [ RunTime:0.007920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819854 LIMIT 5 [ RunTime:0.011022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819854 ORDER BY `minOrder` ASC [ RunTime:0.010845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819854 ORDER BY `unit` DESC [ RunTime:0.001417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819854 LIMIT 2 [ RunTime:0.022745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819854 ORDER BY `minOrder` ASC [ RunTime:0.016065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931152 LIMIT 5 [ RunTime:0.004135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931152 ORDER BY `minOrder` ASC [ RunTime:0.018648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931152 ORDER BY `unit` DESC [ RunTime:0.031117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931152 LIMIT 2 [ RunTime:0.013334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931152 ORDER BY `minOrder` ASC [ RunTime:0.006737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924846 LIMIT 5 [ RunTime:0.009580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924846 ORDER BY `minOrder` ASC [ RunTime:0.010646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924846 ORDER BY `unit` DESC [ RunTime:0.004219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924846 LIMIT 2 [ RunTime:0.004037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924846 ORDER BY `minOrder` ASC [ RunTime:0.000990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922331 LIMIT 5 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922331 ORDER BY `minOrder` ASC [ RunTime:0.008588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922331 ORDER BY `unit` DESC [ RunTime:0.021189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922331 LIMIT 2 [ RunTime:0.009201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922331 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921810 LIMIT 5 [ RunTime:0.005203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921810 ORDER BY `minOrder` ASC [ RunTime:0.022469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921810 ORDER BY `unit` DESC [ RunTime:0.009430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921810 LIMIT 2 [ RunTime:0.006768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921810 ORDER BY `minOrder` ASC [ RunTime:0.031370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921527 LIMIT 5 [ RunTime:0.011621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921527 ORDER BY `minOrder` ASC [ RunTime:0.008979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921527 ORDER BY `unit` DESC [ RunTime:0.006622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921527 LIMIT 2 [ RunTime:0.006913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921527 ORDER BY `minOrder` ASC [ RunTime:0.005556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920879 LIMIT 5 [ RunTime:0.010938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920879 ORDER BY `minOrder` ASC [ RunTime:0.007473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920879 ORDER BY `unit` DESC [ RunTime:0.008638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920879 LIMIT 2 [ RunTime:0.013474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920879 ORDER BY `minOrder` ASC [ RunTime:0.015078s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014691s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122254 LIMIT 5 [ RunTime:0.011812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122254 ORDER BY `minOrder` ASC [ RunTime:0.013426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122254 ORDER BY `unit` DESC [ RunTime:0.017352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122254 LIMIT 2 [ RunTime:0.046041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122254 ORDER BY `minOrder` ASC [ RunTime:0.017273s ]
select * from pdf where partno='5KP64A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.017620s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.020533s ]
SELECT `id` FROM `stock` WHERE `id` <> 42122254 AND `partno` = '5KP64A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.051389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683106 [ RunTime:0.028386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156621 LIMIT 5 [ RunTime:0.020287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156621 ORDER BY `minOrder` ASC [ RunTime:0.012847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156621 ORDER BY `unit` DESC [ RunTime:0.019111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156621 LIMIT 2 [ RunTime:0.007290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156621 ORDER BY `minOrder` ASC [ RunTime:0.008589s ]
select * from pdf where partno='5KP64A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.005311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.008206s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156621 AND `partno` = '5KP64A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.018956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800228 [ RunTime:0.006887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136874 LIMIT 5 [ RunTime:0.010524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136874 ORDER BY `minOrder` ASC [ RunTime:0.021492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136874 ORDER BY `unit` DESC [ RunTime:0.015041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136874 LIMIT 2 [ RunTime:0.002445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136874 ORDER BY `minOrder` ASC [ RunTime:0.021337s ]
select * from pdf where partno='5KP64A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.016821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.008401s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136874 AND `partno` = '5KP64A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.007564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799358 [ RunTime:0.016692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136902 LIMIT 5 [ RunTime:0.019557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136902 ORDER BY `minOrder` ASC [ RunTime:0.026338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136902 ORDER BY `unit` DESC [ RunTime:0.007170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136902 LIMIT 2 [ RunTime:0.005179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136902 ORDER BY `minOrder` ASC [ RunTime:0.010439s ]
select * from pdf where partno='5KP64A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005384s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136902 AND `partno` = '5KP64A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.024176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660841 [ RunTime:0.013285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170746 LIMIT 5 [ RunTime:0.017944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170746 ORDER BY `minOrder` ASC [ RunTime:0.005491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170746 ORDER BY `unit` DESC [ RunTime:0.006046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170746 LIMIT 2 [ RunTime:0.009581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170746 ORDER BY `minOrder` ASC [ RunTime:0.018746s ]
select * from pdf where partno='5KP64A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.030386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414777 LIMIT 5 [ RunTime:0.008100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414777 ORDER BY `minOrder` ASC [ RunTime:0.019724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414777 ORDER BY `unit` DESC [ RunTime:0.010231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414777 LIMIT 2 [ RunTime:0.007123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414777 ORDER BY `minOrder` ASC [ RunTime:0.001749s ]
select * from pdf where partno='5KP64A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.014813s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414777 AND `partno` = '5KP64A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823922 [ RunTime:0.012759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42412400 LIMIT 5 [ RunTime:0.003946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412400 ORDER BY `minOrder` ASC [ RunTime:0.009538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42412400 ORDER BY `unit` DESC [ RunTime:0.039015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42412400 LIMIT 2 [ RunTime:0.025985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412400 ORDER BY `minOrder` ASC [ RunTime:0.014979s ]
select * from pdf where partno='5KP64A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.002914s ]
SELECT `id` FROM `stock` WHERE `id` <> 42412400 AND `partno` = '5KP64A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.015183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924846 [ RunTime:0.025199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42323365 LIMIT 5 [ RunTime:0.021334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323365 ORDER BY `minOrder` ASC [ RunTime:0.018327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42323365 ORDER BY `unit` DESC [ RunTime:0.032614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42323365 LIMIT 2 [ RunTime:0.042755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323365 ORDER BY `minOrder` ASC [ RunTime:0.012422s ]
select * from pdf where partno='5KP64A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.043313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014467s ]
SELECT `id` FROM `stock` WHERE `id` <> 42323365 AND `partno` = '5KP64A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42323319 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323319 ORDER BY `minOrder` ASC [ RunTime:0.004805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42323319 ORDER BY `unit` DESC [ RunTime:0.025493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42323319 LIMIT 2 [ RunTime:0.044489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323319 ORDER BY `minOrder` ASC [ RunTime:0.018431s ]
select * from pdf where partno='5KP64AHE3_A/C' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64AHE3_A/C' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.026087s ]
SELECT `id` FROM `stock` WHERE `id` <> 42323319 AND `partno` = '5KP64AHE3_A/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.089419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820365 [ RunTime:0.050820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42317038 LIMIT 5 [ RunTime:0.054068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42317038 ORDER BY `minOrder` ASC [ RunTime:0.051698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42317038 ORDER BY `unit` DESC [ RunTime:0.009164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42317038 LIMIT 2 [ RunTime:0.043085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42317038 ORDER BY `minOrder` ASC [ RunTime:0.020530s ]
select * from pdf where partno='5KP64AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.013786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.030197s ]
SELECT `id` FROM `stock` WHERE `id` <> 42317038 AND `partno` = '5KP64AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.009641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922331 [ RunTime:0.007233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42301280 LIMIT 5 [ RunTime:0.032505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42301280 ORDER BY `minOrder` ASC [ RunTime:0.011471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42301280 ORDER BY `unit` DESC [ RunTime:0.017077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42301280 LIMIT 2 [ RunTime:0.035512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42301280 ORDER BY `minOrder` ASC [ RunTime:0.021100s ]
select * from pdf where partno='5KP64A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.012852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.024317s ]
SELECT `id` FROM `stock` WHERE `id` <> 42301280 AND `partno` = '5KP64A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.007794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820529 [ RunTime:0.008054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42299700 LIMIT 5 [ RunTime:0.011436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299700 ORDER BY `minOrder` ASC [ RunTime:0.012215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42299700 ORDER BY `unit` DESC [ RunTime:0.012406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42299700 LIMIT 2 [ RunTime:0.013517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299700 ORDER BY `minOrder` ASC [ RunTime:0.018352s ]
select * from pdf where partno='5KP64A-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.009359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.006567s ]
SELECT `id` FROM `stock` WHERE `id` <> 42299700 AND `partno` = '5KP64A-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.010954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921810 [ RunTime:0.004574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297867 LIMIT 5 [ RunTime:0.006605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297867 ORDER BY `minOrder` ASC [ RunTime:0.010692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297867 ORDER BY `unit` DESC [ RunTime:0.015726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297867 LIMIT 2 [ RunTime:0.011715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297867 ORDER BY `minOrder` ASC [ RunTime:0.004245s ]
select * from pdf where partno='5KP64A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.018233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.026401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297847 LIMIT 5 [ RunTime:0.015292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297847 ORDER BY `minOrder` ASC [ RunTime:0.012295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297847 ORDER BY `unit` DESC [ RunTime:0.003328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297847 LIMIT 2 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297847 ORDER BY `minOrder` ASC [ RunTime:0.003706s ]
select * from pdf where partno='5KP64A-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.012607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.018468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295800 LIMIT 5 [ RunTime:0.012516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295800 ORDER BY `minOrder` ASC [ RunTime:0.021209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295800 ORDER BY `unit` DESC [ RunTime:0.001340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295800 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295800 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
select * from pdf where partno='5KP64A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295645 LIMIT 5 [ RunTime:0.002213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295645 ORDER BY `minOrder` ASC [ RunTime:0.004236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295645 ORDER BY `unit` DESC [ RunTime:0.005588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295645 LIMIT 2 [ RunTime:0.001194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295645 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='5KP64A_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP64A_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001127s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295645 AND `partno` = '5KP64A_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821525 [ RunTime:0.005533s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003894s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016056s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012243s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006914s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003188s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014169s ]
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 '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006419s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5KP64A%' OR `brand` LIKE '5KP64A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005984s ]