SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001799s ]
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=5KP110A&search=1' [ RunTime:0.014341s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001744s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.037710s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001768s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.053249s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004214s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.026468s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002217s ]
SELECT * FROM `stock_search` WHERE `partno` = '5KP110A' LIMIT 1 [ RunTime:0.072979s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-17 11:19:28' WHERE `partno` = '5KP110A' [ RunTime:0.056391s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001541s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023557s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682663 LIMIT 5 [ RunTime:0.066702s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.020085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682663 ORDER BY `minOrder` ASC [ RunTime:0.018294s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16682663 ORDER BY `unit` DESC [ RunTime:0.091321s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16682663 LIMIT 2 [ RunTime:0.066305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682663 ORDER BY `minOrder` ASC [ RunTime:0.036578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803400 LIMIT 5 [ RunTime:0.010101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803400 ORDER BY `minOrder` ASC [ RunTime:0.047216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803400 ORDER BY `unit` DESC [ RunTime:0.062157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803400 LIMIT 2 [ RunTime:0.036533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803400 ORDER BY `minOrder` ASC [ RunTime:0.037518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692753 LIMIT 5 [ RunTime:0.010401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692753 ORDER BY `minOrder` ASC [ RunTime:0.007204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692753 ORDER BY `unit` DESC [ RunTime:0.027273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692753 LIMIT 2 [ RunTime:0.040606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692753 ORDER BY `minOrder` ASC [ RunTime:0.033405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688562 LIMIT 5 [ RunTime:0.067430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688562 ORDER BY `minOrder` ASC [ RunTime:0.008739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688562 ORDER BY `unit` DESC [ RunTime:0.014946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688562 LIMIT 2 [ RunTime:0.043837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688562 ORDER BY `minOrder` ASC [ RunTime:0.004650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679527 LIMIT 5 [ RunTime:0.009995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679527 ORDER BY `minOrder` ASC [ RunTime:0.009009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679527 ORDER BY `unit` DESC [ RunTime:0.021524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679527 LIMIT 2 [ RunTime:0.016350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679527 ORDER BY `minOrder` ASC [ RunTime:0.006122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831181 LIMIT 5 [ RunTime:0.017939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831181 ORDER BY `minOrder` ASC [ RunTime:0.024336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831181 ORDER BY `unit` DESC [ RunTime:0.003219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831181 LIMIT 2 [ RunTime:0.015077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831181 ORDER BY `minOrder` ASC [ RunTime:0.012929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823927 LIMIT 5 [ RunTime:0.016061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823927 ORDER BY `minOrder` ASC [ RunTime:0.012029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823927 ORDER BY `unit` DESC [ RunTime:0.001928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823927 LIMIT 2 [ RunTime:0.002088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823927 ORDER BY `minOrder` ASC [ RunTime:0.012628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821527 LIMIT 5 [ RunTime:0.006366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821527 ORDER BY `minOrder` ASC [ RunTime:0.006003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821527 ORDER BY `unit` DESC [ RunTime:0.010527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821527 LIMIT 2 [ RunTime:0.024734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821527 ORDER BY `minOrder` ASC [ RunTime:0.013670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820789 LIMIT 5 [ RunTime:0.030723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820789 ORDER BY `minOrder` ASC [ RunTime:0.014672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820789 ORDER BY `unit` DESC [ RunTime:0.010273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820789 LIMIT 2 [ RunTime:0.033126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820789 ORDER BY `minOrder` ASC [ RunTime:0.019894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819878 LIMIT 5 [ RunTime:0.041011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819878 ORDER BY `minOrder` ASC [ RunTime:0.007340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819878 ORDER BY `unit` DESC [ RunTime:0.011196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819878 LIMIT 2 [ RunTime:0.022221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819878 ORDER BY `minOrder` ASC [ RunTime:0.003683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819367 LIMIT 5 [ RunTime:0.003112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819367 ORDER BY `minOrder` ASC [ RunTime:0.005173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819367 ORDER BY `unit` DESC [ RunTime:0.001834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819367 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819367 ORDER BY `minOrder` ASC [ RunTime:0.004793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804138 LIMIT 5 [ RunTime:0.004743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804138 ORDER BY `minOrder` ASC [ RunTime:0.003862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14804138 ORDER BY `unit` DESC [ RunTime:0.001761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14804138 LIMIT 2 [ RunTime:0.015465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804138 ORDER BY `minOrder` ASC [ RunTime:0.013415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931136 LIMIT 5 [ RunTime:0.021010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931136 ORDER BY `minOrder` ASC [ RunTime:0.030747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931136 ORDER BY `unit` DESC [ RunTime:0.017073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931136 LIMIT 2 [ RunTime:0.042328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931136 ORDER BY `minOrder` ASC [ RunTime:0.018907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924850 LIMIT 5 [ RunTime:0.026930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924850 ORDER BY `minOrder` ASC [ RunTime:0.054352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924850 ORDER BY `unit` DESC [ RunTime:0.027142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924850 LIMIT 2 [ RunTime:0.028682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924850 ORDER BY `minOrder` ASC [ RunTime:0.003686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921851 LIMIT 5 [ RunTime:0.042588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921851 ORDER BY `minOrder` ASC [ RunTime:0.010652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921851 ORDER BY `unit` DESC [ RunTime:0.035243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921851 LIMIT 2 [ RunTime:0.021689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921851 ORDER BY `minOrder` ASC [ RunTime:0.012168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921582 LIMIT 5 [ RunTime:0.018655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921582 ORDER BY `minOrder` ASC [ RunTime:0.021049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921582 ORDER BY `unit` DESC [ RunTime:0.030799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921582 LIMIT 2 [ RunTime:0.024602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921582 ORDER BY `minOrder` ASC [ RunTime:0.009801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921098 LIMIT 5 [ RunTime:0.064931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921098 ORDER BY `minOrder` ASC [ RunTime:0.036754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921098 ORDER BY `unit` DESC [ RunTime:0.014466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921098 LIMIT 2 [ RunTime:0.008059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921098 ORDER BY `minOrder` ASC [ RunTime:0.011724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908947 LIMIT 5 [ RunTime:0.033197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908947 ORDER BY `minOrder` ASC [ RunTime:0.022908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908947 ORDER BY `unit` DESC [ RunTime:0.034431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908947 LIMIT 2 [ RunTime:0.032910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908947 ORDER BY `minOrder` ASC [ RunTime:0.009079s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027768s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42164355 LIMIT 5 [ RunTime:0.009369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164355 ORDER BY `minOrder` ASC [ RunTime:0.009612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42164355 ORDER BY `unit` DESC [ RunTime:0.020410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42164355 LIMIT 2 [ RunTime:0.004510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164355 ORDER BY `minOrder` ASC [ RunTime:0.009824s ]
select * from pdf where partno='5KP110A' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.011555s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.011663s ]
SELECT `id` FROM `stock` WHERE `id` <> 42164355 AND `partno` = '5KP110A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.032333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156620 LIMIT 5 [ RunTime:0.034908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156620 ORDER BY `minOrder` ASC [ RunTime:0.033741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156620 ORDER BY `unit` DESC [ RunTime:0.014719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156620 LIMIT 2 [ RunTime:0.022550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156620 ORDER BY `minOrder` ASC [ RunTime:0.018307s ]
select * from pdf where partno='5KP110A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.014931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.016503s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156620 AND `partno` = '5KP110A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.022133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803400 [ RunTime:0.004234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42108995 LIMIT 5 [ RunTime:0.038712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108995 ORDER BY `minOrder` ASC [ RunTime:0.025472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42108995 ORDER BY `unit` DESC [ RunTime:0.060282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42108995 LIMIT 2 [ RunTime:0.016140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108995 ORDER BY `minOrder` ASC [ RunTime:0.025512s ]
select * from pdf where partno='5KP110A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.054808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.038993s ]
SELECT `id` FROM `stock` WHERE `id` <> 42108995 AND `partno` = '5KP110A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.073305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804138 [ RunTime:0.092117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122268 LIMIT 5 [ RunTime:0.093148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122268 ORDER BY `minOrder` ASC [ RunTime:0.022440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122268 ORDER BY `unit` DESC [ RunTime:0.049504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122268 LIMIT 2 [ RunTime:0.013851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122268 ORDER BY `minOrder` ASC [ RunTime:0.013532s ]
select * from pdf where partno='5KP110A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.016523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.051766s ]
SELECT `id` FROM `stock` WHERE `id` <> 42122268 AND `partno` = '5KP110A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.030902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908947 [ RunTime:0.030654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122274 LIMIT 5 [ RunTime:0.047095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122274 ORDER BY `minOrder` ASC [ RunTime:0.055520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122274 ORDER BY `unit` DESC [ RunTime:0.028926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122274 LIMIT 2 [ RunTime:0.027138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122274 ORDER BY `minOrder` ASC [ RunTime:0.018016s ]
select * from pdf where partno='5KP110A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.041850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.039303s ]
SELECT `id` FROM `stock` WHERE `id` <> 42122274 AND `partno` = '5KP110A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.033623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682663 [ RunTime:0.023742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414791 LIMIT 5 [ RunTime:0.077451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414791 ORDER BY `minOrder` ASC [ RunTime:0.073229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414791 ORDER BY `unit` DESC [ RunTime:0.071453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414791 LIMIT 2 [ RunTime:0.031667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414791 ORDER BY `minOrder` ASC [ RunTime:0.013676s ]
select * from pdf where partno='5KP110A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.039128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.036369s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414791 AND `partno` = '5KP110A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.021329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823927 [ RunTime:0.040075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42412414 LIMIT 5 [ RunTime:0.034297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412414 ORDER BY `minOrder` ASC [ RunTime:0.032623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42412414 ORDER BY `unit` DESC [ RunTime:0.044501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42412414 LIMIT 2 [ RunTime:0.014017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412414 ORDER BY `minOrder` ASC [ RunTime:0.041651s ]
select * from pdf where partno='5KP110A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.086410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.020407s ]
SELECT `id` FROM `stock` WHERE `id` <> 42412414 AND `partno` = '5KP110A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.041421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924850 [ RunTime:0.093495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42323345 LIMIT 5 [ RunTime:0.034469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323345 ORDER BY `minOrder` ASC [ RunTime:0.103699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42323345 ORDER BY `unit` DESC [ RunTime:0.062005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42323345 LIMIT 2 [ RunTime:0.051484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323345 ORDER BY `minOrder` ASC [ RunTime:0.025902s ]
select * from pdf where partno='5KP110A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.058975s ]
SELECT `id` FROM `stock` WHERE `id` <> 42323345 AND `partno` = '5KP110A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42323314 LIMIT 5 [ RunTime:0.040421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323314 ORDER BY `minOrder` ASC [ RunTime:0.020098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42323314 ORDER BY `unit` DESC [ RunTime:0.016616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42323314 LIMIT 2 [ RunTime:0.049301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42323314 ORDER BY `minOrder` ASC [ RunTime:0.028058s ]
select * from pdf where partno='5KP110AHE3_A/C' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.047521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110AHE3_A/C' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.052132s ]
SELECT `id` FROM `stock` WHERE `id` <> 42323314 AND `partno` = '5KP110AHE3_A/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.107272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921851 [ RunTime:0.083655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42316776 LIMIT 5 [ RunTime:0.074621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42316776 ORDER BY `minOrder` ASC [ RunTime:0.064543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42316776 ORDER BY `unit` DESC [ RunTime:0.024832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42316776 LIMIT 2 [ RunTime:0.021091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42316776 ORDER BY `minOrder` ASC [ RunTime:0.036368s ]
select * from pdf where partno='5KP110AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.055131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.037450s ]
SELECT `id` FROM `stock` WHERE `id` <> 42316776 AND `partno` = '5KP110AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.017014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820789 [ RunTime:0.033592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42299431 LIMIT 5 [ RunTime:0.039348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299431 ORDER BY `minOrder` ASC [ RunTime:0.090226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42299431 ORDER BY `unit` DESC [ RunTime:0.053570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42299431 LIMIT 2 [ RunTime:0.044910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299431 ORDER BY `minOrder` ASC [ RunTime:0.018551s ]
select * from pdf where partno='5KP110A-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.080547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.096766s ]
SELECT `id` FROM `stock` WHERE `id` <> 42299431 AND `partno` = '5KP110A-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.056402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679527 [ RunTime:0.034445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42298402 LIMIT 5 [ RunTime:0.062092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298402 ORDER BY `minOrder` ASC [ RunTime:0.049959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42298402 ORDER BY `unit` DESC [ RunTime:0.042639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42298402 LIMIT 2 [ RunTime:0.130353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298402 ORDER BY `minOrder` ASC [ RunTime:0.089389s ]
select * from pdf where partno='5KP110A-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.067252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.200011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42298187 LIMIT 5 [ RunTime:0.119860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298187 ORDER BY `minOrder` ASC [ RunTime:0.076166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42298187 ORDER BY `unit` DESC [ RunTime:0.025508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42298187 LIMIT 2 [ RunTime:0.121204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298187 ORDER BY `minOrder` ASC [ RunTime:0.030706s ]
select * from pdf where partno='5KP110A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.214353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.079796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295931 LIMIT 5 [ RunTime:0.049723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295931 ORDER BY `minOrder` ASC [ RunTime:0.042458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295931 ORDER BY `unit` DESC [ RunTime:0.075861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295931 LIMIT 2 [ RunTime:0.010608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295931 ORDER BY `minOrder` ASC [ RunTime:0.015389s ]
select * from pdf where partno='5KP110A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.041307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.050738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295868 LIMIT 5 [ RunTime:0.049323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295868 ORDER BY `minOrder` ASC [ RunTime:0.014389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295868 ORDER BY `unit` DESC [ RunTime:0.010811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295868 LIMIT 2 [ RunTime:0.030229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295868 ORDER BY `minOrder` ASC [ RunTime:0.012505s ]
select * from pdf where partno='5KP110A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.008120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.043295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295647 LIMIT 5 [ RunTime:0.030850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295647 ORDER BY `minOrder` ASC [ RunTime:0.023799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295647 ORDER BY `unit` DESC [ RunTime:0.008453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295647 LIMIT 2 [ RunTime:0.011639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295647 ORDER BY `minOrder` ASC [ RunTime:0.016549s ]
select * from pdf where partno='5KP110A_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.054321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP110A_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.059555s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295647 AND `partno` = '5KP110A_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.034714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821527 [ RunTime:0.034477s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018651s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026136s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022861s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011277s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045307s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016874s ]
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 '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032010s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5KP110A%' OR `brand` LIKE '5KP110A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.033459s ]