SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003272s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.24' , `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=5KP16&search=1' [ RunTime:0.002180s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001704s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001076s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001590s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.24' ) [ RunTime:0.003238s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001233s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002080s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001458s ]
SELECT * FROM `stock_search` WHERE `partno` = '5KP16' LIMIT 1 [ RunTime:0.004390s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-18 19:20:59' WHERE `partno` = '5KP16' [ RunTime:0.006287s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003840s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026569s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822917 LIMIT 5 [ RunTime:0.004246s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822917 ORDER BY `minOrder` ASC [ RunTime:0.001743s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14822917 ORDER BY `unit` DESC [ RunTime:0.013703s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14822917 LIMIT 2 [ RunTime:0.004093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822917 ORDER BY `minOrder` ASC [ RunTime:0.004745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904541 LIMIT 5 [ RunTime:0.004308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904541 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904541 ORDER BY `unit` DESC [ RunTime:0.009080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904541 LIMIT 2 [ RunTime:0.008081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904541 ORDER BY `minOrder` ASC [ RunTime:0.002745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801450 LIMIT 5 [ RunTime:0.012110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801450 ORDER BY `minOrder` ASC [ RunTime:0.005079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801450 ORDER BY `unit` DESC [ RunTime:0.002758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801450 LIMIT 2 [ RunTime:0.014453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801450 ORDER BY `minOrder` ASC [ RunTime:0.004700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822908 LIMIT 5 [ RunTime:0.021175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822908 ORDER BY `minOrder` ASC [ RunTime:0.014592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14822908 ORDER BY `unit` DESC [ RunTime:0.015941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14822908 LIMIT 2 [ RunTime:0.006071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822908 ORDER BY `minOrder` ASC [ RunTime:0.002397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823307 LIMIT 5 [ RunTime:0.007943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823307 ORDER BY `minOrder` ASC [ RunTime:0.004188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823307 ORDER BY `unit` DESC [ RunTime:0.015041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823307 LIMIT 2 [ RunTime:0.006016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823307 ORDER BY `minOrder` ASC [ RunTime:0.010171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904527 LIMIT 5 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904527 ORDER BY `minOrder` ASC [ RunTime:0.011591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904527 ORDER BY `unit` DESC [ RunTime:0.003033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904527 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904527 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660896 LIMIT 5 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660896 ORDER BY `minOrder` ASC [ RunTime:0.014223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16660896 ORDER BY `unit` DESC [ RunTime:0.003180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16660896 LIMIT 2 [ RunTime:0.001707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660896 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683092 LIMIT 5 [ RunTime:0.002440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683092 ORDER BY `minOrder` ASC [ RunTime:0.006792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683092 ORDER BY `unit` DESC [ RunTime:0.004083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683092 LIMIT 2 [ RunTime:0.003775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683092 ORDER BY `minOrder` ASC [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904419 LIMIT 5 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904419 ORDER BY `minOrder` ASC [ RunTime:0.003423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904419 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904419 LIMIT 2 [ RunTime:0.010492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904419 ORDER BY `minOrder` ASC [ RunTime:0.010975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799374 LIMIT 5 [ RunTime:0.009475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799374 ORDER BY `minOrder` ASC [ RunTime:0.007452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799374 ORDER BY `unit` DESC [ RunTime:0.021236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799374 LIMIT 2 [ RunTime:0.029940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799374 ORDER BY `minOrder` ASC [ RunTime:0.016986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683104 LIMIT 5 [ RunTime:0.024262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683104 ORDER BY `minOrder` ASC [ RunTime:0.010714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683104 ORDER BY `unit` DESC [ RunTime:0.013131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683104 LIMIT 2 [ RunTime:0.008337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683104 ORDER BY `minOrder` ASC [ RunTime:0.003299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802903 LIMIT 5 [ RunTime:0.004943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802903 ORDER BY `minOrder` ASC [ RunTime:0.031111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802903 ORDER BY `unit` DESC [ RunTime:0.006192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802903 LIMIT 2 [ RunTime:0.011675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802903 ORDER BY `minOrder` ASC [ RunTime:0.004813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689914 LIMIT 5 [ RunTime:0.005086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689914 ORDER BY `minOrder` ASC [ RunTime:0.005335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689914 ORDER BY `unit` DESC [ RunTime:0.008132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689914 LIMIT 2 [ RunTime:0.000982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689914 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689886 LIMIT 5 [ RunTime:0.008706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689886 ORDER BY `minOrder` ASC [ RunTime:0.027150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689886 ORDER BY `unit` DESC [ RunTime:0.008478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689886 LIMIT 2 [ RunTime:0.004835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689886 ORDER BY `minOrder` ASC [ RunTime:0.003874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683680 LIMIT 5 [ RunTime:0.004377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683680 ORDER BY `minOrder` ASC [ RunTime:0.011338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683680 ORDER BY `unit` DESC [ RunTime:0.018325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683680 LIMIT 2 [ RunTime:0.001206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683680 ORDER BY `minOrder` ASC [ RunTime:0.004423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683679 LIMIT 5 [ RunTime:0.007775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683679 ORDER BY `minOrder` ASC [ RunTime:0.000896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683679 ORDER BY `unit` DESC [ RunTime:0.009263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683679 LIMIT 2 [ RunTime:0.002714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683679 ORDER BY `minOrder` ASC [ RunTime:0.002702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683508 LIMIT 5 [ RunTime:0.011277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683508 ORDER BY `minOrder` ASC [ RunTime:0.017587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683508 ORDER BY `unit` DESC [ RunTime:0.019422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683508 LIMIT 2 [ RunTime:0.020605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683508 ORDER BY `minOrder` ASC [ RunTime:0.009866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683507 LIMIT 5 [ RunTime:0.003872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683507 ORDER BY `minOrder` ASC [ RunTime:0.015326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683507 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683507 LIMIT 2 [ RunTime:0.004122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683507 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681206 LIMIT 5 [ RunTime:0.017815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681206 ORDER BY `minOrder` ASC [ RunTime:0.010221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681206 ORDER BY `unit` DESC [ RunTime:0.018326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681206 LIMIT 2 [ RunTime:0.006692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681206 ORDER BY `minOrder` ASC [ RunTime:0.002315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681128 LIMIT 5 [ RunTime:0.007563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681128 ORDER BY `minOrder` ASC [ RunTime:0.005545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681128 ORDER BY `unit` DESC [ RunTime:0.004746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681128 LIMIT 2 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681128 ORDER BY `minOrder` ASC [ RunTime:0.002744s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140850 LIMIT 5 [ RunTime:0.002637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140850 ORDER BY `minOrder` ASC [ RunTime:0.007372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140850 ORDER BY `unit` DESC [ RunTime:0.014926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140850 LIMIT 2 [ RunTime:0.014603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140850 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
select * from pdf where partno='5kp160a-e3/54' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.009422s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp160a-e3/54' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.004382s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140850 AND `partno` = '5kp160a-e3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.011360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026255 [ RunTime:0.001828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026255 LIMIT 5 [ RunTime:0.015701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026255 ORDER BY `minOrder` ASC [ RunTime:0.017920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026255 ORDER BY `unit` DESC [ RunTime:0.004352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026255 LIMIT 2 [ RunTime:0.011113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026255 ORDER BY `minOrder` ASC [ RunTime:0.003043s ]
select * from pdf where partno='5kp160a-e3/54' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.000492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp160a-e3/54' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.000426s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026255 AND `partno` = '5kp160a-e3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.011545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140850 [ RunTime:0.009992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140774 LIMIT 5 [ RunTime:0.005750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140774 ORDER BY `minOrder` ASC [ RunTime:0.017699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140774 ORDER BY `unit` DESC [ RunTime:0.017211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140774 LIMIT 2 [ RunTime:0.008940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140774 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
select * from pdf where partno='5kp16ca' and brandshort='littelfuse' limit 1 [ RunTime:0.003417s ]
select foldpath,foldpath2,filename from pdf_file where id=854533 limit 1 [ RunTime:0.001922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp16ca' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.018966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51025996 LIMIT 5 [ RunTime:0.003719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025996 ORDER BY `minOrder` ASC [ RunTime:0.014074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51025996 ORDER BY `unit` DESC [ RunTime:0.004384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51025996 LIMIT 2 [ RunTime:0.002146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025996 ORDER BY `minOrder` ASC [ RunTime:0.002580s ]
select * from pdf where partno='5kp16ca' and brandshort='littelfuse' limit 1 [ RunTime:0.000779s ]
select foldpath,foldpath2,filename from pdf_file where id=854533 limit 1 [ RunTime:0.000431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp16ca' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.000851s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122281 LIMIT 5 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122281 ORDER BY `minOrder` ASC [ RunTime:0.001393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122281 ORDER BY `unit` DESC [ RunTime:0.010116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122281 LIMIT 2 [ RunTime:0.000948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122281 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
select * from pdf where partno='5KP16CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005103s ]
SELECT `id` FROM `stock` WHERE `id` <> 42122281 AND `partno` = '5KP16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822917 [ RunTime:0.009340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122293 LIMIT 5 [ RunTime:0.009128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122293 ORDER BY `minOrder` ASC [ RunTime:0.011182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122293 ORDER BY `unit` DESC [ RunTime:0.001043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122293 LIMIT 2 [ RunTime:0.007315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122293 ORDER BY `minOrder` ASC [ RunTime:0.008261s ]
select * from pdf where partno='5KP160A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.042001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.020337s ]
SELECT `id` FROM `stock` WHERE `id` <> 42122293 AND `partno` = '5KP160A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822908 [ RunTime:0.001115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42164337 LIMIT 5 [ RunTime:0.013379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164337 ORDER BY `minOrder` ASC [ RunTime:0.051429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42164337 ORDER BY `unit` DESC [ RunTime:0.025063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42164337 LIMIT 2 [ RunTime:0.014482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164337 ORDER BY `minOrder` ASC [ RunTime:0.004286s ]
select * from pdf where partno='5KP160A' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.016053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160A' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.017271s ]
SELECT `id` FROM `stock` WHERE `id` <> 42164337 AND `partno` = '5KP160A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.022501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42164333 LIMIT 5 [ RunTime:0.019166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164333 ORDER BY `minOrder` ASC [ RunTime:0.020636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42164333 ORDER BY `unit` DESC [ RunTime:0.014834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42164333 LIMIT 2 [ RunTime:0.020873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164333 ORDER BY `minOrder` ASC [ RunTime:0.020856s ]
select * from pdf where partno='5KP160CA' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.014186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160CA' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.013056s ]
SELECT `id` FROM `stock` WHERE `id` <> 42164333 AND `partno` = '5KP160CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.020942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42137729 LIMIT 5 [ RunTime:0.010852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137729 ORDER BY `minOrder` ASC [ RunTime:0.032744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42137729 ORDER BY `unit` DESC [ RunTime:0.007920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42137729 LIMIT 2 [ RunTime:0.022776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137729 ORDER BY `minOrder` ASC [ RunTime:0.010027s ]
select * from pdf where partno='5KP160CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.023121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.021696s ]
SELECT `id` FROM `stock` WHERE `id` <> 42137729 AND `partno` = '5KP160CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.024638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904541 [ RunTime:0.015168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42157608 LIMIT 5 [ RunTime:0.021910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157608 ORDER BY `minOrder` ASC [ RunTime:0.008585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42157608 ORDER BY `unit` DESC [ RunTime:0.010093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42157608 LIMIT 2 [ RunTime:0.017609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157608 ORDER BY `minOrder` ASC [ RunTime:0.005889s ]
select * from pdf where partno='5KP16A_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.011596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16A_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001597s ]
SELECT `id` FROM `stock` WHERE `id` <> 42157608 AND `partno` = '5KP16A_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.005909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801450 [ RunTime:0.009718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136911 LIMIT 5 [ RunTime:0.009043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136911 ORDER BY `minOrder` ASC [ RunTime:0.022680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136911 ORDER BY `unit` DESC [ RunTime:0.020656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136911 LIMIT 2 [ RunTime:0.015225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136911 ORDER BY `minOrder` ASC [ RunTime:0.001869s ]
select * from pdf where partno='5KP160A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.018332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.024003s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136911 AND `partno` = '5KP160A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.026638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904527 [ RunTime:0.015034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136394 LIMIT 5 [ RunTime:0.025851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136394 ORDER BY `minOrder` ASC [ RunTime:0.010847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136394 ORDER BY `unit` DESC [ RunTime:0.022432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136394 LIMIT 2 [ RunTime:0.027795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136394 ORDER BY `minOrder` ASC [ RunTime:0.012120s ]
select * from pdf where partno='5KP16A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.020624s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136394 AND `partno` = '5KP16A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.011923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904419 [ RunTime:0.008911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136368 LIMIT 5 [ RunTime:0.014312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136368 ORDER BY `minOrder` ASC [ RunTime:0.049257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136368 ORDER BY `unit` DESC [ RunTime:0.028322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136368 LIMIT 2 [ RunTime:0.034875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136368 ORDER BY `minOrder` ASC [ RunTime:0.023598s ]
select * from pdf where partno='5KP16CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.025852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.033911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136413 LIMIT 5 [ RunTime:0.023719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136413 ORDER BY `minOrder` ASC [ RunTime:0.022874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136413 ORDER BY `unit` DESC [ RunTime:0.021808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136413 LIMIT 2 [ RunTime:0.039132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136413 ORDER BY `minOrder` ASC [ RunTime:0.018883s ]
select * from pdf where partno='5KP16CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.032517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.025014s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136413 AND `partno` = '5KP16CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.009500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660896 [ RunTime:0.023444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136913 LIMIT 5 [ RunTime:0.052737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136913 ORDER BY `minOrder` ASC [ RunTime:0.020982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136913 ORDER BY `unit` DESC [ RunTime:0.027393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136913 LIMIT 2 [ RunTime:0.043812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136913 ORDER BY `minOrder` ASC [ RunTime:0.004269s ]
select * from pdf where partno='5KP160CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.018486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.009711s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136913 AND `partno` = '5KP160CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.029598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799374 [ RunTime:0.026040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136833 LIMIT 5 [ RunTime:0.021809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136833 ORDER BY `minOrder` ASC [ RunTime:0.016152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136833 ORDER BY `unit` DESC [ RunTime:0.044320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136833 LIMIT 2 [ RunTime:0.015777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136833 ORDER BY `minOrder` ASC [ RunTime:0.018724s ]
select * from pdf where partno='5KP16A-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.008082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16A-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42177272 LIMIT 5 [ RunTime:0.019163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42177272 ORDER BY `minOrder` ASC [ RunTime:0.017788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42177272 ORDER BY `unit` DESC [ RunTime:0.024798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42177272 LIMIT 2 [ RunTime:0.020307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42177272 ORDER BY `minOrder` ASC [ RunTime:0.016145s ]
select * from pdf where partno='5KP16A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.015706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.009595s ]
SELECT `id` FROM `stock` WHERE `id` <> 42177272 AND `partno` = '5KP16A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.007459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823307 [ RunTime:0.001949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414800 LIMIT 5 [ RunTime:0.018390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414800 ORDER BY `minOrder` ASC [ RunTime:0.007678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414800 ORDER BY `unit` DESC [ RunTime:0.007298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414800 LIMIT 2 [ RunTime:0.011932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414800 ORDER BY `minOrder` ASC [ RunTime:0.014682s ]
select * from pdf where partno='5KP160CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006247s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414800 AND `partno` = '5KP160CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.008273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823930 [ RunTime:0.010156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414799 LIMIT 5 [ RunTime:0.023908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414799 ORDER BY `minOrder` ASC [ RunTime:0.016529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414799 ORDER BY `unit` DESC [ RunTime:0.027787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414799 LIMIT 2 [ RunTime:0.042561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414799 ORDER BY `minOrder` ASC [ RunTime:0.023930s ]
select * from pdf where partno='5KP160A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.026082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.053953s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414799 AND `partno` = '5KP160A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.032827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925027 [ RunTime:0.037072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414640 LIMIT 5 [ RunTime:0.041665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414640 ORDER BY `minOrder` ASC [ RunTime:0.037139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414640 ORDER BY `unit` DESC [ RunTime:0.032561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414640 LIMIT 2 [ RunTime:0.050976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414640 ORDER BY `minOrder` ASC [ RunTime:0.005460s ]
select * from pdf where partno='5KP16CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.044424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.011391s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414640 AND `partno` = '5KP16CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.020808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683680 [ RunTime:0.020875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414639 LIMIT 5 [ RunTime:0.020265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414639 ORDER BY `minOrder` ASC [ RunTime:0.005173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414639 ORDER BY `unit` DESC [ RunTime:0.016530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414639 LIMIT 2 [ RunTime:0.022609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414639 ORDER BY `minOrder` ASC [ RunTime:0.003393s ]
select * from pdf where partno='5KP16A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.016036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.011172s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414639 AND `partno` = '5KP16A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683679 [ RunTime:0.005523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42412423 LIMIT 5 [ RunTime:0.001646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412423 ORDER BY `minOrder` ASC [ RunTime:0.009670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42412423 ORDER BY `unit` DESC [ RunTime:0.002820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42412423 LIMIT 2 [ RunTime:0.005751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412423 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='5KP160CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007380s ]
SELECT `id` FROM `stock` WHERE `id` <> 42412423 AND `partno` = '5KP160CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683508 [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42412422 LIMIT 5 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412422 ORDER BY `minOrder` ASC [ RunTime:0.002659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42412422 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42412422 LIMIT 2 [ RunTime:0.001430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412422 ORDER BY `minOrder` ASC [ RunTime:0.009294s ]
select * from pdf where partno='5KP160A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP160A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000717s ]
SELECT `id` FROM `stock` WHERE `id` <> 42412422 AND `partno` = '5KP160A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683507 [ RunTime:0.002959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42411268 LIMIT 5 [ RunTime:0.011112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411268 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42411268 ORDER BY `unit` DESC [ RunTime:0.002332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42411268 LIMIT 2 [ RunTime:0.001096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411268 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
select * from pdf where partno='5KP16CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP16CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001363s ]
SELECT `id` FROM `stock` WHERE `id` <> 42411268 AND `partno` = '5KP16CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823720 [ RunTime:0.003599s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001457s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003453s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004054s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001083s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007317s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001200s ]
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 '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006889s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5KP16%' OR `brand` LIKE '5KP16%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002004s ]